Results 1 to 6 of 6

Thread: Log file issue

  1. #1
    Join Date
    Apr 2003
    Posts
    176

    Unanswered: Log file issue

    my Log file has grown to a very large size for the last two days(from 1 GB to 9 GB).What should be the reason and how can i see the free space in my databse.
    Thanks.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What's your recovery model, and when was the last time you a) backed up the database or b) dumped the transaction log...

    That's an awfully big log btw....

    You set it to unlimited growth?

    I Don't think (damn I did it again) that if you do, that it's a good idea...

    Need to set alerts when the get to with a % of max...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Log file issue

    Large number of writes can cause it. How often do you backup your transaction log? If you haven't done it for a while, it's time. To see your free space, simply go to EM and right click the database, click view ant then click Task Pad.

  4. #4
    Join Date
    Apr 2003
    Posts
    176
    My database doesn't have any writes,But what i observed is that it's coz of sql server agent and its jobs. The log stopped to grow after i stopped sql server agent. Should it be because of backups or anything?
    I am just taking a differential back of the database,Not taking any transactional backup.
    Can anyone help in this issue?

  5. #5
    Join Date
    Apr 2003
    Posts
    176
    And one more question regarding the same issue,how can i bring my log size to the earlier size, which should be around 1 GB(which is now 10 GB)
    Thanks

  6. #6
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    read up on dbcc shrinkfile in SQL BOL
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •