January 4, 2007 at 2:39 am
Hi there,
Does any one know which system table(s) store(s) info (plan id, plan name, corresponding db, etc) of a database maintenance job (Transaction log backup to be specific). I knew msdb..sysdbmaintplans, msdb..sysdbmaintplan_databases in SQL 2000 server are used to store these kind of info, but what about in SQL 2005.
Any help will be greatly appreciated.
Thanks,
Ed
January 4, 2007 at 6:09 am
The same tables are used in sql 2005 also. you can query those tables to find the necessary details
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
January 4, 2007 at 11:30 am
MP is using SSIS packages so you may not get complete info as you were getting in 2000.
Most of the MP tables in 2005 cmments from BOL:
Table is included in Microsoft SQL Server 2005 to preserve existing information for instances upgraded from a previous version of Microsoft SQL Server. SQL Server 2005 does not change the contents of this table. This table is stored in the msdb database.
This feature will be removed in the next version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
MohammedU
Microsoft SQL Server MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply