Post reply

Is more than Full Database Backup necessary?

  • November 5, 2009 at 12:19 pm

    #227708

    This might sound a little naive, but why take more than one Full Database backup if you periodically take Differential and Log backups?

  • November 5, 2009 at 12:26 pm

    #1075555

    recovery time, as well as backup complexity play a big roll.

    for example, to restore to a specific point in time, you need a FULL backup, and all the logs between the FULL backup and the Point In Time you want to restore to.

    if you did a backup, say once a month(or a year!), bu did transaction log backups every hour, you'd need something like 720 log files to restore to some point of time at the end of the month...and what if someone deleted some of those transaction logs because they thought htey are not needed...ouch.

    much easier, and more logical, to get Last Nights Backup plus whatever was done today....

    that's why i typically do a daily FULL, and intermittent backups over the course of the day, where the frequency depends on the usage...some databases are every half hour, some are just at noon and 4pm

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • November 5, 2009 at 1:07 pm

    #1075577

    also have a look at the demistifying article Gail Shaw posted http://www.sqlservercentral.com/articles/64582/

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

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

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