Restoring diff backup problem

Question

Restoring diff backup problem

huum

Say Hey Kid

Points: 693
More actions
July 14, 2013 at 4:14 pm

#395139

i am trying to mirror the database,
i have restored the full database backuop
now i need to restore diff back and log backup.
can i please has so assistance, i am not sure how to do it.

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

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

Luis Cazares SSC Guru Points: 183698 More actions · Answer 1

I believe that you have to add WITH NORECOVERY for every backup until the last log backup restore which will use WITH RECOVERY.

What's exactly your problem?

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

huum Say Hey Kid Points: 693 More actions · Answer 2

Means i will have to first restore full database backup,

and then all the transactional log backups since the last full backup with no recovery?

and last transactional log backup with recovery????

Luis Cazares SSC Guru Points: 183698 More actions · Answer 3

That's correct.

Remember to do it in the correct order.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Andrew G SSChampion Points: 12809 More actions · Answer 4

Since you are creating a mirror database, do not use WITH RECOVERY or you'll have to start again. The mirror needs to remain in an unrecovered state.

You also only need the transaction log backups since the last DIFF backup, not FULL backup.

MSDN article for setting up mirroring:

http://msdn.microsoft.com/en-us/library/ms189053.aspx

Joie Andrew One Orange Chip Points: 27360 More actions · Answer 5

The phrase "i am trying to mirror the database" is a little ambiguous. Are you trying to make a copy of a database with schema/data from one instance and setup in another (for testing/development reasons possibly), or are you trying to setup Database Mirroring?

The purpose and techniques for the two are different.

Joie Andrew
"Since 1982"