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 |
|
ZarrinPour
Yak Posting Veteran
66 Posts |
 Posted - 2009-07-10 : 17:25:29
|
| Hi every oneNothing just curious !!!I have a database with 10 Tables and when i get FULL backup from that database , it has 500 MG size...BUT yesterday i had to change one field from INT dataType to Varchar(7) (note that this table had 270 Records) and when i got back up , this time it decreases to 350 MG !!!! (difference = 150 MB) I just want to undersatand how this decrease is possible with only 270 records? because as far as i know INT datatype occupies 4 bytes butvarchar(7) occupies at least 7 bytes.Thanks in advance.Regards.Nothing is quite impossible! |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-07-11 : 13:42:58
|
Your changes cannot be the reason. There must be other things happened...
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-07-11 : 19:18:00
|
| Which backup did you do afterward? |
|
|
|
|
|
|
A NewBie...How it is possible....?