Francisco Tapia
fhtapia at gmail.com
Thu Oct 12 15:57:27 CDT 2006
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...