December 4, 2007 at 4:44 pm
We are running SQL Server 2000 (sp3) on Windows Server 2003. We had to rebuild our Windows Server and reinstall SQL Server. Then I had to restore our 'user' databases. Before the restore, I had some scheduled Transact SQL Jobs and some Database Maintenance Plan Jobs. Now, I do not see them after the restore. I have a backup of the 'msdb' database. Does the 'msdb' database contain the SQL Jobs and Database Maintenance Plan Jobs Information? (I have read where the 'msdb' stores scheduling information and job history.)
Thanks in advance, Kevin
December 4, 2007 at 4:50 pm
Simple answer - Yes it does. It holds all Job and Maintenacne plans and any DTS packages that were stored on the server too. If you need this data then restore from your backup
Gethyn Elliswww.gethynellis.com
December 7, 2007 at 8:49 am
msdb is basically the database for SQLAgent. It has history, information about SSIS package and jobs. It may or may not contain SSIS packages (they can run from the filesystem), but it does have all job info.
December 8, 2007 at 9:39 pm
SQL Server Agent, Jobs, DTS Packages, Maintenance Plans are in the MSDB.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply