Results 1 to 2 of 2

Thread: To Take Backup

  1. #1
    Junior Member
    Join Date
    Sep 2006
    Answers
    16

    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


  2. #2
    Expert Member
    Join Date
    Sep 2006
    Answers
    130

    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
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact