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 |
|
riya.johnson
Starting Member
17 Posts |
 Posted - 2009-07-21 : 04:37:43
|
| Are the settings in the DB Maintenance plan stored anywhere?I am using sql 2000Riya Johnson |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-21 : 05:17:03
|
| Do you mean wher the plan itself is stored? If so, then in msdb.If not, then please explain what you are after further. |
 |
|
|
riya.johnson
Starting Member
17 Posts |
Posted - 2009-07-21 : 06:01:38
|
| Hi,I want this informationDATABASES DBASERVERS (local)OPTIMIZATIONS Occurs every 1 week(s) on Sunday, at 01:00:00. Perform the following actions: Reorganize data and index pages, changing the free space to 10 percent of the original space.INTEGRITY CHECKS Occurs every 1 week(s) on Sunday, at 00:00:00. Perform the following actions: Check database COMPLETE BACKUP Occurs every 1 week(s) on Sunday, at 02:00:00. Backup media: Disk Store backup files in the default SQL Server Backup directory. Delete backup files which are older than 4 Week(s). Verify the backup after completion.This info is available at the time of creation of a maintenanace planCan I get it from anywhere laterRiya Johnson |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-21 : 06:49:27
|
| You'll find the information in msdb in the following tables:sysdbmaintplans sysdbmaintplan_jobs sysdbmaintplan_history sysdbmaintplan_databases |
|
|
|
|
|
|
DB Maintenance plan