Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-07-21 : 09:41:27
|
| Rick writes "I have a SQL 2000 - SP4 database that is working and get backed up daily. I am trying to restore any of the backups from this database from the past 4 months. All of them get an error when restoring."A possible database consistency problem has been detected on the database 'db_name'. DBCC CHECKDB and DBCC CHECKCATALOG should be run on the datbase 'db_name'"I need 700 records from one of the tables from that backup.Is there any possible way to recover data from those backups?Thanks!" |
|
|
gugarc
Starting Member
17 Posts |
Posted - 2006-07-21 : 14:35:31
|
| Did you try to restore that backup in a new database? (may be the corruption isn´t in the backups, but in the database itself) -it´s worth trying. |
 |
|
|
|
|
|
SQL 2000 - SP4 Consistency problem