Basics of MS SQL Server Training
MS SQL Server is a relational database management system, which is developed by Microsoft. The primary function of SQL Server is to store and retrieve data as requested. There are several numbers of version of SQL Server are available in the market for a different workload. MS SQL Server is a SQL based client-server relational database.
Components of SQL Server
- Database Files and File Groups
- Transaction Logs
- Backup and Recovery
- Microsoft Clusters
- Disaster Recovery
SQL Server Database
- System databases
- User databases
SQL Server Files
- Datafiles (.mdf, .ndf)
- Transaction log files (.ldf)
- Backup files and snapshot files
SQL Server Transaction Log
When the end of the logical log reaches the end of the physical log file, the new log records wrap around to the start of the physical log file.
SQL Server Recovery Model Architectures
- Simple: Truncate occurs on checkpoint
- Bulk-Logged: All operations are logged except bulk operations
- Full: All operations are logged
MS Cluster Server
Implementation consideration – Hardware, software and network
Failover clustering is used to failover automatically if a hardware failure or a software failure occurs.