InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 10:57:53 GMT20http://www.sqlservercentral.com/Forums/Topic967714-146-1.aspxone 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.....RohitThu, 12 Aug 2010 07:31:33 GMTRamji29http://www.sqlservercentral.com/Forums/Topic967714-146-1.aspxbackup tail of the transaction log would put the database into norecovery mode ?Wed, 11 Aug 2010 23:32:49 GMTyuwei98http://www.sqlservercentral.com/Forums/Topic967714-146-1.aspx[quote][b]sqlbee19 (8/11/2010)[/b][hr]Question - Is there any way to a make a fully recovered database to no recovery mode or stand by mode. [/quote]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.CheersLeoWed, 11 Aug 2010 17:16:55 GMTLeo.Millerhttp://www.sqlservercentral.com/Forums/Topic967714-146-1.aspxthanksWed, 11 Aug 2010 12:30:24 GMTsqlbee19http://www.sqlservercentral.com/Forums/Topic967714-146-1.aspx[quote][b]sqlbee19 (8/11/2010)[/b][hr]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....[/quote]Yes, you do.Wed, 11 Aug 2010 12:18:01 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic967714-146-1.aspxUnfortunately no. Sorry.Wed, 11 Aug 2010 12:12:08 GMTDavid Benoithttp://www.sqlservercentral.com/Forums/Topic967714-146-1.aspxQuestion - 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 appreciatedWed, 11 Aug 2010 12:11:17 GMTsqlbee19