Database Mirroring

[ptheriault]

This might be a dumb question but I'm nor sure how this works.
I have just been given two new SQL2005 ENT edition servers from a vendor. They have set up mirroring without a witness. So Transactional Safety is set to OFF. They are not backing up the T-log so it is getting very large. In fact it's bigger than the db. I would like to set up the following.

12:00 AM Full db backup
1:00 AM init the log
1:30 AM and every 1/2 hr after that backup the t-log.

will the 1:00 AM init break mirroring?

As I understand mirroring without a witness. All transactions are commited before being sent to the mirror. So if I init the log I should be ok. Correct?

 

[Catadmin]

I haven't implemented Mirroring yet, but your backup & trans backup schedules should work fine without breaking anything. From what I understand, Mirroring doesn't actually use the transaction log the way that Log Shipping does because it does send over every individual transaction.

Of course, most of my information is based off of the BETA version of Mirroring. Still, I doubt the backup will cause problems.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[ptheriault]

Thanks again Catadmin,
That's what I thought too but I wanted to run it by someone else just to be sure.

 

[mrdenny]

I am running mirroring, and I can tell you that transaction log backups do not effect the mirroring.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com