Sql server log File Full Error

[Vineet Bisht]

Dear Sir

I have problem which I am describing below:-

In my databse , size of Data file is 40 MB
size of Log file is 4158 MB

which is causing the size of my database so huge

why this log file is so huge ?

How I can control it, I have already set Parameter for Data and Log file
i.e

Unrestricted Growth and Grow Automatically 10-Percent

I want to control Log file Size.

Regard's
Vineet Bisht


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[John Bell]

Re: Sql server log File Full Error

Hi

Check out:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_7vaf.asp

and

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_1uzr.asp

Growth as an percentage is not really a good idea as it is exponential, if
you choose an initial size that is sufficient for normal work, it should not
grow that much, initially making it too small will mean that it will have to
grow too often. Having a fixed increment should mean that you do not get
excessive growth, but it may be necessary to periodically check the size and
shrink it.


John

"Vineet Bisht" <vinbisht@yahoo .com> wrote in message
news:40778cc4$0 $205$75868355@n ews.frii.net...[color=blue]
>
> Dear Sir
>
> I have problem which I am describing below:-
>
> In my databse , size of Data file is 40 MB
> size of Log file is 4158 MB
>
> which is causing the size of my database so huge
>
> why this log file is so huge ?
>
> How I can control it, I have already set Parameter for Data and Log file
> i.e
>
> Unrestricted Growth and Grow Automatically 10-Percent
>
> I want to control Log file Size.
>
> Regard's
> Vineet Bisht
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it![/color]

[Steve Jorgensen]

Re: Sql server log File Full Error

On 10 Apr 2004 05:57:24 GMT, Vineet Bisht <vinbisht@yahoo .com> wrote:
[color=blue]
>
>Dear Sir
>
>I have problem which I am describing below:-
>
>In my databse , size of Data file is 40 MB
> size of Log file is 4158 MB
>
>which is causing the size of my database so huge
>
>why this log file is so huge ?
>
>How I can control it, I have already set Parameter for Data and Log file
>i.e
>
>Unrestricted Growth and Grow Automatically 10-Percent
>
>I want to control Log file Size.
>
>Regard's
>Vineet Bisht[/color]

Which recovery model do you have set on the database? Are you running
frequent backups? If not, do you have the simple recovery model selected? If
not, your log will simply fill up, no matter how big you make it.