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
留言
張貼留言