I tried that.
Is not working.
I think because I have a transaction open.

I need a different solution.

Thank you


>-----Original Message-----
>Hi,
>
>U might find this link interesting:
>
>http://support.microsoft.com/default.aspx?scid=kb;EN-
>US;Q272318
>
>Regards, Carsten Daugaard
>
>>-----Original Message-----
>>How can I schrink the transaction log file ? (over 6Gb)
>>I tried several methods and is not geting smaller.
>>The database is a publisher.
>>I run this command:
>>
>>DBCC OPENTRAN
>>
>>and I got this:
>>
>>Transaction information for database 'DB'.
>>Replicated Transaction Information:
>> Oldest distributed LSN : (0:0:0)
>> Oldest non-distributed LSN : (370:19056:1)
>>DBCC execution completed. If DBCC printed error
messages,
>>contact your system administrator.
>>
>>
>>.
>>
>.
>

Report this post to a moderator

The reason to not decrease the file size is that you are saving all transaction data from the begining of your database.

You must select a different recovery model to be able to shrink the log file.

On the enterprise manager right click on your database icon and select properties

choose the options tab anb change the recovery model to simple.
You can choose also the option auto shrink on this tab.

You can shrink all database files or only the log file as you want (I recommend to shrink all files)

Report this post to a moderator