Syntax for Setting 'Recovery_Option'
Posted on 2002-07-16
I am having trouble with the syntax to set the 'Recovery_Option' on a database. It is
currently set at 'simple' and I need to
change it to 'full'.
I am looking at the help file, but I am very
poor at understanding the correct syntax from
it. Here is what I have. (It doesn't work.)
alter database SqlTest SET 'recovery_option' = recovery full
What should it be?