Posted by Erland Sommarskog on 11/22/06 22:12

(d.grabov@gmail.com) writes:
> I've been trying with:
>
> BACKUP LOG dbname WITH TRUNCATE_ONLY
> DBCC SHRINKFILE (dbname)
>
> but the query cannot execute because of the mirroring

Which of them? Certainly, I can imagine that BACKUP LOG WITH TRUNCATE_ONLY
is not permitted when you have mirroring. Then again, why would you
want to truncate the log? Just back it up to remove the active portion.

It may still be that you cannot shrink a log when you have mirroring
active. In such case, you will have to make the choice of smashing the
mirror to be able to shrink the log, or remember the old proverb "disk
is cheap".

--
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: restore sql 2000 bak to 2005
• Prev in forum: Re: Xquery Help SqlServer2005
• Thread view: Re: Shrinking database log used for mirroring

[Reply to this message]