cancel
Showing results for 
Search instead for 
Did you mean: 

V-79-57344-65085 There was a problem running the DBCC

ahousley
Not applicable
Accredited

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.

1 ACCEPTED SOLUTION

Accepted Solutions
2 REPLIES 2

ArulPrasad
Level 6
Employee

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

RahulG
Level 6
Employee