VISUAL Did You Know?

If you have any questions about Infor VISUAL, contact us at 800.804.4715. We would be happy to help you!

Do you have VISUAL and want monthly tips and news? Subscribe to the BizTech VISUAL eNewsletter.

Are you looking for an ERP software? Subscribe to our monthly eNewsletter about ERP selection & implementation. Subscribe to the BizTech intERPreter.

Join the VISUAL Manufacturing Group on LinkedIn!

Search This Blog

Thursday, January 12, 2017

Reduce the amount of space your SQL Server backup files need

Do you limit the number of backup files you retain because of limited disk space? 

Did you know that you can significantly reduce the amount of space your .bak files need by selecting a simple option in your backup procedures?

Within SQL Server backup, under "Options," there is a place to turn on compression.

This will significantly reduce the size of the resulting backup file.

NOTE: I have not seen it significantly increase the time it takes to complete the backup. I also have not had any problems restoring from a compressed backup file. 

Yes! This is available within your maintenance plans as well!

-Larry Tussing, 
 BizTech ERP Consultant

No comments:

Post a Comment