Backup Error...Sector Size

• homebrew01

  SSC Guru

  Points: 55539

  More actions

  March 23, 2020 at 3:45 pm

  #3736300

  I am at a new job, looking at various servers. I'm not officially DBA, but looking for problems or things that need improving.

  I just logged onto a server at a remote location, and saw this error in a backup job. I also saw completed backup jobs, that may be running 3rd party backups or snapshots.

  This error is from a native SQL backup job. Maybe caused by some change in removable drive target ?

  Executed as user: MYDOMAIN\MMI_SQLSVC. Cannot use the backup file '\\DRIVE_FP\MMISQLIDBackup\MYBackup' because it was originally formatted with sector size 4096 and is now on a device with sector size 512. [SQLSTATE 42000] (Error 3268)  BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013).  The step failed.

   

  Backup step is running:

  BACKUP DATABASE [master]

  TO  DISK = N'\\DRIVE_FP\MMISQLIDBackup\Master_Backup'

  WITH NOFORMAT, INIT,  NAME = N'master-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10

  GO

   

  EDIT...Looks like separate snapshot "backups" are also running,:

  BACKUP DATABASE [master] TO VIRTUAL_DEVICE='{3A54F0F2-1987-4D2A-92BE-6B1AB11E54FF}7' WITH SNAPSHOT,BUFFERCOUNT=1,BLOCKSIZE=1024

   

  • This topic was modified 4 years, 1 month ago by  homebrew01.
  • This topic was modified 4 years, 1 month ago by  homebrew01.

• Ken McKelvey

  SSCoach

  Points: 18766

  More actions

  March 24, 2020 at 11:02 am

  #3736549

  https://blog.sqlauthority.com/2016/08/25/sql-server-fix-error-cannot-use-backup-file-originally-formatted-sector-size-4096-now-device-sector-size-512/

  https://stackoverflow.com/questions/22448818/backup-a-database-on-a-hdd-with-a-different-sector-size

  Also, if you are taking over a server run the following:

  SELECT * FROM msdb.dbo.suspect_pages;

  Hopefully nothing will be returned.