DB Restore Status Remains

• 
  Can you post the restore script?

  chriskelly January 30, 2013 13:51

  - 0 +
• 
  Used GUI - but, this is in the Activity Log - db name changed for forum posts.
  
  
  SQL Backup log file 7.0.5.1
  
  -SQL "RESTORE DATABASE [ABC_ARCHIVE]
  FROM DISK = '\\servername\foldername\foldername\ABCPROD_FULL_20130109.bak'
  WITH NORECOVERY, DISCONNECT_EXISTING,
  MOVE 'ABCPROD_Data.MDF' TO 'F:\Datafiles\ABC_ARCHIVE_Data.MDF',
  MOVE 'ABCPROD_Log.LDF' TO 'F:\Logfiles\ABC_ARCHIVE_Log.LDF',
  REPLACE "

  noob2013 January 30, 2013 14:47

  - 0 +
• 
  Did you check this message out? Look for Error trying to Restore DB & Move files with NORECOVERY in this forum. It looks pretty similar.
  
  HTH
  
  Chris

  ChrisAVWood January 30, 2013 15:51

  - 0 +
• 
  If you meant this thread
  http://www.red-gate.com/messageboard/vi ... norecovery
  
  the thread OP got an error. I do not have an error. In fact, the Activity Log reports restore process completed successfully. However, on both SQL Backup and SSMS, that particular database has the status "restoring ...". And it has been there for 2 days; but the SQL Backup suggests the restore completed successfully in about 1 hour and 27 mins.

  noob2013 January 30, 2013 16:13

  - 0 +
• 
  Have you looked at the actual size of the files after the 'successfull' restore? In this case the files will be allocated and then filled by the backed up data.
  
  I am sure something will be in the logs that show what has happened.
  
  Chris

  ChrisAVWood January 30, 2013 16:17

  - 0 +
• 
  NORECOVERY means it is not available for use. You need to use RECOVERY.
  
  Chris

  ChrisAVWood January 30, 2013 16:19

  - 0 +
• 
  Yes I did. The ABC_ARCHIVE database data file is 771GB and log file is 18 GB - which is the same size as the ABCPROD database on the day the backup was taken.
  
  To rule out the hard disk space (at first I thought it was the hard disk space issue failure); I still have 2.8 Terabytes on that drive where the data & log files are located.

  noob2013 January 30, 2013 16:24

  - 0 +
• 

  ChrisAVWood wrote:

  NORECOVERY means it is not available for use. You need to use RECOVERY.
  
  Chris

  
  I'm going to try restore with recovery.

  noob2013 January 30, 2013 16:32

  - 0 +
• 
  Did the RECOVERY option work?
  I am curious.
  
  Chris

  ChrisAVWood February 01, 2013 12:59

  - 0 +
• 
  Sorry for the late reply.
  Yes it did.

  noob2013 April 10, 2013 12:52

  - 0 +

Add comment

Please sign in to leave a comment.