Monday, February 20, 2012

Reduce MDF file for SQL

How we can reduce unused space for SQL data tables?
You can shrink the file using DBCC SHRINKFILE, however unless you know that
you won't be requiring that space later, you will be better off leaving it
as it is. If the file has to endure an autogrow event, this can impact
performance during normal operation...
http://www.aspfaq.com/
(Reverse address to reply.)
"Martin" <Martin@.discussions.microsoft.com> wrote in message
news:CDDB0286-21E6-4E4D-9184-6CEA3A18CB75@.microsoft.com...
> How we can reduce unused space for SQL data tables?
|||A good explanation of how to do it and why you may not want to do it at
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
"Martin" <Martin@.discussions.microsoft.com> wrote in message
news:CDDB0286-21E6-4E4D-9184-6CEA3A18CB75@.microsoft.com...
> How we can reduce unused space for SQL data tables?

No comments:

Post a Comment