May 12, 2010 at 8:40 am
Hi All,
We've tried to use backup exec 11d to do a restore to a database and it failed and now the database is stuck in 'Loading' and I'm not quite sure how to get it out of this. could anyone point me in the right direction?
May 12, 2010 at 8:51 am
If the restore started, then the old database is gone. Once the restore starts, the files are changed and you can't "undo" the restore.
Did the restore complete and then fail? you can try
restore database xxxx WITH RECOVERY
However, my guess is you'll need to do a restore.
This is why I DO NOT use SQL agents, ever, for backups. Backup to a file, let backup exec pick up the backup file like any other file.
May 12, 2010 at 8:59 am
Thanks for the quick response 🙂
It failed during the restore, it failed a few times yesterday when we were doing it and it had no major effect however when we tried it this morning it seemed to just get stuck in 'loading'
I've tried the DATABASE RESTORE xxxx WITH RECOVERY and it just times out.
May 12, 2010 at 9:03 am
Drop the database and try the restore again.
You say the restore failed. With what error?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 13, 2010 at 1:25 am
I'll go into the backup exec logs after and paste the error.
We ended up just restoring the backup from the previous night to a different database name and yet it brought the original database out of 'loading' and its workin ok so far.... confused.com!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply