I have a database that seems to be functioning fine with no apparent errors except that any full backup taken is broken - attempting a restore fails with an error "RESTORE detected an error on page (18469:-1767164485)"
DBCC CheckDB on the database completes without errors.
The backup is created with the following command:
BACKUP DATABASE @DatabaseName TO DISK = @backupFile1, DISK = @backupFile2, DISK = @backupFile3 WITH COMPRESSION, RETAINDAYS = 0, FORMAT, INIT, SKIP, NAME = @DatabaseName
I just completed a backup using the GUI database backup in case my script was wrong somehow - This gave the same result of a damaged backup.
This only started happening last night. The only significant change that I am aware of is that I changed the 'auto-shrink' option of the database (it was originally set to true).
Is anybody aware of a problem in this area with SQL Server 2012 (specifically I'm on version 11.0.3128)? It could just be coincidence or related to something else entirely but that seems the most likely cause at the moment.
In addition does anybody have any advice on what to do in such a situation? The database is functioning fine (as far as I can determine), but I don't care to be without backups for very long...!