October 4, 2014 at 4:01 pm
Hi All
I recently inherited a set of servers that do database mirroring. I know very little about mirroring because this is the first in our organization and I've been a DBA for 5 months. Anyway I just need an answer to what type of maintenance do I provide for these databases? What I do know is that each user database is Full recovery model and normally I would do a full, differential and log backup. I know I have a lot of reading to do about mirroring and I know mirroring is depreciated but we have SQL Server 2012. I just don't want to backup the log files if they are needed for mirroring to happen.
Thanks
Kathy
October 5, 2014 at 1:51 am
Normal backup schemes (full/diff/tlog) work just fine for mirrored databases. The mirroring system won't let stuff get removed from the tlog if it isn't yet hardened over on the secondary.
You MUST get up to speed on the intricacies and issues that come with mirroring. It is presumably at least part of your company's HA/DR plan and if it isn't done right/handled right your company could go out of business if it is needed and doesn't work correctly (or people don't know how to use it correctly when needed). I cannot stress this enough. Get someone in for a quick review and mentoring session if needed.
Don't worry about it being deprecated. MANY companies will STILL be using mirroring at least 10 years from now, I guarantee it. Without it you are FORCED to go up to Enterprise Edition to get similar capabilities and that just SUCKS from a cost perspective. Very sad Microsoft did this.:angry:
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
October 5, 2014 at 9:53 am
Thanks Kevin. Mirroring isn't part of our disaster recovery as of yet. We are a relatively small evolving sql server shop and there is a lot for me to learn.
October 6, 2014 at 6:31 am
plamannkathy (10/4/2014)
Anyway I just need an answer to what type of maintenance do I provide for these databases?
The system databases on each instance would be advisable. The principal database needs to have a scheduled backup routine to include at least full and tlog backups. You also need to implement the same regime onto the mirror instance so that if a failover occurs backups are in force for the new principal database.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply