Categories
DBA

Types of backup in SQL 2005

One of the most important roles of a DBA is performing regular backups of SQL Server data. Creating backups of critical business data should be one of the foremost concerns of a database administrator (DBA) because backups provide a way to restore data that otherwise could be completely lost. Now let us discuss the types of backups available in SQL Server 2005.