var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to clear the logs
I want to clear the whole transaction log and sql server log...ie., just clear all the entires....how
dump tran db_name to data_device
At this point, any completed transactions will be flushed out to disk. If you don't care about the recoverability of the database, you can issue the following command:
dump tran db_name with truncate_only
If that doesn't work, you can use the with no_log option instead of the with truncate_only.
Remember that dumping the log only clears out completed transaction.
... if you (or your DBA) don't execute dump tran YourDB
sp_dboption YourDB, "trunc log", true