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 |
|
psychotic_savage
Starting Member
25 Posts |
 Posted - 2012-03-23 : 09:19:31
|
| So today for the 2nd time this year I've had to re-create a SQL Server due to the server going pop.Mirroring did its job so the databases are still running without issue.Now in the process of setting up the new principle server I had to ask myself there must be an easier way.Is there any way to backup and restore an entire maintenance plan.My current maintenance plan contains:Maintenance clean-up tasksBackup database tasksBackup log files tasksNotify operator tasks Execute TSQL Statement tasks History cleanup tasks.If anyone has any ideas or knowledge of this please share your brain power Thanks |
|
|
|
|
|
Maintenance Plan managment