August 16, 2004 at 9:25 pm
Hi all,
We are having backups of seven production databases from one of our clients. They have taken the backup and sent it for configuring here at the development center. The database size is pretty big (47 GB, 45 GB, 25 GB, 360MB and so on). We were able to restore the smaller databases. But for the bigger ones, we are facing a problem. We are getting Interbal Consistency error when restoring. We talked to the client. They informed us that, they were able to restore it from this backup files.
Please help me out in soriting this issue. Is it becuase of the system configuration? At the client site, they are using high end servers. But we are testing it with Desktop servers. Any RAM problems or something like that? Because we were able to restore the smaller databases...
We tried the SP_HELPSORT and compared the results from the client SQL Server installation and ours. Both are same. Please let me know, if anybody has got a solution for this "Internal Consistency Error"
Thanks and Regards
Anup
August 17, 2004 at 12:52 am
look if the path of the mdf and the ldf file is same as in the client side while in restoration process i.e the location of the sql server loaded on client side system and system at ur side is same or not.
August 17, 2004 at 1:08 am
Hi Rajan,
It is the same.
Thanks and Regards
Anup
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply