Shrinking Logs

[AY]

I have a transaction log file which is 29 GB in size. I am trying to
reduce it by using dbcc shrinkfile with truncate_only but, it has no
affect on it. So, I tried to look at the logs by running dbcc loginfo
(dbname). The last log is what's active (status is 2). How do I make
this status to wrap to first log so that dbcc shrinkfile would work?
All other logs have status of 0, after running backup log dbname
truncate_only

Thanks.

[Manoj Rajshekar]

Am*********@adaptec.com (AY) wrote in message news:<22*************************@posting.google.c om>...

I have a transaction log file which is 29 GB in size. I am trying to
reduce it by using dbcc shrinkfile with truncate_only but, it has no
affect on it. So, I tried to look at the logs by running dbcc loginfo
(dbname). The last log is what's active (status is 2). How do I make
this status to wrap to first log so that dbcc shrinkfile would work?
All other logs have status of 0, after running backup log dbname
truncate_only

Thanks.

Hi,
Initially do a backup log <dbname> with no_log and then do the dbcc
shrinkdatabase. That will take care of it.

Regards,
-Manoj

[Greg D. Moore \(Strider\)]

"AY" <Am*********@adaptec.com> wrote in message
news:22*************************@posting.google.co m...

I have a transaction log file which is 29 GB in size. I am trying to
reduce it by using dbcc shrinkfile with truncate_only but, it has no
affect on it. So, I tried to look at the logs by running dbcc loginfo
(dbname). The last log is what's active (status is 2). How do I make
this status to wrap to first log so that dbcc shrinkfile would work?
All other logs have status of 0, after running backup log dbname
truncate_only
What version of SQL Server?


Thanks.

[AY]

"Greg D. Moore \(Strider\)" <mo*****@greenms.com> wrote in message news:<XO******************@twister.nyroc.rr.com>.. .

"AY" <Am*********@adaptec.com> wrote in message
news:22*************************@posting.google.co m...

I have a transaction log file which is 29 GB in size. I am trying to
reduce it by using dbcc shrinkfile with truncate_only but, it has no
affect on it. So, I tried to look at the logs by running dbcc loginfo
(dbname). The last log is what's active (status is 2). How do I make
this status to wrap to first log so that dbcc shrinkfile would work?
All other logs have status of 0, after running backup log dbname
truncate_only

What version of SQL Server?

Thanks.

SQLServer 7.

[Greg D. Moore \(Strider\)]

"AY" <Am*********@adaptec.com> wrote in message
news:22*************************@posting.google.co m...

"Greg D. Moore \(Strider\)" <mo*****@greenms.com> wrote in message

news:<XO******************@twister.nyroc.rr.com>.. .

"AY" <Am*********@adaptec.com> wrote in message
news:22*************************@posting.google.co m...

I have a transaction log file which is 29 GB in size. I am trying to
reduce it by using dbcc shrinkfile with truncate_only but, it has no
affect on it. So, I tried to look at the logs by running dbcc loginfo
(dbname). The last log is what's active (status is 2). How do I make
this status to wrap to first log so that dbcc shrinkfile would work?
All other logs have status of 0, after running backup log dbname
truncate_only

What version of SQL Server?

Thanks.

SQLServer 7.

Try:

http://support.microsoft.com/default...b;en-us;256650

Worked well for me.