> > >
How to set recovery model on many databases on multiple instances automatically?
Sorna Kumar Muthuraj
SQL

Solutions

Description

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

Questions (2)


  • 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
    • 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.
  • Description
    1 Posts | Last post 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