01-16-2012 12:18 PM
Hello
I'm getting the above error and following when running a backup.
"Database 'ESPECSrestore' cannot be opened. It is in the middle of a restore.
Backup- pecacctgdb.xxxx.xom\ESPECS
V-79-65323-927 -
An error occured on a query to database ESPECSrestore
V-79-65323-927 - Database 'ESPECSrestore' cannont be opened. It is in the middle of a restore."
No other jobs are running, restore or backup.
Thoughts, suggestions & questions are appreciated.
Solved! Go to Solution.
01-16-2012 11:52 PM
refer the followinng document http://www.symantec.com/business/support/index?page=content&id=TECH128042
01-16-2012 11:44 PM
That Database Might be in a state where it is Orphaned during the restore.
I mean it was restored but not comminted with the logs and left for further restore.
Check the SQL instance and check the database for integrity run DBCC check on the database from the SQLmanagement studio
01-16-2012 11:52 PM
refer the followinng document http://www.symantec.com/business/support/index?page=content&id=TECH128042