Course Content
SQL SERVER ARCHITECTURE:
STORAGE ARCHITECTURE
DATABASE ARCHITECTURE
TRANSACTION LOG ARCHITECTURE
INSTALLATION:
Pre-REQUISITES
INSTALLATION SQL SERVER 2008R2
POST INSTALLATION STEPS
DATABASE:
SYSTEM DATABASES
CREATING DATABASES
BACKUPS:
RECOVERY MODELS
BACKUP TYPES
ADVANCED BACKUPS
RESTORATION:
PRE-RESTORATION
POST RESTORATION
RESTORE ENHANCEMENTS IN SQL 2012
SECURITY AND AUTOMATION
LOG SHIPPING:
ARCHITECTURE
COMPONENTS OF LOG SHIPPING
FAILOVER STEPS
DATABASE MIRRORING:
COMPONENTS IN MIRRORING
HOW MIRRORING WORKS
MIRRORING SITUATION
REPLICATION:
HOW REPLICATION WORKS
CONFIGURING REPLICATION
CLUSTERING:
CLUSTERING ARCHITECTURE
COMPONENTS
CLUSTERING ADMIN TASKS
CONFIGURING WINDOWS/SQL CLUSTERING