0

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.

Improve this question

1 Answer 1

Reset to default
2

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

Improve this answer
2
  • That's reassuring, thanks. I'll also have to stop the transaction log backups I'm guessing, or the log chain will be broken? Commented Nov 10, 2009 at 14:54
  • yes for sure otherwise the shipping will be inconsistent. Commented Nov 10, 2009 at 15:01

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.