cancel
Showing results for 
Search instead for 
Did you mean: 

SQL backup fails with "middle of restore" message

Ken_Grunstra
Level 3
I have an SQL backup job that has been failing consistenly for the past 4 days with the message, "Database cannot be opened. It is in the middle of a restore." The database is not in the middle of a restore. Does anyone know what might cause this?
3 REPLIES 3

Ajit_Kulkarni
Level 6
Hello


Is this error message occuring while taking a backup or during a restore ?

What is the version of SQL ?

Is it installed on the same server of Backup Exec or on remote server ?

Please mention the exact error message.


Regards



NOTE : If we do not receive your reply within two business days, this post would be marked "assumed answered" and would be moved to "answered questions" pool.

Ken_Grunstra
Level 3
1. The error message occurs during a backup.

2. SQL 2000 Version 7.

3. Installed on remote server.

4. Error message:
An error occurred on a query to database BackOrder.
V-79-57344-33938 - Database 'BackOrder' cannot be opened. It is in the middle of a restore.

Amruta_Bhide
Level 6
Hello Ken,

Following Article will help you:
http://support.veritas.com/docs/229542

******************************************************************
*****************************************************************

Note : If we do not receive your reply within two business days, this post would be marked �assumed answered� and would be moved to �answered questions� pool.


Thanks.