2,187
edits
Difference between revisions of "MS SQL"
Jump to navigation
Jump to search
→Daily Maintenance Plan: Moved backup to start
(→Rebuild All Indexes: Added single user bit) |
(→Daily Maintenance Plan: Moved backup to start) |
||
| Line 67: | Line 67: | ||
#* Delete all historical data (backup/restore, SQL Server Agent and Maintenance plan histories) | #* Delete all historical data (backup/restore, SQL Server Agent and Maintenance plan histories) | ||
#* Older than 2 weeks | #* Older than 2 weeks | ||
# '''Back Up Database Task''' | |||
#* Backup type: Full | |||
#* Databases: All databases | |||
#* Backup will expire: Leave unticked | |||
#* Create a backup file for every database: Update as appropriate | |||
# '''Reorganise Index Task''' | # '''Reorganise Index Task''' | ||
#* All user databases | #* All user databases | ||
| Line 74: | Line 79: | ||
#* Update: All existing statistics | #* Update: All existing statistics | ||
#* Scan type: Full scan | #* Scan type: Full scan | ||
# '''Maintenance Cleanup Task''' | # '''Maintenance Cleanup Task''' | ||
#* Delete files of the following type: Backup files | #* Delete files of the following type: Backup files | ||