Faulty Restore

Until recently we received backups of a clients database
and restored it with no problems. They are running SQL
2000 on NT 4.0. About a month ago we noticed some problem
with the backups, DBCC CHECKDB revealed consistency
errors in the databases after restore. We are running SQL
2000 SP3a on XP Pro. They can restore there backup
locally but when ever we restore them we get errors.
Any help would be very much appreciated.If there are consistency errors with the restored db it is most likely they
exist in the original one. They need to fix the errors in the original db
before you can get good backups.
Andrew J. Kelly SQL MVP
"Geoff Aukett" <anonymous@.discussions.microsoft.com> wrote in message
news:1c6c901c4222c$4b313d00$a301280a@.phx
.gbl...
> Until recently we received backups of a clients database
> and restored it with no problems. They are running SQL
> 2000 on NT 4.0. About a month ago we noticed some problem
> with the backups, DBCC CHECKDB revealed consistency
> errors in the databases after restore. We are running SQL
> 2000 SP3a on XP Pro. They can restore there backup
> locally but when ever we restore them we get errors.
> Any help would be very much appreciated.|||Thats what is so odd, their DBA assures us that they
restore and checkout ok at their end?

>--Original Message--
>If there are consistency errors with the restored db it
is most likely they
>exist in the original one. They need to fix the errors
in the original db
>before you can get good backups.
>--
>Andrew J. Kelly SQL MVP
>
>"Geoff Aukett" <anonymous@.discussions.microsoft.com>
wrote in message
> news:1c6c901c4222c$4b313d00$a301280a@.phx
.gbl...
database[vbcol=seagreen]
problem[vbcol=seagreen]
SQL[vbcol=seagreen]
>
>.
>|||It's possible the backup file itself can get corrupted but in my experience
when this happens you get file errors in most cases. Have they actually run
a full DBCC CHECKDB abd DBCC CHECKCATALOG lately?
Andrew J. Kelly SQL MVP
<anonymous@.discussions.microsoft.com> wrote in message
news:1cd0401c422b6$a765dec0$a401280a@.phx
.gbl...[vbcol=seagreen]
> Thats what is so odd, their DBA assures us that they
> restore and checkout ok at their end?
>
> is most likely they
> in the original db
> wrote in message
> database
> problem
> SQL