Log file restore failing, leaving db inaccessible
mcushing
Posts: 13
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
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