I am attaching a content db from moss 2007 SP version to SharePoint enterprise 2010 edition as part of refer for the overall objective. but the content db is occupying the complete space. is there any best practice or configurations that should be followed.
This one is expected behavior.
When performing the upgrade, you need to plan on having plenty of drive space available on both System drive as well as Data drive and Log Drive for SQL. Here is some real time example.
Once I moved the database to a terrabyte partition, the error was resolved. I found that, in order to reliably upgrade a SharePoint 2007 content databases to 2010, you'll need to plan for allowing the content database to triple in size during the upgrade. If your content database is 100 GB, you'll need at least 300 GB for the log files to grow. SharePoint 2010 Upgrade Failure - Executing DDL Script When we migrated our 2007 to 2010, I checked, we had 3 times of the existing size of DB.