Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm considering dumping database mirroring and go with transaction log shipping on our SQL Server 2008 Standard server instead, because there's a noticeable performance hit due to the principal being a beefier machine.

Is it non-trivial to do?

I am guessing I just need to break the synchronization, bring them offline and then configure for log shipping, or will I have to perform a new RESTORE WITH NORECOVERY? Is this correct?

Other things I should keep in mind?

Preferably I'd like asynchronous mirroring but the Enterprise license is a bit much.

share|improve this question
up vote 1 down vote accepted

this is pretty straight forward in setting up, you shouldnt have to offline the databases either. you can actually begin setting up the transaction log shipping before even needing to break the mirror.

for more info here is the SQL dev center link;

best, Nick

share|improve this answer
That's reassuring, thanks. I'll also have to stop the transaction log backups I'm guessing, or the log chain will be broken? – J F Nov 10 '09 at 14:54
yes for sure otherwise the shipping will be inconsistent. – Nick O'Neil Nov 10 '09 at 15:01

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.