[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 561
  • Last Modified:

sql server 2005 - kill log

The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

How do I truncate the tempdb log?

Don't send me a link
0
JElster
Asked:
JElster
1 Solution
 
Mohammed KhawajaManager - Infrastructure:  Information TechnologyCommented:
Failsafe way is to start SQL server in single user mode and then shrink the database log file:

1. Stop SQL Server service
2. Go to the folder containing sqlservr.exe and run sqlservr.exe -c -f
3. Run the following command:

ALTER DATABASE tempdb MODIFY FILE
   (NAME = 'tempdev', SIZE = target_size_in_MB)
   --Desired target size for the data file

   ALTER DATABASE tempdb MODIFY FILE
   (NAME = 'templog', SIZE = target_size_in_MB)
   --Desired target size for the log file

For more explaination, go to http://support.microsoft.com/kb/307487 for two other methods and a better explaination
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now