SQL Server Database Restoration - Internal Consistency Error

• Anup-166911

  SSC Enthusiast

  Points: 101

  More actions

  August 16, 2004 at 9:05 am

  #85156

  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

   

   

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  August 16, 2004 at 9:15 am

  #519158

  Run DBCC CheckDB to your original databases to ensure there is no consistency error before backing up and restoring them.