Reallocating Log File Space Allocated

[SeanB]

Hello all. Troad you might know this one. i initially set the Transaction Log Space Allocated to a gig which is to much and i want to bring it back down. When i try adjusting it, i get a message saying the DBFile must be larger than the current size. Any idea how to change this?

 

[tlbroadbent]

Check these resources for information about shrinking the log in SQL 7 and 2000/

Check the following resources.

Foxdev's FAQ183-345 in this forum.

Microsoft SQL 7 article

http://support.microsoft.com/support/kb/articles/Q256/6/50.ASP

Microsoft SQL 2000 articles

http://msdn.microsoft.com/library/en-us/architec/8_ar_da2_1uzr.asp

http://support.microsoft.com/support/kb/articles/Q272/3/18.ASP

At SWYNK.com

http://www.swynk.com/friends/krishnan/tranlogshrink.asp

Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.