Results 1 to 2 of 2

Thread: tempdb

  1. #1
    Join Date
    Jun 2012
    Posts
    15

    Unanswered: tempdb

    if tempdb is get fulled? what to do?

    1 -> restarting sybase
    2 -> altering the tempdb space

    other than these two any other option is there?

  2. #2
    Join Date
    Jan 2012
    Location
    Lisbon
    Posts
    115
    Provided Answers: 1
    Hello Kumz,

    Besides those options you mentioned, there is the option to set the database option 'abort tran on log full' for tempdb.
    That way, the transaction will automatically abort and roll back.
    Without having to reboot the server.


Posting Permissions

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