Course Content
1. MS SQL SERVER DBA
0/10
1.1 SQL Server 2008 Overview
1.2 Installing and Configuring SQL Server 2012
1.3 SQL Server Management Studio and other tools
1.4 Monitoring the Database Server
1.5 Database and Index Maintenance
1.6 Securing SQL Server 2012
1.7  SQL Server Backup & Recovery
1.9 Replicating Information
1.10 Import and Export SQL Server Data
1.11 Performance Tuning
SQL Server DBA
About Lesson
  • SQL 2008 Disaster Recovery Feature
  • Database Snapshots
  • Creating a Snapshot
  • Common Snapshot Applications
  • Undeleting table rows
  • Undoing a table update
  • Recovering a dropped object
  • Backup and Restore concept and types
  • Backup and Restore options
  • Media Integrity Changes
  • Recovering the MASTER Database
  • Create a mirrored backup
Previous
Next