Wednesday, March 7, 2012

Compacting a database MS SQL

Hi
for mS SQL 2000-2500
LDF and MDF files can be very very big, if I import the datas into a new database they can become 10 time smaller
is there a way to compact (reduce the MB) of a database ?
thank youLook up DBCC SHRINKDATABASE and DBCC SHRINKFILE in BOL.|||thank you !|||Do not shrink your databases. It can impair performance. SQL Server databases are not like Microsoft Access databases, and do not need to be regularly compacted.|||if I import the datas into a new database they can become 10 time smaller.

is there a way to compact (reduce the MB) of a database ?

Yeah, you can transfer required data in the new database - using DTS.

Accordingly, make changes in your application for accessing old data too.

Note : Before any action you need to deeply analyze pros & cons for the current issues as well as upcoming issues.

No comments:

Post a Comment