Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ABC_guy
Starting Member
1 Post |
 Posted - 2009-11-17 : 13:21:34
|
| I have an SQL 2000 database that I developed myself and then uploaded to a hosting service. When I backed up the database on my local machine the size of the back up was about 1.8 gig.Before uploading the to the hosting service I checked the database size -- I saw a string of digits starting "27". Knowing the size of the backup I just assumed that that string of digits represented 2.7 gig.Lucky me I thought -- the hosting service limit is 3 gig!When the uploaded backup was restored on the hosting server I got a red flag! My db was 27 gig! (=15 times the size of the bu!)In simple terms, can some one explain this expansion in size? An how can I reduce it? (PS: the hosting service does not seem to have noticed -- I am only paying for 3 gig -- $39 a month!)Thanks |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2009-11-17 : 14:50:03
|
| Well....usually the backup is compressed over the actual DB so I'm kinda suprised.In any caseDid you take a backup of the db AND transaction LogDid you shrink the DB or it's files?How much empty space do you have in the database file or the trans log file?Have you set the database files to auto grow?Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-17 : 15:22:23
|
| sounds to me like the db was created at a relatively large size, say 25 GB, but is mostly empty, thus the very small backup size.yes, the backup should be smaller, but not THAT much smaller unless the db is mostly emptyhow large is the .mdf and .ldf files on your machine? |
|
|
|
|
|
|
db size vs: size of db backup