I want to create backup in SQL Sever. I know one of the method namely Transaction log backup. Is there any other method. If so what are they and how to do this
Printable View
I want to create backup in SQL Sever. I know one of the method namely Transaction log backup. Is there any other method. If so what are they and how to do this
Sql server provides different kinds of backups.
A combination of these backups may be used to formulate a robust disaster recovery strategy.
Backup type Description
-------------- -------------
Complete - backs up the entire database.
Differential - backs up only modified extents since the previous complete backup.
Transaction log - backs up the active portion and truncates the inactive portion of the transaction log.
File / filegroup - backs up individual files and filegroups within a database.
File differential - combines differential backups and file or filegroup backups.
*** Innila ***