Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2012-06-11 : 03:28:37
|
| Hi,Our databases get mirrored but not sure how to setup the jobs to be mirrored also.How can I setup the sql server agent jobs to be mirrored.Thanks |
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-06-11 : 06:08:50
|
| You cannot mirror jobs using database mirroring.You have script them out from principal server and create them on the mirror server.Once done that keep it disabled.In-case a failover happens you will have to enable them manually.Same applies for logins,maintenance plans etc etc.After Monday and Tuesday even the calendar says W T F .... |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2012-06-11 : 06:28:15
|
| Thanks |
|
|
|
|
|
|
sql server agent mirroring