User Stored Procedure for Backup of user databases

  • Junior Galvão - MVP

    SSCertifiable

    Points: 6428

    Comments posted to this topic are about the item User Stored Procedure for Backup of user databases

  • Subhash Chandra

    Say Hey Kid

    Points: 692

    Hi Galvao,

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

    Thanks
    Subhash

  • Junior Galvão - MVP

    SSCertifiable

    Points: 6428

    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 '

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply