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