This ONLY works for the TEMPDB log file. Be careful of the advice you give.
Quote:
Originally posted by WingMan
You can always do a quick bodge .... shut down the database service (not machine!) delete the log and then start the service again.
If you can also use a maintainence script or stored procedure that will backup the database and then 'flush the log' file.
|