Maintenance plans for mirror setup

Hi all,

I know this questions might have bee asked sevelar times before but I have searched over and over agagin and I cant find a solution for it.

Anyway, here it goes:

I have a few databases configured for mirroring and I want to configure maintenance plans for them. Now, the plan should of course only run on the principal server but how can I make this happen after a failover?
Is it possible to set up the maintenance plans on both principal and mirror server and then only have them executed on the principal.

I want this to happen automatically. If for example the databases fail over automatically during the night I want to be sure that after failover the transaction logs are still backed up.

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

First you must script all the maintenance jobs, replace server name with mirror and apply them in disabled state. Next you should make another job on mirror constantly if your database is in ONLINE state via databasepropertyex. If it is, it must have been set as online in failover process. If it occurs, just enable maintenance jobs with sp_update_job proc in msdb.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.