Every piece of data in SQL Server is stored in 8 KB database pages. A page is a basic unit of I/O operation. Read More
Database Files
Every database of SQL Server at least has a log file and data file. Log files contain all information that is necessary to restore transactions in the database. Data files contain data and objects (indexes, tables, etc.). Read More
Differential Backup
A differential backup is created similarly to a full backup, but with one important difference – the differential backup only contains the data that has changed since the last full backup (the active portion of the transaction log). Read More
Full Backup
The simplest kind of SQL Server backup is a full database backup. It provides a complete copy of the database but allows restoring the database only to a point-in-time when the backup was made. Read More
Database Backup
Everyone who works with SQL Server databases first or last faces the need to protect their information. That implies making database backups. So what is a database backup? Read More
