neilheuer
SSC Eights!
Points: 946
More actions
May 29, 2002 at 10:19 am
#158338
Does anyone know how to programatically set the recovery level to simple on a database?
Thanks,
Neil
Andy Warren
SSC Guru
Points: 119902
May 29, 2002 at 10:42 am
#429925
Should be able to do it with an alter database statement - see BOL for the syntax. DMO also supports changing it with the recoverymodel property of the dboption2 object, but I wasnt able to get it to work in the quick test I did.
Andy
http://www.sqlservercentral.com/columnists/awarren/
AndySQLAndy - My Blog!Connect with me on LinkedInFollow me on Twitter
Antares686
Points: 125444
#429924
Thru TSQL it is
ALTER DATABASE [testDb] SET RECOVERY SIMPLE
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply