June 24, 2013 at 12:00 am
Hi,
I am using SQL Server 2005 standard SP3, doing a backup as follows:
BACKUP DATABASE db1
TO DISK = '\\whatever\DatabaseBackups\db1.BAK'
WITH INIT,
NAME ='Backup data of db1',
CHECKSUM
I am getting the following error:
BACKUP 'db1' detected an error on page (1:107675) in file 'D:\db1.MDF'.
dbcc checkdb is ok:
CHECKDB found 0 allocation errors and 0 consistency errors in database 'MyDb'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Did anyone encountered such a scenario and if so, what is the solution?
June 24, 2013 at 2:25 am
Try the backup again?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2013 at 2:34 am
When i backup without the checksum option, the backup runs ok...
June 24, 2013 at 3:13 am
Yes it will, that's not what I asked.
Try the backup again, exactly as you did before.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2013 at 3:42 am
Same error...
Even if i change the backup to a local drive.
September 10, 2014 at 5:31 am
Checksum failed for db1.mdf and you run checkdb for Mydb. I guess they both are same.
September 10, 2014 at 9:15 am
enriquemallon (9/10/2014)
Checksum failed for db1.mdf and you run checkdb for Mydb. I guess they both are same.
Are these the same? Or two different databases?
December 3, 2014 at 7:10 am
get info here: SQL Server Fix Toolbox
Use this site: http://www.fixsqldatabase.com/%5B/url%5D
December 4, 2014 at 2:19 am
The issue was solved by opening a ticket at MS support.
After a week or so they replied that it was identified as a bug within SQL Server and that it would be fixed in future versions.
Viewing 9 posts - 1 through 9 (of 9 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