Comments posted to this topic are about the item User Stored Procedure for Backup of user databases
Say Hey Kid
Is there any way to compress the backup along with this proc?
Subhash Chandra - Friday, July 6, 2018 1:01 AM
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 2 (of 2 total)