[dba-SQLServer] Can I abort EM job?

aborting the job now won't cause you to loose data, but it will cause
additional delays as the log files have to be used to restore the
database to before you ran your job.


On Fri, 10 Sep 2004 01:04:12 -0400, Arthur Fuller <artful at rogers.com> wrote:
> 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
> 
> 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 



-- 
-Francisco