Re: How to manage the transaction log

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Good morning Aaron,

My hard disk has 100 GB, but the company quotas to 50 GB. Of the 50 GB
quota, I have 38 GB left at this point. I believe space on my hard drive is
not an issue.

I believe the actual issue is the limit on the SQL database size. From what
I observed from yesterday, when the SQL database size hits 2.53 GB, I can not
import data nor running any queries (append, update, delete, etc.). The
reason I am saying that is I was able to do anything regardless of the size
of transaction log; however, once I hit 2.53 GB on database, I could not do
anything.

I thought the SQL database size is 4 GB. Do you know why it would stop me
from doing anything once it hits 2.53 GB?

Thanks.

"Aaron Bertrand [SQL Server MVP]" wrote:

That sounds like you ran out of space on your disk, sorry. You said before
you have 50 GB free, have you verified that? Is your file system compressed
or maybe there is disk quota in place, which would prevent the log file from
growing? Are you sure the log file is in the location you think it is?


On 6/4/09 4:59 PM, in article
DEE03559-21AA-4C70-8B43-21CC9A25BA1F@xxxxxxxxxxxxx, "Accesshelp"
<Accesshelp@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Aaron,

Below is the message that I got when I tried to run the delete query. My
log file is 4.5 GB when I got this error.

Msg 9002, Level 17, State 4, Line 1
The transaction log for database 'SnfMCRData' is full. To find out why space
in the log cannot be reused, see the log_reuse_wait_desc column in
sys.databases

Thanks.

"Aaron Bertrand [SQL Server MVP]" wrote:

As I mentioned in my previous post, the issue is even if I set the log file
to be unlimited, I was not able to run the append queries when the log file
hit 8 GB.

What does "not able to run" mean? Do you get an error message? If so,
could you be specific?




.

Relevant Pages

  • Re: How can I measure web hits from my web browser/end user perspective....?
    ... The more usual approach is to count pages rather than raw hits. ... file and count the entries. ... View the log file and count ... View page one, jump to a different web site, return to page two. ...
    (comp.lang.perl.misc)
  • SQL Server 2000 behind ZoneAlarm Pro 4
    ... I am getting over 50 hits per second that are trying to get into the SA ... it is creating a log file which is not manageable. ... before and I really do not know what to block or change regarding SQL. ... I want to make it that the only way to access SQL is to go ...
    (comp.security.firewalls)
  • Re: how to enbale logging ?
    ... that happens on the device would be logged into a db or a log file!! ... ANYBODY REFERS ME TO AN ARTICLE DESCRIBING THAT< WOULD BE HIGHLY APPRECIATED ... and 102 hits isn't all that much to wade through. ... remove the underscores from my email address (and please indicate which newsgroup and message). ...
    (microsoft.public.pocketpc.developer)
  • Re: SQL Server 2000 behind ZoneAlarm Pro 4
    ... >it is creating a log file which is not manageable. ... >stop these hits from making it to the SQL log? ... >before and I really do not know what to block or change regarding SQL. ... I want to make it that the only way to access SQL is to go ...
    (comp.security.firewalls)
  • Truncating, Deleting or Shrinking Log File
    ... I have a SQL database whose log file has grown so big that ... i cannot even perform a backup because error 112, ... really do not care about the log file since my database is ...
    (microsoft.public.sqlserver.programming)