healthcare
Newbie
Points: 3
More actions
November 19, 2003 at 2:01 pm
#106482
Does anyone know of a way to set SQL Server 2000 so that, on a full log, the transactions are suspended rather than aborted?
Andy Warren
SSC Guru
Points: 119902
November 20, 2003 at 5:32 am
#482830
No. You could code for the error and have it save the transaction to another db or even to a local disk. Or fire an alert that frees up reserved space and/or grows the log.
Andy
http://www.sqlservercentral.com/columnists/awarren/
AndyConnect with me on LinkedIn
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply