|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Increase Transaction Log - Please Help???
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Increase Transaction Log - Please Help???
|
|
|
| Thanks in adnvance for your help
Is there a way to increase the size of the transaction log manually?
Even though I have the database prop for the tran log set to auto increase I
am still getting error
Server: Msg 9002, Level 17, State 6, Line 1
The log file for database 'Client' is full. Back up the transaction log for
the database to free up some log space.
I think it is b/c the total size for the transaction log is only 2 MB.
Why isn't the tran log growing auotmatically?
thanks
J
| |
|
| Is your hard drive out of room?
"J" <spamjkolt89@hotmail.com> wrote in message
news:uIiGeONkCHA.2188@tkmsftngp08...
> Thanks in adnvance for your help
>
> Is there a way to increase the size of the transaction log manually?
>
> Even though I have the database prop for the tran log set to auto increase
I
> am still getting error
>
> Server: Msg 9002, Level 17, State 6, Line 1
> The log file for database 'Client' is full. Back up the transaction log
for
> the database to free up some log space.
>
> I think it is b/c the total size for the transaction log is only 2 MB.
>
> Why isn't the tran log growing auotmatically?
> thanks
>
> J
>
>
| |
|
| Chris,
No, it has over 9 gigs
Tran log was set to increase by 10 % ( of 2 mb ) so I changed it to increase
100 MB automatically but I am still having the same problem.
J
"chris" <chris@fin2000.com> wrote in message
news:eS4lNRNkCHA.1860@tkmsftngp09...
> Is your hard drive out of room?
> "J" <spamjkolt89@hotmail.com> wrote in message
> news:uIiGeONkCHA.2188@tkmsftngp08...
> > Thanks in adnvance for your help
> >
> > Is there a way to increase the size of the transaction log manually?
> >
> > Even though I have the database prop for the tran log set to auto
increase
> I
> > am still getting error
> >
> > Server: Msg 9002, Level 17, State 6, Line 1
> > The log file for database 'Client' is full. Back up the transaction log
> for
> > the database to free up some log space.
> >
> > I think it is b/c the total size for the transaction log is only 2 MB.
> >
> > Why isn't the tran log growing auotmatically?
> > thanks
> >
> > J
> >
> >
>
>
| |
| Tibor Karaszi 2002-11-21, 5:23 am |
| Under some circumstances the log doesn't seem to "catch up" with the autogrow. Don't rely on the
autogrow too heavily. Just pre-allocate reasonable amount of space.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"J" <spamjkolt89@hotmail.com> wrote in message news:uIiGeONkCHA.2188@tkmsftngp08...
> Thanks in adnvance for your help
>
> Is there a way to increase the size of the transaction log manually?
>
> Even though I have the database prop for the tran log set to auto increase I
> am still getting error
>
> Server: Msg 9002, Level 17, State 6, Line 1
> The log file for database 'Client' is full. Back up the transaction log for
> the database to free up some log space.
>
> I think it is b/c the total size for the transaction log is only 2 MB.
>
> Why isn't the tran log growing auotmatically?
> thanks
>
> J
>
>
|
|
|
|
|