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 |
|
logie0726
Starting Member
17 Posts |
 Posted - 2008-06-27 : 02:17:53
|
| Anybody knows the ratio of an mdf database file to a bak (backup database file)? feedback pls. |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2008-06-27 : 06:20:00
|
| I think the ratio is about 1 to 1 on the *used* part of the mdf-file. An mdf-file (and ldf too) can be whatever size on disk and only hold a small amount of data in it... So unless you're using some sort of backup-tool that supports compression the bak-file will be pretty close to the same size as the active part of the data file.- Lumbago |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2008-06-27 : 06:29:47
|
| Hm, I just did some tests my reeeeeally small databases on my laptop and it varied quite much actually. Some bak-files are about the same size as the db and some are about 30% smaller...I guess it depends on the data.- Lumbago |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-27 : 08:06:34
|
| Yes, Backup only captures the used portion of database so it is usually smaller in size. |
|
|
|
|
|
|
RATIO OF MDF FILE TO BAK FILE