Competition: What’s your favorite Redgate tool? Enter now.

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 6.5.1.9, (c) Red Gate Software Ltd 2004 - 2011
Serial number: 010-001-154308-AC51

Processing log group 150446893 ...
\\BI01\PCCLogFiles\LOG_us_chg_multi_replica_2011091910.SQB
Restoring PCC-RRDB-CHG (transaction logs) from:
\\BI01\PCCLogFiles\LOG_us_chg_multi_replica_2011091910.SQB

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

Comments

Sign In or Register to comment.