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 |
|
Mahesh_jd2k
Starting Member
3 Posts |
 Posted - 2008-02-13 : 04:27:54
|
| My database is of 10 gb, when backup is taken the size of .bak file is less than 10 gb.Why? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-13 : 04:29:55
|
Are you using all available space for the 10 gb file?I believe some space is not used within the file.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2008-02-13 : 05:13:16
|
| Size of Backup file will always less than the database size..there is nothing abnormal in that.RKNAIR |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-18 : 11:55:11
|
| There may have been unused space on the transaction log fileJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
CShaw
Yak Posting Veteran
65 Posts |
Posted - 2008-02-18 : 20:17:44
|
| It could depend on a lot of things. You may have datatypes in there that when they are backed up the trailing spaces may be trimmed, There could be a lot of free space in your .mdf. Like Ratheeshknair said it I would not worry about it to much. If there is a drastic size difference you may want to restore the database to another database, or another server just to verify that your backups are good.Chris Shawwww.SQLonCall.com |
|
|
|
|
|
|
Db is of 10 GB, backup size is less than 10 gb