This course provides instruction on database maintenance through transaction logs and recovery as well as backup and restore. It also covers remote and distributed management options of Microsoft SQL Server 6.5.
Objectives:
Identify how automatic recovery works
Perform a database dump and load a database dump
Perform a striped backup
Configure and manage server in the enterprise
Set up alerts and schedule tasks
Topics:
Database Logging and Recovery
SQL Server Database Backup and Restoration
Remote Server Management
The MS SQL Server Distributed Management Framework
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.
