|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
How to change Recovery modeWe 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? 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? > > > > > |
|||||||||||||||||||||||