Sign in
 
HomeLibraryLearnDownloadsRepositoryCommunityForumsBlog
>
>
>
How to set recovery model on many databases on multiple instances automatically?
Microsoft All-In-One Script Framework
Sorna Kumar Muthuraj
SQL

Solutions

Description

The script is used to set recovery mode on many databases on multiple instances automatically.

Questions (2)

Sign in to Ask a Question
  • Answer the Question | Hide
    you cant do this via a single script but yes you can easily change the recovery model of all user DBs on a single server.
    1 Posts | Last Post October 24, 2012
    • Written October 24, 2012 
      you can't do this via a single script, but yes you can easily change the recovery model of all user DBs on a single server.
May be after this you can register all your servers in SSMS centralised server and run the script at once on all registered servers.

Let me know if you want me to provide that statement.
  • Answer the Question | Hide
    Description
    1 Posts | Last Post October 21, 2012
    • Written October 21, 2012 
      Three recovery models exist: simple, full, and bulk-logged. Each recovery has its own features. Based on the recovery goals and requirements for the database and whether we can manage log backups, we could set the optimal recovery model for the databases. The script is used to set recovery mode on many databases on multiple instances automatically.

Related threads
http://social.technet.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/9f371b72-cae4-4823-9101-1543185da4ab 
http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/45ce9589-e81b-4d54-aa22-962d94d40bc9 

#AIOSF