Posted by m.bohse on 10/10/05 12:03

Having you database in SIMPLE recovery mode does NOT mean that
transactions are not logged. All it means is that all committed
transactions are removed from the T-log when a checkpoint occurs. So if
you run lot's of and especially longrunning transactions, it still can
happen that your T-log grows out of space.

M

• Next in forum: LIKE and IN can I combine
• Prev in forum: Re: Bulk Insert Fails !!!
• Thread view: Re: database in simple mode yet txn log file can be out of diskspace ?

[Reply to this message]