Accpac Backup

[johnhugh]

Hi,
I'm using Accpac 5.6.
How come my SQL backup of the company database is 19GB and a database dump is only 5GB?
Recovery model is Simple on SQL 2005.

 

[Jay Converse]

Did you Shrink the database?

 

[johnhugh]

In SQL Server you mean?
No.

 

[Jay Converse]

Do it.

 

[johnhugh]

Running shrink from the management studio did not shrink the database.
It is still 19GB and an Accpac dump is 5GB.

 

[Jay Converse]

I checked some of my databases, Dbdump is always 2-4 times smaller than SQL.

 

[johnhugh]

Thanks for that.
Wondering what might be causing this....hmm...

 

[Jay Converse]

Why does it matter? You need to move on and worry about more important things.

 

[DjangMan]

dbDumps also compacts the data when it is exported. A customer name field, for example, might be ABC Corp. which will take up 60 bytes in the database but only 9 in the dbDump .rec file.

 

[ramam1]

The DB backup files compress extremely well with zip or whatever you like. Also depending on your DB server version you might be able to enable 'backup compression' which will do something similar but inline while backing up. My 30GB DB backs-up results in a 2.4gB dot-bak file. It is also insanely faster (3 minutes instead of too long to wait for).

 

[johnhugh]

I have SQL 2005 which does not seem to have 'backup compression' natively.

 

[Jay Converse]

Why is any of this an issue? It's 2012, disk space is $50 a TB.