Is there a script or function in sqlserver2005 that i can backup the jobs and login details of a server from the master database?
+3
A:
Jobs are stored in the MSDB database and logins in the Master database.
You can backup these system databases as you would any other of your user databases. Use the Management Studio GUI or via the "backup database.." TSQL syntax.
See this article on backing up your system databases. With specific considerations for the backing up master and backing up MSDB.
Andy Jones
2009-03-09 10:30:02
+1 Nice links to useful posts.
Sung Meister
2009-03-09 12:33:44