Management Studio provides a neat GUI interface to define maintenance plans for your SQL databases. This tool is available under Management -> Maintenance Plans and provides many great Maintenance Plan Tasks that you can configure easily. There are many useful tasks such as “Check Database Integrity Task”, “Back Up Database Task”, “Rebuild Index Task”, etc.
Posts Tagged ‘Maintenance Plan’
November 17, 2011 by Francois · Leave a Comment
Filed under: Administration
Social Tagging: DBCC • fragmentation • Maintenance Plan • NOTRUNCATE • SHRINKDATABASE • SHRINKFILE • TRUNCATEONLY
Filed under: Administration
Social Tagging: DBCC • fragmentation • Maintenance Plan • NOTRUNCATE • SHRINKDATABASE • SHRINKFILE • TRUNCATEONLY
RSS