This course covers the SQL Server features you use to perform ongoing maintenance tasks to keep your databases functioning well.
Objectives:
This course covers the SQL Server features you use to perform ongoing maintenance tasks to keep your databases functioning well.
Explain Data Collation
Maintain data files
Back up and restore data
Perform ongoing maintenance
Collect performance data
Topics:
Maintaining Your Database
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.