See mskb #
272318 INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE>
>I've developed a software which uses SQL2000 as back-end. The database has at about 50 tables and some of the tables has abt more than 3,000,000 records. As the time comes forward the size of LDF file gets increased and at this point it has reached to 80 GB while the size of MDF file is abt 7 GB.
>All I've tried with Backing-up Transaction Log, Shrink Data etc., but there is no effect on the size of the file.
>
>
>I've created the database with single MDF and LDF file with Options :
> "Automatically Grow file"
> File Growth By Percent 10%
>
> Maximum File Size : Unrestricted File Growth
>
>
>Please help me out How can I manage the Size of the Files for the database, and What is the best practices in order to maintain the Files (MDF,LDF).
>
>What happens when I select the option "Restrict File Growth = 10 MB", will it create automatically a new file or it will give an error when the size is reached.
>
>Thanks in advance
>
>Raoshan
--sb--