Rar file size reducer1/7/2023 ![]() See the following image:Ĭlick OK to close the environment variable dialog box and click OK to close the System Properties dialog box.Ĭreate a store procedure to generate the backup ![]() Click on OK to close the Environment Variables dialog box. On the dialog box, click on New and add the location of the Winrar.exe file. See the following image:Ī dialog box named Edit environment variable opens. From User Variable for list box, select PATH and click on Edit. ![]() See the following image:Ī dialog box environment variable opens. In the Advanced tab, click on Environment variables. On System Properties dialog box ( Screen 2), click on the Advanced tab. On the dialog box, click on Advance System properties. See the following image:Ī dialog box, Systems opens. To set the environment variable, Open Control Panel Click on System. Set the PATH system variable in windows server Using WinRAR command-line utility, compress and divide the backup file in multiple WinRAR files and copy them to the network locationįor the demonstration, I have installed WinRAR software from here, restored a SQL database named AdventureWorks2017 on my workstation. To use the WinRAR command-line utility, we set the PATH variable on the database serverĬreate a T-SQL script to generate a compressed and copy_only backup of the database To accomplish the task, we had taken the following approach: The IT team of the company has set up the network drive to save the backup file. ![]() But they insisted us to use the WinRAR software to compress and split the backup. They want us to set up a schedule a backup job that generates a backup of SQL database, compress the backup file in multiple compressed archive files (WinRAR files.) We tried to explain to the customer that the SQL Server native backups are capable of compressing the backup file, and it can split a large and compressed backup into multiple backup files. Recently, we have received a strange request from our customer.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |