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 |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2003-04-10 : 12:02:17
|
| What should be the size of a full database backup file or what does a backup file contain (data + index transactions) ?ex: sp_spaceused givesdata index unused17782392 2087608 613272So If I add the data + index , shouldn't it be apprximately close to the backup file size? It is for me, I just want to confirm if my thinking is correct.Thanks,Sarat. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-10 : 12:38:13
|
| The backup size should be approximately the same size as the MDF file minus the free space.Tara |
 |
|
|
|
|
|
Backup File Size