What are the challenges you face when working across database platforms? Take the survey

Log file restore failing, leaving db inaccessible

mcushingmcushing Posts: 13
edited September 26, 2011 11:53AM in SQL Backup Previous Versions
I had an error in the syntax of the script, I forgot the : for one of the drives where the undo_projects.dat file is supposed to be. I corrected it, but it's failing with this message.

The error message is:
Red Gate SQL Backup, (c) Red Gate Software Ltd 2004 - 2011
Serial number: 010-001-154308-AC51

Processing log group 150446893 ...
Restoring PCC-RRDB-CHG (transaction logs) from:

Error 890: RESTORE DATABASE permission denied for database: (PCC-RRDB-CHG)
SQL error 927: Database 'PCC-RRDB-CHG' cannot be opened. It is in the middle of a restore.
SQL Backup exit code: 890
Last SQL error code: 927


Sign In or Register to comment.