[dba-SQLServer] The log file for TempDB is full

That worked.  Thanks Francisco.

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco
Tapia
Sent: Thursday, October 12, 2006 5:14 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] The log file for TempDB is full

to move your TempDB use the following
---
use master
go
Alter database tempdb modify file (name = tempdev, filename =
'Drive:\Path\tempdb.mdf')
go
Alter database tempdb modify file (name = templog, filename =
'Drive:\Path\templog.ldf')
Go
---
There is more info here as well:
http://www.databasejournal.com/features/mssql/article.php/3379901

On 10/12/06, Francisco Tapia <fhtapia at gmail.com> wrote: