Last week I was moving my site to a new server
My SQL database in old host without Log file was 180 MB, and after shrink it became 170 MB,
I asked my old host support to give me DB back up for moving to new server, it was friday and they told me we will do that on monday, but I wanted it soon, so I logged in ino Enterprise manager to my old server sql, and also I opened connection to my new server sql ,I go to Export Wizard of my database on old host so I chose to export all of the tables from my database on old host to a new database on new server,
it took about 2 hour (with a 128 kb net connection) after finishing I tested the new database it was working fine and all of the tables and rows was in new database,
but some thing that is wondering is the size of the database the new database on new server is 109 MB now
I have shrinked the old database and without log files it was 170 MB so why on my destination database its 109 MB , and very thing is working fine
I want to know what was in old database that increased file size about 60 MB ?
and can I use my new database which its size is 109 MB ?
The only way I know to effectively help you is for you to post a copy of your database for us to examine. You told us that the copy is smaller than the original, which implies that something is missing. The only way I know to figure out what is missing is for one of us to repeat the process you've described, veryify that we get the same results, then figure out what is missing.
What you are asking is kind of like playing "Where's Waldo" via posting... If we can't see the picture, there's very little hope that we can guess where Waldo is. Without access to your original database, I don't know of any way that I'm willing to pursue to help you solve the problem.
One thing that might help you find the more obvious and potentially serious problems would be to script the database objects out to a text file for both your source and destination databases. You could then compare the scripts to see what objects (tables, indexes, views, procedures, etc) are missing. If all of the objects are present in the destination, then it is highly unlikely you are missing anything important.