datafile size reduced after dts export/import

[grimwyre]

We have a database that was approx 35 GB in size.

It was necessary to export the database off the server and then import it back again.

This process reduced the size of the datafile to 19 GB.

Is this effectively defragmenting the database and claiming back free space?

Does anyone recommend doing this on a regular basis or is there an easier way of doing it?

Thank you.

 

[JayKusch]

Shrink DB task will do the same thing. YES ... DTS exported the data and all "free space" in the DB was not. Effectively "defraging" your DB.

Thanks

J. Kusch

 

[TitleistDBA]

On a regular basis you should do the following to not only get back from space but to improver performance.

You should run DBCC REINDEX (tablename, '', 0)
on all your tables. This will clean up your indexs. Indexs will get dirty after a few weeks of use, expecially in a volitile database.

You should also do the following commands on a regular basis.

dbcc shrinkdatabase
(dabasename, TRUNCATEONLY)


DBCC SHRINKFILE
(log file name, TRUNCATEONLY)

you can get your log file name like this.
select * from sysfiles.
You can find out more about these commands in BOL.

http://www.acushnetcompany.com