Total Time: 7 hour(s)

Summary: 
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.

Ojectives: 
After completing this course, students will be able to:
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 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.