Geeks Talk

Prepare for your Next Interview




To Take Backup

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 ...


Go Back   Geeks Talk > Databases > SQL Server

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 12-20-2006
Junior Member
 
Join Date: Sep 2006
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
GregMark is on a distinguished road
Exclamation 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
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 02-13-2007
Expert Member
 
Join Date: Sep 2006
Location: India
Posts: 131
Thanks: 1
Thanked 20 Times in 20 Posts
Innila is on a distinguished road
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.
Reply With Quote
Reply

  Geeks Talk > Databases > SQL Server


Thread Tools
Display Modes


Similar Threads

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


All times are GMT -4. The time now is 05:41 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved