Home > Archive > MS SQL Server > November 2006 > DBCC Consistency Errors after copying the backup file









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author DBCC Consistency Errors after copying the backup file
zerg2k@yahoo.com

2006-11-15, 7:14 pm

Hello,

I am facing a problem that is *very* odd. I am runing DBCC CHECKDB on
my source database with *no errors*, then I take a full database backup
and copy(xcopy,robocopy)
it to another server and restore it there.
Very often I am getting DBCC consistency errors when I run the CHECKDB
on the remote (backup) server.

Has anybody come acrross this? How do you copy your backup files??

Any tip will be really appreciated.

Noel

Uri Dimant

2006-11-16, 5:20 am

Looks strange .Perhaps during the copy process the file is getting
corrupted.
At my company we backup the db , then compres .BAK file by WINRAR and then
copy it. If you have VLDB , consider using third party tool like Litespeed




<zerg2k@yahoo.com> wrote in message
news:1163603641.098898.40150@m7g2000cwm.googlegroups.com...
> Hello,
>
> I am facing a problem that is *very* odd. I am runing DBCC CHECKDB on
> my source database with *no errors*, then I take a full database backup
> and copy(xcopy,robocopy)
it to another server and restore it there.
> Very often I am getting DBCC consistency errors when I run the CHECKDB
> on the remote (backup) server.
>
> Has anybody come acrross this? How do you copy your backup files??
>
> Any tip will be really appreciated.
>
> Noel
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com