DBCC SHRINKDATABASE() will try to remove unused space from the database and actually reduce the size of the database files. This is not something that is usually done although there is nothing that says that you can't do it.
-Mike
>hi all,
>I'm writing a backup script to backup all the databases on my server.
>is it advisable to run the dbcc shrinkDatabase after taking the backup with TRUNCATEONLY option ???