[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:
> John,
>   Your problem is destailed here:
> http://sqlserver2000.databases.aspfaq.com/why-is-tempdb-full-and-how-can-i-prevent-this-from-happening.html
> you will find some good workarounds...let me know if you are not able
> to use any of them.
>
> --
> Francisco
>
>
> On 10/12/06, JWColby <jwcolby at colbyconsulting.com> wrote:
> > I am getting a notice that the log file is full (and in fact the disk is out
> > of space).  The warning says to backup the transaction log for the database
> > to free up some space.  When I go in to EM and try to backup the TempDB, the
> > transaction log is not selectable (is grayed out) and if I try to backup the
> > Tempdb itself I get a message that I can't backup the TempDB.
> >
> > What gives and how do I get out?
> >
> > I have a nice raid 5 terabyte data partition and a 400gb log partition, but
> > I initially set up SQL Server to place all of its stuff out on the D drive,
> > which is only about 250g and is not RAID.  Sigh.
> >
> > What do I do to back up this file so that I can continue?
> >
> >
> > 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 Billy Pang
> > Sent: Friday, October 06, 2006 3:42 PM
> > To: dba-sqlserver at databaseadvisors.com
> > Subject: Re: [dba-SQLServer] Access BE to SQL
> >
> > not sure what you mean by resetting autonumbers but during the data
> > migration you can use identity_insert setting to the values from autonumber
> > field in access to an identity field in sql server.
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_
> > set-set_7zas.asp
> >
> > also, if you find that it saves time, you might want to consider turning off
> > all foreign keys in the target db, import the data and then (crossing your
> > fingers) turn on the foreign key constraints using WITH CHECK (go look up
> > WITH CHECK and WITH NOCHECK for the alter constraint statement in books on
> > line
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_
> > set-set_7zas.asp
> > );
> >
> > hope that helps
> >
> > Billy Pang
> > http://dbnotes.blogspot.com/
> > "Once the game is over, the King and the pawn go back in the same box." -
> > Italian proverb
> >
> >
> > On 10/5/06, Steve Capistrant <scapistrant at symphonyinfo.com> wrote:
> > >
> > >
> > > 1.  Migrate Data to SQL.  Resetting of autonumbers, referential
> > > integrity, some indexes.  332 instances @ 10 minutes = 55 hours
> > >
> > >
> > > --
> > >
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
> >
>
>
> --
> -Francisco
> http://sqlthis.blogspot.com | Tsql and More...
>


-- 
-Francisco
http://sqlthis.blogspot.com | Tsql and More...