User Stored Procedure for Backup of user databases

• Junior Galvão - MVP

  SSCertifiable

  Points: 6930

  More actions

  July 5, 2018 at 3:42 pm

  #358187

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

• Subhash Chandra

  Say Hey Kid

  Points: 692

  More actions

  July 6, 2018 at 1:01 am

  #1996487

  Hi Galvao,

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

  Thanks
  Subhash

• Junior Galvão - MVP

  SSCertifiable

  Points: 6930

  More actions

  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 '