Transaction log backs up every 4 hours. And following the deletes we've got
a trans log of around 3 gigs. That totally blows away the drive space on
the pathetic server. Surely MS has built in a way to have bulk
inserts/deletes not logged.

Chuck Speaks
Database Administrator
Lithonia Lighting
770-860-3450
http://www.lithonia.com


-----Original Message-----
From: Mark.[Email Address Removed] Monday, February 25, 2002 10:16
To: [Email Address Removed] [Email Address Removed] RE: Transaction Log ...


This is functionality that they need? You could backup the transaction log
more frequently (will increase recovery time in a disaster). You could
increase the size of the log, or set truncate log on checkpoint if you don't
want full recovery options.

Be very careful what you set because you could affect the ability to recover
from a disaster.

Mark.
www.allisonmitchell.com

-----Original Message-----
From: Speaks, Chuck W. [mailto:[Email Address Removed] 25 February 2002 15:04
To: 'Mark.[Email Address Removed] Speaks, Chuck W.;
'[Email Address Removed] RE: Transaction Log ...


Bulk deletes on a date range.

Chuck Speaks
Database Administrator
Lithonia Lighting
770-860-3450
http://www.lithonia.com



*******

This message and any attachment are confidential and may be privileged or
otherwise protected from disclosure. If you are not the intended recipient,
please telephone or email the sender and delete this message and any
attachment from your system. If you are not the intended recipient you must
not copy this message or attachment or disclose the contents to any other
person.

For further information about Clifford Chance please see our website at
http://www.cliffordchance.com or refer to any Clifford Chance office.
MS Sql Server LazyDBA home page