JWColby
jwcolby at colbyconsulting.com
Thu Oct 12 12:14:20 CDT 2006
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