question

Michelk avatar image
Michelk asked

can someone help with a script that will compress my backup with winrar in sql

I created a job to do a backup this is successful see below USE [master] GO BACKUP DATABASE [AlizeClientsReport] TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\AlizeClientsReport_Full.bak' WITH CHECKSUM, COPY_ONLY, FORMAT, INIT, STATS = 10; but my big problem is That I need to compress it with winrar then delete the original backup can someone help me with a scrip that will run after the first i did that will winrar it?

compression
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

it's because there will be more backups to be transferred to the backup server. to avoid many files we just want to zip the folder then when unzipped we have all files in there. and I have winrar on my machine that is why i want to use it to compress

0 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.