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: Wednesday, February 12, 2014 7:00 AM
Points: 6, Visits: 104
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 @ 8:25 AM
Points: 43,016, Visits: 36,177
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: Wednesday, February 12, 2014 7:00 AM
Points: 6, Visits: 104
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 @ 8:25 AM
Points: 43,016, Visits: 36,177
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: Wednesday, February 12, 2014 7:00 AM
Points: 6, Visits: 104
Same error...
Even if i change the backup to a local drive.
Post #1466647
Posted Wednesday, September 10, 2014 5:31 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 5:36 AM
Points: 21, Visits: 23
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 @ 12:38 AM
Points: 33,267, Visits: 15,436
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
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse