Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

backup with checksum failes, dbcc checkdb is ok Expand / Collapse
Author
Message
Posted Monday, June 24, 2013 12:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 4, 2014 2:46 AM
Points: 7, Visits: 106
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?
Post #1466585
Posted Monday, June 24, 2013 2:25 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:14 PM
Points: 40,615, Visits: 37,081
Try the backup again?


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1466627
Posted Monday, June 24, 2013 2:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 4, 2014 2:46 AM
Points: 7, Visits: 106
When i backup without the checksum option, the backup runs ok...
Post #1466631
Posted Monday, June 24, 2013 3:13 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:14 PM
Points: 40,615, Visits: 37,081
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 2008, MVP
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

Post #1466639
Posted Monday, June 24, 2013 3:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 4, 2014 2:46 AM
Points: 7, Visits: 106
Same error...
Even if i change the backup to a local drive.
Post #1466647
Posted Wednesday, September 10, 2014 5:31 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 1:09 AM
Points: 33, Visits: 54
Checksum failed for db1.mdf and you run checkdb for Mydb. I guess they both are same.
Post #1612149
Posted Wednesday, September 10, 2014 9:15 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:11 PM
Points: 31,368, Visits: 15,837
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?







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1612241
Posted Wednesday, October 8, 2014 12:48 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, November 6, 2014 8:19 PM
Points: 121, Visits: 1,251
I guess 'UV' has solved his problem. It is more than 1 year old post.

SQL Database Recovery Expert
Post #1623688
Posted Wednesday, December 3, 2014 7:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 7:08 AM
Points: 1, Visits: 0
get info here: SQL Server Fix Toolbox
Use this site: http://www.fixsqldatabase.com/
Post #1641087
Posted Thursday, December 4, 2014 2:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 4, 2014 2:46 AM
Points: 7, Visits: 106
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.
Post #1641390
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse