John W. Colby
jwcolby at colbyconsulting.com
Thu Sep 9 20:52:50 CDT 2004
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