Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2014
    Posts
    2

    Question Unanswered: SQL server backup

    Hi, I have a SQL backup script that runs every end of the week to backup a SQL database (2008 R2) but I got many errors starting this month and it seems no longer working. I'm tired of debugging and thinking of getting a proper developed backup software to do the job for me. Hopefully it can also replicate the backup to Amazon S3 for disaster recovery. Any recommendation? Thanks a lot!

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The backup package from Ola Hallengren is quite possibly the best that there is, certainly the best that I've found. Considering that it is free and well supported by the SQL Server community, you probably can't find a better solution.

    If you are having a lot of error messages and the backup is failing, then you probably have other problems. My guess would be database corruption, but without understanding your system configuration and the errors that are being reported that is only a guess.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Sep 2014
    Posts
    2

    That's great

    That's great. Let me look into it further.

Tags for this Thread

Posting Permissions

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