Restoring SQL2005 database

[Jajones]

I have Netbackup 7.0.1 on Server 2003.  My SQL machine is running SQL2005.  I am trying to restore 2 dbs.  I am able to successfully restore them according to Netbackup, but when I go into SQL it has the databes as restoring.  This is the second time I have done this, last time I canceled it after 16 hours or so of "Restoring".  My question is, how long does this process usually take?

[Marianne · Accepted solution]

Please tell us more about your restore selection.

Have you selected transaction logs in addtion to databases?

Have you selected 'recovered' from the Recovery list?

The 'Restoring' state is similar to 'loading' status in previous versions. See: http://www.symantec.com/docs/TECH45390

[MKT]

If Netbackup is complete but SQL indicates not, the restore was done with a 'Recovery Option' -> not recovered.  SQL is waiting pending additional restores (trx logs or differential)  Since you don't want this, I would restore with the correct option or you can instruct SQL to bring it up by issueing the command manually:

RESTORE DATABASE xxxx WITH RECOVERY; 

[Mark_Solutions]

Are you doing the restore from the BAR GUI or the SQL Agent GUI?

It must be done via the SQL Agent GUI on the client (the same one that you set up the backup batch files froim but choose File - Restore)