Post reply

Back-up

  • July 7, 2009 at 10:25 am

    #207889

    Hi guys Im a beginner to sql server so i have a question, when do we use a full backup and a file back up because we know that file/filegroups backup is also an alternate to full backup but why do most ppl tend to go with full back-up when file/filegroups backup is an alterantive to full back-up in case of enormous data

  • July 7, 2009 at 3:36 pm

    #1021362

    rahulgoparapu (7/7/2009)

    Hi guys Im a beginner to sql server so i have a question, when do we use a full backup and a file back up because we know that file/filegroups backup is also an alternate to full backup but why do most ppl tend to go with full back-up when file/filegroups backup is an alterantive to full back-up in case of enormous data

    File/FileGroup options allow you to backup different parts of the database - most often used with VLDB (very large databases) to minmize the backup and recovery times. Here is a link to a whitepaper HP put out some time ago which has some good information. BOL (Books Online) is also a good resource.

    http://download.microsoft.com/download/7/b/1/7b17fc16-444f-4ccd-af90-edb378da8831/hp_whitepaper_sqlL.pdf

    Tommy

    Follow @sqlscribe

  • July 7, 2009 at 7:39 pm

    #1021424

    Thank you,

    Tommy

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply