Backup RRS feed

  • Question

  • How do I create a backup schedule in 2008
    Monday, December 12, 2011 11:57 AM

All replies

  • How do I create a backup schedule in 2008

    A good start is finding the right forum. :-) This forum is specifically for SQL 2012, the upcoming release.

    Before you set up a backup strategy, you need to determine what recovery requirements you. If the database goes south, do you need recovery as close to the disaster as possible? Or are you content to restore a backup taken in the wee hours of night?

    How big is the database(s)? Is this a production server? Or just test or development?

    A good tool for setting up backups can be found at http://ola.hallengren.com

    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    Monday, December 12, 2011 10:35 PM