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