help with large log files -- sql server clients

Neither rhyme nor reason
3/23/2005 4:59:00 PM

Hi,

In SQL Server Enterprise Manager > Space Allocation. I can not reduce the
current size. I can restrict the to current size but I can not reduce it.
This lay person very much appreciates your help.

regards

S

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.805 / Virus Database: 547 - Release Date: 03-Dec-04

Andrew J. Kelly
3/23/2005 5:44:53 PM

Have alook at these:

http://www.nigelrivett.net/TransactionLogFileGrows_1.html Log File issues
http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
and AutoShrink
http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL
Server 7.0 Tran Log
http://www.support.microsoft.com/?id=272318 INF: Shrinking Log in SQL
Server 2000 with DBCC SHRINKFILE
http://www.karaszi.com/SQLServer/info_dont_shrink.asp Shrinking
considerations

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]

sql server clients : help with large log files