This is interesting, I'm trying to find any help I can on the particular problem we have. This forum is the closest I can find.
Description: SQL server 7 and running a Veritas restore.
Problem : Restore gets to 99% complete on the Veritas restore process, Database is in a state of "(loading)".
Also, the Restore shows the following statement being used by Veritas
RESTORE DATABASE [dbname] FROM virtual_device = 'BackupExecSqlAgent_dbname_00' WITH REPLACE, RECOVERY
It is 'awaiting command' according to sp_who2 under Query analyser and 'sleeping' under EM current activity.
So as far as I can tell, the restore has been done using the RECOVERY option. I can't see why this doesn't appear to complete.
Database is quite large (33GB) and logfile (about 1GB).
How long should this take to finish "loading" or is this likely to be still this way tomorrow morning (about 18 hours from now).
We need this database back and this is a full restore so should bring it all back the way it was when the Backup was taken.
I'm completely confused and don't know what to do next.
Can anyone help me?