scheduled backup strategies

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Prashant Pandey » scheduled backup strategies

scheduled backup strategies

Rate Topic

Display Mode

Topic Options

Author

Message

David Parvin

Posted Friday, November 07, 2008 9:12 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 01, 2012 8:22 AM
Points: 1, Visits: 6

I have my scheduled backups setup so that a full backup is done on a weekly basis and then on a daily or hourly basis, depending on the critical nature of the database in question, I do incremental backups to the same backup file. That backup file is also backed up to tape on a nightly basis and that gives me a lot of restore points I can use that are over a fairly long period. I believe that going too long between full backups just makes getting to a specific restore point more difficult, but having only full backups means a lot of storage overhead as well.

Use this article for what it is, a good starting point to get you thinking about what is possible with backups and start your research into developing your backup procedures for your specific case.

Post #599053

« Prev Topic | Next Topic »

Permissions