backup with checksum failes, dbcc checkdb is ok

Question

backup with checksum failes, dbcc checkdb is ok

UV

Old Hand

Points: 395
More actions
June 24, 2013 at 12:00 am

#278954

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?

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

UV Old Hand Points: 395 More actions · Answer 2

When i backup without the checksum option, the backup runs ok...

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

UV Old Hand Points: 395 More actions · Answer 4

Same error...

Even if i change the backup to a local drive.

enriquemallon Ten Centuries Points: 1239 More actions · Answer 5

Checksum failed for db1.mdf and you run checkdb for Mydb. I guess they both are same.

Steve Jones - SSC Editor SSC Guru Points: 738160 More actions · Answer 6

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?

TorfiAlfonsson Grasshopper Points: 17 More actions · Answer 7

get info here: SQL Server Fix Toolbox

Use this site: http://www.fixsqldatabase.com/%5B/url%5D

UV Old Hand Points: 395 More actions · Answer 8

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.

backup with checksum failes, dbcc checkdb is ok

Cookies on SQLServerCentral