|
Home > Archive > microsoft.public.sqlserver.server > September 2006 > Transaction Log File too big
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Transaction Log File too big
|
|
|
| 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.
>>
>>
>>.
>>
>.
>
| |
| pumisu 2006-09-04, 7:40 am |
| 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) |
|
|
|
|