Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer 1

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; http://msdn.microsoft.com/en-us/library/bb895393.aspx

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
add comment

Your Answer

 
discard

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.