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 |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2006-08-25 : 10:50:52
|
| Below are the maintenance plan that we are running. Do you have any suggestions that we should do as the part of maintence plan?Optimize System Databases EXECUTE master.dbo.xp_sqlmaint N'-PlanID 0EF08E2B-DAE4-4893-BC29-DC304BA55661 -WriteHistory -RebldIdx 10 -RmUnusedSpace 50 10 'Backup Full Recovery Model Databases EXECUTE master.dbo.xp_sqlmaint N'-PlanID DF1ABC60-29EE-4116-9497-C76B51B4C098 -Rpt "d:\Program Files\Microsoft SQL Server\MSSQL\LOG\ Full Recovery Model DB Maintenance Plan4.txt" -DelTxtRpt 1WEEKS -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB "EBackup Simple Databases EXECUTE master.dbo.xp_sqlmaint N'-PlanID 33B2C2CD-3C3F-4651-9B42-F53BBBE79D95 -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB "E:\MSSQL\BACKUP" -DelBkUps 1DAYS -CrBkSubDir -BkExt "BAK"'Optimize Simple Databases EXECUTE master.dbo.xp_sqlmaint N'-PlanID 33B2C2CD-3C3F-4651-9B42-F53BBBE79D95 -WriteHistory -RebldIdx 10 -RmUnusedSpace 50 10 'Integrity Check Full Databases EXECUTE master.dbo.xp_sqlmaint N'-PlanID DF1ABC60-29EE-4116-9497-C76B51B4C098 -Rpt "d:\Program Files\Microsoft SQL Server\MSSQL\LOG\SAVVIS Full Recovery Model DB Maintenance Plan2.txt" -DelTxtRpt 1WEEKS -WriteHistory -CkDB 'Backup SYSTEM Databases EXECUTE master.dbo.xp_sqlmaint N'-PlanID 0EF08E2B-DAE4-4893-BC29-DC304BA55661 -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB "e:\MSSQL\BACKUP" -DelBkUps 1DAYS -CrBkSubDir -BkExt "BAK"'Optimize Full Databases EXECUTE master.dbo.xp_sqlmaint N'-PlanID DF1ABC60-29EE-4116-9497-C76B51B4C098 -Rpt "d:\Program Files\Microsoft SQL Server\MSSQL\LOG\ Full Recovery Model DB Maintenance Plan0.txt" -DelTxtRpt 1WEEKS -WriteHistory -RebldIdx 10 -RmUnusedSpace 2000 10 'Integrity Check System Databases EXECUTE master.dbo.xp_sqlmaint N'-PlanID 0EF08E2B-DAE4-4893-BC29-DC304BA55661 -WriteHistory -CkDB 'Integrity Check Simple Databases EXECUTE master.dbo.xp_sqlmaint N'-PlanID 33B2C2CD-3C3F-4651-9B42-F53BBBE79D95 -WriteHistory -CkDB 'Transaction Log Backup Full Databases EXECUTE master.dbo.xp_sqlmaint N'-PlanID DF1ABC60-29EE-4116-9497-C76B51B4C098 -Rpt "d:\Program Files\Microsoft SQL Server\MSSQL\LOG\ Full Recovery Model DB Maintenance Plan6.txt" -DelTxtRpt 1WEEKS -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpLog " |
|
|
|
|
|
maintenance