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 |
|
learntsql
524 Posts |
 Posted - 2009-11-19 : 07:52:25
|
| Hi...There is a huge variation showing between .mdf file and .bak file of same database.Why it is showing like this?And How to know size of each table in a database. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-11-19 : 08:04:51
|
| 1 .bak includes Log file's contents too2 exec sp_spaceused 'table name'MadhivananFailing to plan is Planning to fail |
 |
|
|
learntsql
524 Posts |
Posted - 2009-11-19 : 08:11:51
|
| Sorry I didnt mention clearly in my post.My .mdf file is showing 5 GB(approx.) and .bak is showing 600 MB. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-19 : 08:53:22
|
database files have reserved "unused" space and there is no need to put it into a bak-file.see also sp_spaceused like madhi has posted.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
|
|
|
Variation in .mdf and .bak file sizes