I have set up my database to be using "Simple" mode. This will not log any
txns ?
I have got the err message saying the log file is full and i need to do a
txn log backup
i do not understand why , could anyone kindly advise ?
tks & rdgs
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forum...eneral/200510/1Having 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
No comments:
Post a Comment