SQL Server Database Restoration - Internal Consistency Error
-
Hi all,
This is regarding the SQL Server database restoration. I have created backups of 7 databases from one of the servers and now trying to restore it in a different database server. Three of my databases are restoring without any problem, but the rest of them fails with the Internal Consistency Error. The database size for the last 4 databases are 47 GB, 46 GB, 29 GB and 355 MB. This is pretty high when compared to the other databases.
I am attaching the error message along this.
Please somebody help meout in solving this probelm. At the client's place, they were able to restore the database. Please help me in solving this.Regards
Anup
-
It's possible you had some problem with the backup. I'd rerun it and include the verify check (see RESTORE VERIFYONLY in BOL).
If this doesn't work, be sure you run a DBCC on the source db and be sure you don't have corruption there. Was there any other information with the error?
-
Hi Steve,
There wasnt any other error message. Only the Internal Consistency Erorr in the pic. But we were able to restore the smaller databases and at the client site, they were able to restore all the databases successfully. Is it because of some system configuration or some memory issues? At client site, they are using hign end servers. We are using desktop servers for testing the database restoration. We even compared the output of SP_helpSort. But that we same too.
Our client, used SQL Server 7 for taking the backup and are trying to restore it in SQL Server 2000. Is there any specific setting to be changed in SQL Server 2000 for the restoration? We even tried it in SQL Server 7. But we were getting the same result.
Please help me in solving this issue.
Thanks and Regards
Anup
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply