Restore corruption error

• John Langston

  SSCommitted

  Points: 1977

  More actions

  December 29, 2005 at 3:48 pm

  #166510

  Paul:

  Here is the message that I received:

  An internal consistency error occurred. Contact Technical Support for assistance. [SQLSTATE 42000] (Error 3270)  RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013).  The step failed.

  This occurred when trying to restore from a database backup.  BTW, CHECKDB doesn't show any errors.

  Is the only option to go to another backup file?

  Thanks,

  John L.

   

• January 2, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Paul Randal

  One Orange Chip

  Points: 29544

  More actions

  January 5, 2006 at 10:54 am

  #612964

  This indicates that your backup is corrupt in some way. Can you try the restore command manually and see if there are any more errors? Can you also post the restore output from the SQL errorlog?

  Thanks

  Paul Randal
  CEO, SQLskills.com: Check out SQLskills online training!
  Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
  SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
  Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

• Minaz Amin

  SSChampion

  Points: 11052

  More actions

  June 29, 2006 at 5:17 am

  #646611

  Hi,

  This might help.

  http://support.microsoft.com/kb/290787/en-us

  Regards,

  Minaz Amin

  "More Green More Oxygen !! Plant a tree today"