Arthur Fuller
artful at rogers.com
Fri Sep 10 00:04:12 CDT 2004
One thing that you absolutely must check as soon as possible is the data type of all your columns. Any Ntext fields should be converted to text, since this data is not for consumption in 2-byte countries. You always need twice or thrice the space that any given SQL job will consume. That's a basic rule of thumb. Don't shoot the messenger. I hope the client is paying you a lot for this gig, JC, because you're soon going to be as hairless as Andre Agassi. A. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John W. Colby Sent: Thursday, September 09, 2004 9:53 PM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Can I abort EM job? Well... I turned logging back on (bad move) then tried to add an identity field to my table. Two days later... The log file has run out of room (200g) the data files are about to run out of room etc. It gave me a warning that the original table was built without ANSI Null or some such and that it was going to build a new table with that turned on. So... Is there any halting the process? If I do will it roll back (for two damn days)? Am I screwed and just have to load the data all over again? John W. Colby www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John W. Colby Sent: Thursday, September 09, 2004 1:41 PM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] SQL Server Backup Can anyone explain to me what SQL Server does when it backs up. I have this largish database that I need to backup and I need to know if I need the same amount of room for the backup as is used for the db itself, if compression is used, how much it helps etc. John W. Colby www.ColbyConsulting.com _______________________________________________ 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