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 |
|
learntsql
524 Posts |
 Posted - 2009-10-21 : 05:46:10
|
| Hi All,I have SQL Server 2005(Standard) Production Server.I have created some Jobs Using-->Maintenance Plans-->SQL Agent Job Wizard-->Package Schedule-->Reports Subscriptionand -->Replication has to create.Currently my backup plan for production database is Full(Full Recovery) on daily twice.These Batch Jobs are scheduled.Can you please tell me how to create or handle Maintenance Plan for all the jobs created/running under SQL Agent Service in disaster situations.How can i get back all currently running jobs to same state after down time or after disaster recovery has been done.Its difficult to create all these jobs again. |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2009-10-23 : 16:14:33
|
| Script the jobs so you can run the scripts back into the system to recreate them. Right-click on the job and script...As for the maintenance plans, create a new SSIS Project in BIDS - import the maintenance plan into the project and save the project. You can then Save a Copy of the maintenance plan back up to the server when you have to rebuild. BTW, you could set this up as a template, change the connection information and save the maintenance plan to another server. Test it out to make sure you understand how that works.And finally, before your system comes to a halt - please setup frequent transaction log backups (every 15 minutes is a good start). This way, you won't be coming back here in a couple of months asking why your log file is so large. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-10-23 : 16:50:24
|
| make sure you're backing up msdb regularly |
|
|
|
learntsql
524 Posts |
Posted - 2009-10-27 : 00:28:37
|
| Thank you for reply.How frequent should i take MSDB Backup?Will All the jobs work as usual when i restore MSDB when my system/DB is corrupted?I will start with these.Any more precautions; please provide me.Thanks. |
|
|
|
|
|
|
SQL Agent Maintenance