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