Home Forums Article Discussions Article Discussions by Author Discuss content posted by Junior Galvão - MVP User Stored Procedure for Backup of user databases RE: User Stored Procedure for Backup of user databases

  • July 6, 2018 at 5:38 am

    #1996520

    Subhash Chandra - Friday, July 6, 2018 1:01 AM

    Hi Galvao,

    Is there any way to compress the backup along with this proc?

    Thanks
    Subhash

    Hi Subhash,

    Yes, just add the Compression option in this line:

    Select SD. DbId, ' Backup Database [' + Sd.name + '] To Disk = ' + ' ' S:MSSQL-2017Backup ' + SD. Name + '. Bak ' + ' ' ' With Init, noformat, Compression, Description = ' + ' ' ' ' Backup for storage-Database-' + SD. Name + ' ' ' ' + Char (13) As ' Command '