April 26, 2008 at 1:14 am
Hello everyone, is there any SQL stmt to access log? Can i go into log file just as we go in MDF file "select , delete from xyz..... "
As i want to delete the last 7 days log so is there any way to do this with the sql stmt, as with the help of sql stmt we can shrink the log but if i want to delete the last 7 days log by using sql stmts than how can i do this without using the Job Schedulers ?
Thanx in Advance.
April 26, 2008 at 10:28 am
What about data older than 7 days, do you want to keep it there?
I don't think you can truncate committed data selectively from the log. It's a all or nothing situation. You would typically do it with a log backup statement. You also have the option to truncate the log without generating a log backup file with the "WITH TRUNCATE_ONLY" option.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply