Why is SQL Server Backup 4x Larger than RMS Backup?

- D
- Dhruva
  
  Contact options for registered users
posted
14 years ago

Sun, Aug 23, 2009 4:45 AM

I normally back up my Store Operations installation with the Backup command under the Utility menu. The files are around 130 MB.

Now I want to automate backups, so I set up a backup plan in SQL Server 2005 (Std. Edition). However, when it runs, it produces a backup file of more than

400 MB.

Can anyone tell me why the SQL Server backup is so much larger?

Thanks

Loading thread data ...

- A
- Andy Miller - R
  
  Contact options for registered users
Vote on answer
posted
14 years ago

Tue, Aug 25, 2009 2:55 AM

I don't know the exact answer to your question, but if you zip up your backup files. it will compress them to 1/2 the size. I've found if i zip up a backup file that is 200mb, the .zip file will be nearly 100mb in size.

- R
- Ryan
  
  Contact options for registered users
Vote on answer
posted
14 years ago

Wed, Aug 26, 2009 2:08 PM

Even better than standard Zip is 7zip

formatting link

A free utility that can compress far more than Zip or Rar.

- M
- Matt Kent
  
  Contact options for registered users
Vote on answer
posted
14 years ago

Mon, Aug 31, 2009 3:57 PM

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.