smtzac (3/13/2014)
Hi all,I am configuring DB mirroring on principle database and the database has Full,Diff,TranLog backups job running everyday on Sql Agent.
In order to configure Mirroring on principle database should I disable/delete TranLog backup job on Sql agent, just like Log shipping? or I can have mirroring and Log backup job going on principle or I can't have both same time?
Hi
thanks for your email, as George said log backups must continue. The agent jobs on the principal can run and maintain your backup strategy, logs especially otherwise the principal t-log will just keep growing and you don't want that.
You may want the same jobs on the mirror too for if the roles reverse. If you make your backup script intelligent to ignore databases that are not online and deploy this to the principal and the mirror.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉