Hi All,

I Export data from DB2 and convert it to SQL server.

My data in DB2 about 12MB, but when I import to SQL Server, after I backup data from SQL Server then my data file was over 500MB or 1GB.

Why is it that? Could you help me?

Thank you so much.

Best regard,

Minh Phan Xuan

Try to truncate your log file. This could be because of the logfile size. Also check the File Growth Properties of both the mdf and the ldf

Regards
Ganesh

Do a shrink database / shrink file, that should reduce the DB size and free up the unused space. Check for DBCC in Books online or you can do that from Enterprise manager.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

Try BACKUP LOG FOR TRUNCATE ONLY. If it doesn't work then

Use DBCC SHRINKDATABASE / DBCC SHRINKFILE. U can see the physical file name through Enterprice manager.

Also create a DB Maintanace plan which should take Transaction Log Backup frequently. Otherwise u will again find ur DB file large after some times.

See books on line for details related to these.


B. Anant