Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    46

    Unanswered: scripts for backup strategy

    My maintenance plans are starting to acting weird. I'm building a custom script to manage the database backups on my server, but curious if anybody has some sample work that will allow me to avoid re-inventing the wheel.

    A couple of primary constraints:
    I want to do a full backup daily (and only retain 1 day of full backups)
    Transaction Log backups every 20 minutes
    I'd like to loop through the databases on the server automatically to make this a little more flexible.

    You have anything you'd like to share? Or, bits of knowledge worth sharing?

    Please advise,

    alex8675

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    What version of SQL Server? 2000 or 2005?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Dec 2003
    Posts
    46

    SQL Server 2000

    But I'm working on the migration to 2005, so that's coming down the pipeline by the end of the year.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I'm afraid I don't really have anything satisfactory for 2005 yet.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •