SQL Agent Jobs BackUp - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL Agent Jobs BackUp

Author

Topic

learntsql

524 Posts

Posted - 2009-12-08 : 05:56:45

Hi..
1.How to take all SQL Agent Jobs backup.
2.How to move jobs from one server to another.

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-12-08 : 06:05:07

Hi

we can utilize the GENERATE SQL SCRIPT - then run
the SQL on the New DB server/database.

Refer this..
http://vyaskn.tripod.com/moving_sql_server.htm

-------------------------
R...

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-12-08 : 12:46:44

You should be backing up msdb.

learntsql

524 Posts

Posted - 2009-12-09 : 00:08:56

Thank you for your reply,
Currently i am not taking MSDB backup.What should be the backup strategy for MSDB Database.?
How Can i Create existing jobs in new server using MSDB.?

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-12-09 : 00:26:03

Hi

Bcoz It's used by SQL Server Agent for scheduling alerts and jobs and by other features such as Service Broker and Database Mail

-------------------------
R...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources