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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Database Import

Author  Topic 

kishoreg
Starting Member

11 Posts

Posted - 2010-06-29 : 12:44:30
Hi, I have a database name as TestDB1 which is 18GB of size. I have created a new database name as TestDB2. I have imported the whole data from TestDB1 to TestDB2. After completion of importing i found the database size of TestDB2 as 7GB.

I have checked all the tables in both databases and found the data is same. Please let me know the solution and thanks in advance.

Regards,
Kishore.G

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-06-29 : 13:26:21
It is likely due to missing indexes. Rather than doing an export/import, you should instead do backup/restore or detach/attach to ensure the databases are identical.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2010-06-30 : 16:25:31
and/or t logs....unused space in db1..there are lots of reasons



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page
   

- Advertisement -