March 23, 2020 at 3:45 pm
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
March 24, 2020 at 11:02 am
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.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy