Forum Discussion

Marianne's avatar
Marianne
Level 6
12 years ago

SQL Staging full database recovery failure

  Scenario: NBU 7.5.0.4 on master/media server and client Windows 2008 R2 on master and client SQL Full, Differential as well as Transaction Log backups successful (see SQL-test.jpg attachme...
  • Marianne's avatar
    12 years ago

    Finally good news!

    We received version 2 of dbbackup EEB. 

    This EEB fixed the GUI problem - I could select the last Transaction Log with full recovery option. Last Full, subsequent Diff and all relevant logs were automatically selected.  'Recovery Set'  tab also where it should be.

    So, restore was submitted. Full, Diff and first log restored successfully. 
    Failed on 2nd log after reading/writing some data.

    Not sure why this happened - no helpful info in Activity Monitor or in dbclient log. Criptic errors in Event Viewer Application log...

    My colleague logged in from home tonight and restored the remaining 3 logs one-by-one, selecting 'Recovered' option on the last log.

    Database is up and running!

    Event Viewer Application log:


    Restore is complete on database 'MPR_2012'.  The database is now available.

    A BIG thanks to colleagues and online friends for your support!