Restoring Database Problems

• criswes

  SSC Enthusiast

  Points: 193

  More actions

  April 15, 2004 at 6:11 am

  #108038

  My name is Cristiano , and i have a problem restoring one Database...

  Before restore I see the View contents , and just ok but when is ending the restore this message appears...

  Please , can someone help me?

  

• vime

  SSC-Addicted

  Points: 496

  More actions

  April 15, 2004 at 6:26 am

  #502902

  Cristiano, what is the error message?, it doesn't appear on the post

• criswes

  SSC Enthusiast

  Points: 193

  More actions

  April 15, 2004 at 6:43 am

  #502908

  A message box appears to me , only with this...

  Microsoft SQL-DMO(ODBC SQLState : 42000 )

  An internal consistency error occcurred. Contact Techinal Support for assistance.Backup and restore operation terminally abnormally.

  ok button...

  I tried to restore a backup from disk, but the file was restored from a tape.

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  April 15, 2004 at 7:38 am

  #502927

  Try this:

  restore VERIFYONLY FROM [YourBackupDevice]

• criswes

  SSC Enthusiast

  Points: 193

  More actions

  April 15, 2004 at 1:19 pm

  #503013

  IT'S OK , THE BACKUP IS VERIFY CORRECTLY, WHAT IS THE NEXT STEP...????

• Alamir

  SSCertifiable

  Points: 6085

  More actions

  April 19, 2004 at 3:48 am

  #503280

  do u apply SQL Server SP3a on the server?.. also apply MDAC 2.7 SP1 (if you want )

  i hope this solve the problem

  
  Alamir Mohamed
  Alamir_mohamed@yahoo.com