Set DB Recovery Mode via T-SQL 1

[JayKusch]

Is there a command in T-SQL that will set the recovery mode of a database?

I have over 2000 DB remotely that I need to set the recovery mode for and do not wish to do it manually.

Thanks

J. Kusch

 

[ClaireHCM]

ALTER DATABASE database_name
SET RECOVERY [FULL | BULK_LOGGED | SIMPLE]

You can first query out result like the following.According to the databases which model you want them to be.Them run them at one time!

ALTER DATABASE MyDB1
SET RECOVERY FULL
Go

ALTER DATABASE MyDB2
SET RECOVERY FULL
Go

ALTER DATABASE MyDB1
SET RECOVERY FULL
Go

 

[JayKusch]

Thanks!

Thanks

J. Kusch