how to reduce log file size?

Hi all, i have a db with 200 mb log file size. It was set to unlimited grow,
and now i want to reduce its size to 50 mb. In db properties i restricted
log file size to the current size.
Any input would be very helpfull,
thanks> Hi all, i have a db with 200 mb log file size. It was set to unlimited
grow,
> and now i want to reduce its size to 50 mb. In db properties i restricted
> log file size to the current size.
Have you tried to archive (backup) it and shrink it again after that? The
T-SQL statement for this is:
BACKUP LOG yourdbname WITH TRUNCATE_ONLY
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Check out below KB articles:
INF: How to Shrink the SQL Server 7.0 Transaction Log
http://support.microsoft.com/defaul...kb;en-us;256650
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/defaul...kb;en-us;272318
Log File Grows too big
http://www.support.microsoft.com/?id=317375
Log file filling up
http://www.support.microsoft.com/?id=110139
Considerations for Autogrow and AutoShrink
http://www.support.microsoft.com/?id=315512
http://www.mssqlserver.com/faq/logs-shrinklog.asp
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Jessy" <admin@.zambak.com> wrote in message
news:uMhRU0D$DHA.620@.TK2MSFTNGP11.phx.gbl...
> Hi all, i have a db with 200 mb log file size. It was set to unlimited
grow,
> and now i want to reduce its size to 50 mb. In db properties i restricted
> log file size to the current size.
> Any input would be very helpfull,
> thanks
>|||Thanks guys, you all helped me a lot,
"Jessy" <admin@.zambak.com> wrote in message
news:uMhRU0D$DHA.620@.TK2MSFTNGP11.phx.gbl...
> Hi all, i have a db with 200 mb log file size. It was set to unlimited
grow,
> and now i want to reduce its size to 50 mb. In db properties i restricted
> log file size to the current size.
> Any input would be very helpfull,
> thanks
>sql