Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Subscribe to our newsletter

Advertise on LowEndTalk.com

In this Discussion

Latest LowEndBox Offers

    suggest : MS SQL backup Software/script
    New on LowEndTalk? Please read our 'Community Rules' by clicking on it in the right menu!

    suggest : MS SQL backup Software/script

    Hi all,
    Can you recommend some good reliable backup script/app to backup all Databases into one backup set with Day's time stamp. Also importantly, I need to keep only 'n' number of sets, eg: 5 days or 20 days backup only and DELETE the OLDER ones, reducing disk space and remote storage needs.

    The Micsosoft-SQL 2008 64bit is the version to be backed up.

    Kindly suggest apps/scripts which can resolve the purpose.
    Thanks

    Comments

    • mikhomikho Member, Provider

      Use the maintenance plan function in SQL Server.
      zip the outcome and name the file with the date.

      Forfiles can then be used to delete old files.

      Thanked by 1mehargags
      Get a LES NAT VPS! (or 10) in United States (3), Germany, Bulgaria, France, Norway, Australia (2), Singapore. | -> 500gb NAT Storage
    • ReeRee Member

      Add a "Maintenance cleanup task" and you can have the maintenance plan take care of deleting the old backups for you.

      I've never tried it, but I believe you can backup multiple databases to a single file, so you wouldn't need the zip step either.

      Thanked by 1mehargags
    Sign In or Register to comment.