This isn't so much a problem yet as a concern, and the hopes of avoiding a problem down the road.
We have a production application that uses a DB on MS SQL 2008. The DB is about 11GB. We are moving to a new version of the application but it requires MS SQL 2012. From the newly setup MS SQL 2012 server I did an import of the production database, which completed successfully though it took 90 hours. Once complete I did a backup, shrink DB, shrink file, and the new DB is 49GB.
I deleted the DB and tried the process a second time with the same results.
I haven't finished setting up the application, but don't want to expend a bunch of time and effort if there might be an underlying problem.
So the question is, would it be normal for a DB to expand that much with an import (SQL 2008 to 2012)? I am not a DBA, but the size difference seems pretty exceptional.
Thank you for any guidance you might have.