Post reply

RESTORE

  • August 11, 2010 at 12:11 pm

    #146673

    Question - Is there any way to a make a fully recovered database to no recovery mode or stand by mode.

    Reason :

    I have restored a database with recovery mode on server A from full backup of server B and the database size is 400 GB and it took 7 hours.

    Unfortunately,due to some transactions on server A ,I need to apply these changes to server B so I took diff backup. But to apply this diff I need to retore full backup with norecovery and apply diff backup with recovery and this will kill my whole day....

    Any help is really appreciated

  • August 11, 2010 at 12:12 pm

    #1205623

    Unfortunately no. Sorry.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • August 11, 2010 at 12:18 pm

    #1205629

    sqlbee19 (8/11/2010)

    But to apply this diff I need to retore full backup with norecovery and apply diff backup with recovery and this will kill my whole day....

    Yes, you do.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 11, 2010 at 12:30 pm

    #1205643

    thanks

  • August 11, 2010 at 5:16 pm

    #1205764

    sqlbee19 (8/11/2010)

    Question - Is there any way to a make a fully recovered database to no recovery mode or stand by mode.

    A neat trick is to always do your restore with no_recovery. It's fairly easy to do the recovery afterwards as a seperate step if you find there aren't any logs or diff backups to apply. And as you have discovered it saves having to do the whole restore again if you suddenly realise you need to apply some logs etc.

    Cheers

    Leo

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

  • August 11, 2010 at 11:32 pm

    #1205809

    backup tail of the transaction log would put the database into norecovery mode ?

  • August 12, 2010 at 7:31 am

    #1205998

    one more addition... you can also try snapshots as restoring from snapshot takes very less time as compared to full backup.

    But in this case u don't have choice my friend.....

    Rohit

Viewing 7 posts - 1 through 6 (of 6 total)

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