-
Junior Member
To Take Backup
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
-
Expert Member
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules