SOTI Pulse Logo

DACPAC: DAC Message: Error SQL72014

JV
Jerry V. Mohn

 Upgrade Fails with DB error and DB install log shows below error! What does this error means and how can we address it? Please note that MobiControl and Database reside on two separate servers.

DACPAC: DAC Message: Error SQL72014: .Net SqlClient Data Provider: Msg 3268, Level 16, State 1, Line 280 Cannot use the backup file 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\MobiControlDB_Migration.bak' because it was originally formatted with sector size 512 and is now on a device with sector size 4096.

 

dacpac
8 years ago
SOTI MobiControl
ANSWERS
AR
Atif Rasheed
8 years ago (edited 8 years ago)

Dear customer, error indicates that your DB server Disk Drive is formatted with Sector Size 512 and your MobiControl Server Disk Drives are formatted with Sector size 4096 bytes. Now this could be same filesystem, for example, NTFS but drives formatted with different sector size, or, it could be two different file systems altogether, for example, NTFS on MobiControl Server and FAT on Database Server.

 

Below two URL's are very helpful in understanding the file system structure and why this sector size matters.

 

https://blogs.msdn.microsoft.com/psssql/2011/01/13/sql-server-new-drives-use-4k-sector-size/

https://blogs.msdn.microsoft.com/psssql/2013/05/15/sql-serverstorage-spacesvhdx-and-4k-sector-size/

 

A quick way forward could be to upgrade the DB filesystem to same specification as MobiControl Server which will allow SQL backup and restore to happen as backup/restore is an essential part of the MobiControl upgrade process.

Similar Discussions