Astaamaha:
Markaad iskudayeyso inaad ku lifaaqdo keydka xogta .MDF SQL Server, waxaad aragtaa fariinta qaladka soo socota:
Waa lagu guuldareystay in dib loo helo xogta codsigan. (Microsoft.SqlServer.Management.Sdk.Sfc)
Ka reebitaan ayaa dhacay inta lagu gudajiro fulinta qoraalka Transact-SQL ama dufcad. (Microsoft.SqlServer.ConnectionInfo)
xxx.mdf ma aha faylka keydka aasaasiga ah. (Microsoft SQL Server, Khalad: 5171)
halka 'xxx.mdf uu yahay magaca faylka MDF ee lagu lifaaqayo.
Screenshot of message qalad:
Sharaxaad qeexan:
Xogta ku jirta faylka MDF waxaa lagu keydiyaa sida bogag, bog walbana waa 8KB. Bogga koowaad waxaa loo yaqaan bogga faylka cinwaanka bogga, kaasoo ay ku jiraan most macluumaad muhiim ah oo ku saabsan feylka oo dhan, sida saxiixa faylka, cabirka faylka, iswaafajinta, iwm Bogagga haray waxay sidoo kale ku jiraan macluumaadka muhiimka ah, oo ay ku jiraan macluumaadka u qoondaynta bogga iyo sidoo kale xogta dhabta ah.
Haddii faylka MDF faylka cinwaanka bogga, ama bogagga kale ee maareynta muhiimka ah ay waxyeelloobeen ama kharribeen, oo aan Microsoft aqoonsan karin SQL Server, ka dibna SQL Server waxay u maleyneysaa in feylka oo dhan uusan aheyn feylasha aasaasiga ee aasaasiga ah isla markaana soo sheega qaladkan.
Waxaad isticmaali kartaa badeecadeena DataNumen SQL Recovery si looga soo kiciyo xogta faylka MDF musuqmaasuqa ah loona xalliyo qaladkan.
Muunado Faylal:
Muunad faylalka MDF musuqmaasuq ah oo khalad sababi doona:
SQL Server version | Faylka MDF musuqmaasuq | Faylka MDF waxaa hagaajiyay DataNumen SQL Recovery |
SQL Server 2005 | Khalad1_1.mdf | Khalad1_1_fixed.mdf |
SQL Server 2008 R2 | Khalad1_2.mdf | Khalad1_2_fixed.mdf |
SQL Server 2012 | Khalad1_3.mdf | Khalad1_3_fixed.mdf |
SQL Server 2014 | Khalad1_4.mdf | Khalad1_4_fixed.mdf |