How To Make Back Up Of Db Smaller In Ms Sql
Hello everybody,
today I want to document one hack that preserved me plenty of space on my hard drive.
Recently I've tried to make back up of production database and was shocked to see that it had almost 200 Gb on my hard drive. So it made me wonder how can I have smaller backups.
And here is the solution.
- In Microsoft SQL Server Management Studio click on database, and choose new query
- enter there following command: sp_configure 'backup compression default', 1
- then this: reconfigure WITH OVERRIDE;
After such manipulations I've got back up that had only 27 Gb.
Streamlining your Acumatica environment is all about finding smart solutions to optimize performance and efficiency—just like compressing database backups to save valuable space. If you’re looking for ways to further enhance your Acumatica experience through customizations tailored to your unique business needs, we’re here to help! Leave a customization request today, and let’s work together to make your Acumatica system even more powerful and efficient. Your ideal solution is just a request away!