Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    12

    Unanswered: Newbie - sql server 2000 transaction log size limit

    Has anybody encountered a physical size limit for a sql server 2000 transaction log running on win2k?

    Transaction log reached ~6Gb before rolling back the delete stating transaction log was full. There was 42Gb free on the server and the log was set to unlimited growth.

  2. #2
    Join Date
    Aug 2003
    Posts
    9

    Re: Newbie - sql server 2000 transaction log size limit

    Originally posted by axis
    Has anybody encountered a physical size limit for a sql server 2000 transaction log running on win2k?

    Transaction log reached ~6Gb before rolling back the delete stating transaction log was full. There was 42Gb free on the server and the log was set to unlimited growth.



    When the size is set to unlimited I think the limit is as big the win2k can handle?
    I had once a log file of 15 Gb big

  3. #3
    Join Date
    Jan 2004
    Posts
    12
    usually helps if you make sure the path to the transaction log actualy is where you think it is. Created an extra log on the drive that did have 42gb and all is well.

    thanks

  4. #4
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    usually helps if you make sure the path to the transaction log actualy is where you think it is. Created an extra log on the drive that did have 42gb and all is well.

    thanks
    Thats true !!! sp_helpdb dbname always helps ...
    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
  •