Home All Groups Group Topic Archive Search About

How to change Recovery mode

Author
26 Aug 2005 4:23 AM
ad
We can use the codes below to get the recovery mode of a database:
select DatabasePropertyEx('test', 'Recovery')
Now I want to change a database's Recovery to SIMPLE.

How can I do that?

Author
26 Aug 2005 5:28 AM
Raymond Yuen
Hi ad,

Try: Alter Database <DB Name> Set Recovery Simple

Show quote
"ad" wrote:

> We can use the codes below to get the recovery mode of a database:
> select DatabasePropertyEx('test', 'Recovery')
> Now I want to change a database's Recovery to SIMPLE.
>
> How can I do that?
>
>
>
>
>

AddThis Social Bookmark Button