Mssql Backup a database on a HDD with a different sector size

 
Error 

----
System.Data.SqlClient.SqlError: Cannot use the backup file 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Backup\EntDeptMCQDB.bak' because it was originally formatted with sector size 4096 and is now on a device with sector size 512. (Microsoft.SqlServer.Smo)


Solution

----

BACKUP DATABASE [EntDeptMCQDB] 

TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Backup\EntDeptMCQDB_full.bak' 

WITH NOFORMAT, NOINIT,  

NAME = N'EntDeptMCQDB_full.bak', 

SKIP, NOREWIND, NOUNLOAD,  STATS = 10

GO



留言

這個網誌中的熱門文章

香港袐密行動

要老是忘記, 我更記不起