Thursday, March 8, 2012

alter database syntax

ok i must be blind as I can't find/figure it out. What is the correct syntax
for alter database using the recovery full option. I want to change the
recovery method to full from simple. Thanks for the info.
Jasonalter database dbname
set recovery full
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Jason Meyer" <jason.meyer@.nospam.roseville.k12.mn.us> wrote in message
news:eUDT3RJ1DHA.3824@.TK2MSFTNGP11.phx.gbl...
> ok i must be blind as I can't find/figure it out. What is the correct
syntax
> for alter database using the recovery full option. I want to change the
> recovery method to full from simple. Thanks for the info.
>
> Jason
>|||alter database XXX
set recovery full
"Jason Meyer" <jason.meyer@.nospam.roseville.k12.mn.us> wrote in message
news:eUDT3RJ1DHA.3824@.TK2MSFTNGP11.phx.gbl...
> ok i must be blind as I can't find/figure it out. What is the correct
syntax
> for alter database using the recovery full option. I want to change the
> recovery method to full from simple. Thanks for the info.
>
> Jason
>|||never mind, found it. thanks
"Jason Meyer" <jason.meyer@.nospam.roseville.k12.mn.us> wrote in message
news:eUDT3RJ1DHA.3824@.TK2MSFTNGP11.phx.gbl...
> ok i must be blind as I can't find/figure it out. What is the correct
syntax
> for alter database using the recovery full option. I want to change the
> recovery method to full from simple. Thanks for the info.
>
> Jason
>

No comments:

Post a Comment