How can we help you today? How can we help you today?

Log file restore failing, leaving db inaccessible

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
mcushing
0

Comments

1 comment

Sort by
  • mcushing
    and it was fine. That's funky.
    mcushing
    0

Add comment

Please sign in to leave a comment.