HELP! Transaction Log Restores

  • I understand that the commonly accepted answer to this is no, but:

    Is there any way to apply a transaction log backup to a database that has been restored and is already online?

    In other words, when the DBA restored the database, he forgot to check "leave non-operational but able to apply transaction log backups". This is a VLDB that we don't want to have to restore again. Any help will be greatly appreciated!!!!

    Josh Jones

    Joshua Jones
    Director, Global Database Services
    PGi

  • The answer is still 'No', unfortunaly.

  • Use this syntax to change recovery state...

    restore database northwind with recovery

    Change northwind with database name...

    Let me know what happened

    Cheers..

    Prakash Heda

    Sr Consultant DBA

    Bangalore, India

    Chat: hedafriends@yahoo.com

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply