Insert Data Load Statement
Select into Statement
Bulk Insert Statement
SQL Bulk Copy Program
Data Transformation Services
DTS Package Designer
Scheduling Running Package
Monitoring SQL Connections
Monitor Locked Resources
SQL-EM Monitor Locks
Overall System Performance
Monitor Data Cache
Monitor Performance using DBCC
use SQL-EM to Database Size
Monitor Databases using DBCC
Maintaining Database Statistics
Database Maintenance Plan wizard
Database Maintenance Plan Wizard
Initial Database Maintenance Plan Wizard screen.
This is the initial database maintenance plan wizard screen.
The select Database screen allows you to pick the database to run the maintenance plan against.
The Reorganize Database screen allows you to pick which reorganization options you want to use and to schedule how often the database is reorganized.
The Verify Database screen allows you to pick which dbcc commands you want to use and to schedule how often the commands are run.
The Database Backup screen allows you to schedule a full database backup.
The Specify Backup Disk Directory screen allows you to pick backup file options.
The Specify Transaction Log Backup Plan screen allows you to schedule transaction log backups.
The Specify Transaction Log Backup Disk Directory screen allows you to pick backup file options.
The Reports to Generate screen allows you to specify report generation options.
The Maintenance History screen allows you to specify where to record information about the maintenance plan that was run.
The Completing the Database Maintenance Plan Wizard screen allows you to name the maintenance plan.