Syntax help

[HLPCH]

Hi, Could some tell me the syntax to change the backup settings to Full Recovery mode? My Transaction log button is disabled and I guess if I change the Recovery mode to Full ,I could activate this option.

Alter database Test
< recovery_option > ::=
RECOVERY { FULL }

I tried the above and it does not work.

Thanks

 

[vongrunt]

Alter database Test set recovery full

?

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[SQLBill]

Remember you can not set the Master database to FULL.

-SQLBill

Posting advice: FAQ481-4875