RESTORE

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » RESTORE

RESTORE

Rate Topic

Display Mode

Topic Options

Author

Message

sqlbee19

Posted Wednesday, August 11, 2010 12:11 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, June 21, 2012 10:54 AM
Points: 57, Visits: 189

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

Post #967714

David Benoit

Posted Wednesday, August 11, 2010 12:12 PM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 7:56 AM
Points: 2,063, Visits: 3,441

Unfortunately no. Sorry.

David

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

Post #967717

GilaMonster

Posted Wednesday, August 11, 2010 12:18 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 3:18 PM
Points: 37,744, Visits: 30,025

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 2008, MVP
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

Post #967724

sqlbee19

Posted Wednesday, August 11, 2010 12:30 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, June 21, 2012 10:54 AM
Points: 57, Visits: 189

thanks

Post #967739

Leo.Miller

Posted Wednesday, August 11, 2010 5:16 PM

SSC-Addicted

Group: General Forum Members
Last Login: Thursday, May 23, 2013 2:32 PM
Points: 442, Visits: 1,302

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

Post #967877

yuwei98

Posted Wednesday, August 11, 2010 11:32 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, April 11, 2013 11:34 PM
Points: 2, Visits: 422

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

Post #967939

Ramji29

Posted Thursday, August 12, 2010 7:31 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, August 31, 2012 7:19 AM
Points: 225, Visits: 419

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

Post #968170

« Prev Topic | Next Topic »

Permissions