Explain the architecture of SQL Server?
• Different types of Backups? • A full database backup is a full copy of the database. • A transaction log backup copies only the transaction log. • A differential backup copies only the database pages modified after the last full database backup. • A file or filegroup restore allows the recovery of just the portion of a database that was on the failed disk.