Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    Bangalore
    Posts
    28

    Unanswered: Larg TempDB Log file

    My SQL Server Tempdb log file looks to be very larg now...its taking up lot disk space...

    How is that I can control the size of tempdb log files...?? What should i do save some disk space...!!!

    Please help

  2. #2
    Join Date
    Jul 2004
    Posts
    191
    You can use this code:

    Backup Log Database_Name with Truncate_Only
    and then...
    DBCC Shrinkdatabase (DB_Name, Truncateonly)

    Which free up the space and releases it back to the operating system.

    You can create a alert for the tempdb and when it gets really big you can execute a job with the code above.

    Or

    Just create a job with the code above to execute nightly.


    Thanks

    Lystra

Posting Permissions

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