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 |
|
kensai
Posting Yak Master
172 Posts |
 Posted - 2002-11-22 : 05:59:19
|
| We have a virtual shared account on a host. I used Database=>All Tasks=>Backup Database and backed up our database from our database on our host to my hdd. After that I used Restore Database in my database and restored the database to my local SQL Server.The database size on the host is 124 mb.The backup file is 50 mb.The restored database on my SQL Server is 227 mb.How come the sizes are so different. I guess the backup uses some compression but why the restored database is so big? I'm asking this because I need to upload this database to a new server and we only have 200 mb SQL Server space on this new host. What will happen if I upload this 227 mb database the the new server, will it be 227 mb too? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
kensai
Posting Yak Master
172 Posts |
Posted - 2002-11-22 : 17:31:20
|
| What if I try to export the database directly from the old server to the new one, using DTS Export Wizard, without me downloading/uploading it? Do you think the size of the database on the new server will be the same as the old one? |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-11-22 : 17:48:26
|
| I don't know. You don't need to transfer the data to a new server. You just need to run DBCC DBREINDEX and specify a fill factor of 100. If you need to maintain another fill factor, re-run DBREINDEX with the normal fill factor afterwards. Do these after the RESTORE operation and see if it clears out the unused data pages. There is a list of steps in the article that the author recommends. Follow those steps and see if it reduces the database size after the RESTORE operation.You can also try using DBCC SHRINKDATABASE to reduce the size, after you do the other steps. |
|
|
|
|
|
|
Restored database filesize