Posted by Erland Sommarskog on 03/11/06 21:18

deebeeay@gmail.com (deebeeay@gmail.com) writes:
> Many thanks for the reply David.
>
> If I do a dbcc shrinkfile using the TRUNCATEONLY option - would this
> reduce the amount of logging required?

As I understand Books Online, this should not be an expensive operation
with regards to the tranaction log. On the other hand, it may not have
much effect, since it removes only extents at the end of the data file.
If you mistakenly created a file 10 times too large, then I would
expect TRUNCATEONLY to be useful. But if you want to shrink the database,
because you just deleted 5 years worth of data, TRUNCATEONLY is not likely
to have any effect at all.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Execution Plan Hinting
• Prev in forum: Re: Linked Server via ODBC and stored procedure
• Thread view: Re: dbcc shrinkfile - SQL Server 2000 - invalidate log?

[Reply to this message]