Restore backup problems

• Nuts

  SSCrazy

  Points: 2547

  More actions

  November 2, 2006 at 3:34 pm

  #114940

  Hi guys

  I made a back up of my database on a cd rom drive.

  Now when I am trying to restore these backups, SQL gives an error saying

  "An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

   

  ------------------------------

  ADDITIONAL INFORMATION:

   

  Read on "D:\Backup\RecalculateRSM.bak" failed: 87(error not found)

  RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3203)"

   

  Please help

   

   

  Thanks

  Mita

   

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  November 2, 2006 at 3:43 pm

  #669645

  You need to put the .bak in the Backup sub folder in  Microsoft SQL Server folder in programs and let SQL Server create the file path for you in the backup and restore wizard choose restore form device.  And CD are read only you put it in CD for storage or transport, I have not seen restore from CD if it exist I have not seen it.  Put your .bak in the location below.  Hope this helps.

  C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP

   

   

  Kind regards,
  Gift Peddie

• Nuts

  SSCrazy

  Points: 2547

  More actions

  November 2, 2006 at 4:05 pm

  #669651

  Hi

  thanks for your help..

  I copied my database into the location which u told .But still SQL is giving problems.. It says  "please select a data source"

   

  What do I do ??

   

  Thanks

  Mita

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  November 2, 2006 at 4:13 pm

  #669654

  When you copy it to that location and choose restore from device there should be an ellipse in the wizard click on it for SQL Server to create the file path for you because if you create it yourself it gets confused.  Hope this helps.

   

  Kind regards,
  Gift Peddie