Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005

    Unanswered: tempdb maintenance - SQL Server 2000

    Can someone please explain what the tempdb database is responsible for in SQL Server 2000. The database and log file has grown extremely large and I cannot backup this table for some reason. Thanks.

  2. #2
    Join Date
    May 2004
    tempdb is not a table, it's a database.

    you don't need to backup tempdb. It's used for holding temp tables and table variables, and also for other operations that sql server needs to do from time to time when it needs some disk space (such as sorting).

    If I recall correctly, tempdb is truncated each time you restart the sql service, so there's really no point in backing it up even if it were possible.

    here's an article with more detail about tempdb:

Posting Permissions

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