Howdy, Stranger!

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

Advertise on

In this Discussion

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.


  • 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.