RelationalDBDesign
SiteMap
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Database Web Apps
Data Manipulation
Access Features
Tables Queries
Monitoring Databases
«Prev
Configuration Monitoring
Importing/Exporting Data
Insert Data Load Statement
Select into Statement
Bulk Insert Statement
SQL Bulk Copy Program
Data Transformation Services
DTS Package Designer
Scheduling Running Package
DTS Wizard
Running DTS Wizard
Load Export Conclusion
Monitoring SQL-EM
Monitoring SQL Connections
Monitor Locked Resources
SQL-EM Monitor Locks
Overall System Performance
Monitor Data Cache
Monitor Performance using DBCC
Monitoring Databases
Monitor Database Size
Use SSMS monitor DB Size
Monitor Databases using DBCC
Monitor Consistency Individual Tables
Miscellaneous DB Monitoring via Dbcc
Monitor Transaction Log
Maintaining Database Statistics
View Statistical Information
Run sqlmaint.exe
Database Maintenance Plan wizard
SQL-Em Conclusion
SQL-Server Profiler
Database Maintenance Plan Wizard
Initial Database Maintenance Plan Wizard screen.
1) This is the initial database maintenance plan wizard screen.
2) The select Database screen allows you to pick the database to run the maintenance plan against.
3) The Reorganize Database screen allows you to pick which reorganization options you want to use and to schedule how often the database is reorganized.
4) The Verify Database screen allows you to pick which dbcc commands you want to use and to schedule how often the commands are run.
5) The Database Backup screen allows you to schedule a full database backup.
6) The Specify Backup Disk Directory screen allows you to pick backup file options.
7) The Specify Transaction Log Backup Plan screen allows you to schedule transaction log backups.
High Performance SQL Server
8) The Specify Transaction Log Backup Disk Directory screen allows you to pick backup file options.
9) The Reports to Generate screen allows you to specify report generation options.
10) The Maintenance History screen allows you to specify where to record information about the maintenance plan that was run.
11) The Completing the Database Maintenance Plan Wizard screen allows you to name the maintenance plan.