June 13, 2009 at 4:48 pm
Hello -
If sometime prior I use sp_dboption to set 'trunc. log on chkpt' on a database. Is their a "point and click" way to check that this option is set OR do I have to run a query in Management Studio?
Thanks very much.
June 14, 2009 at 1:30 am
Not AFAIK. Why would you want to do this anyway? This option can do bad things to your DB environment.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
June 14, 2009 at 2:04 am
I think you can't, did you check, right click on the database and select "properties" I advise you against it, you will result in database that can't recover to the latest transaction in case of database crush.
Oded
June 14, 2009 at 3:44 am
Truncate log on checkpoint is a deprecated option (has been since SQL 2000 I think) and will be removed in a future version. The replacement is to use the recovery models, simple if you want the log to auto-truncate and you don't need point-in-time recovery or full or bulklogged if you do need point-in-time recovery and intend to manage the log yourself.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 14, 2009 at 10:45 am
GilaMonster (6/14/2009)
Truncate log on checkpoint is a deprecated option (has been since SQL 2000 I think) and will be removed in a future version. The replacement is to use the recovery models, simple if you want the log to auto-truncate and you don't need point-in-time recovery or full or bulklogged if you do need point-in-time recovery and intend to manage the log yourself.
Right. My bad, for some reason I read "Truncate" but I think "Shrink" even though I know darn well that they are not at all the same. 🙁
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
June 15, 2009 at 4:11 am
can u run sp_helpdb 'db name' and provide us recovery model of ur db
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply