Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    BH - MG - BRAZIL
    Posts
    13

    Unanswered: Tempdb Is Growing So Much

    Hi!!!

    I have a DTS task. It's take data from DB1 and transport to DB2.
    When It's running my TEMPDB is growing so much.

    I have 10 Gb free space but it's enough.
    My model recorey is simple to DB1, DB2 and TEMPDB.
    They are in the same server.

    Is there something that can I stop this growing?

    Thank you since now.

    Excuse me my basic english.

    Bye.

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

    Re: Tempdb Is Growing So Much

    TempDB is growing because you ask it to grow. I don't exactly know how you constructed your DTS. Maybe you can review and see if there some excessive tempdb usage in the script that can be eliminated.

Posting Permissions

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