Prepare for your Next Interview
This is a discussion on To Take Backup within the SQL Server forums, part of the Databases category; 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 ...
|
|||
|
Re: To Take Backup
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 *** Last edited by Innila : 02-20-2007 at 03:02 AM. |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Backup of Database | norman | Oracle | 3 | 10-13-2006 06:58 PM |
| Command for Backup | nancyphilips | Unix/Linux | 1 | 08-11-2006 05:16 AM |