Posted by deebeeay@gmail.com on 03/10/06 16:49

Many thanks for the reply David.

If I do a dbcc shrinkfile using the TRUNCATEONLY option - would this
reduce the amount of logging required?

• Next in forum: Re: Too Many SET Options
• Prev in forum: Re: Optimization jobs - transaction deadlock victim
• Thread view: Re: dbcc shrinkfile - SQL Server 2000 - invalidate log?

[Reply to this message]