Home Forums SQL Server 2005 Backups script to set all user database to simple recovery model RE: script to set all user database to simple recovery model

  • We do not want to generate a line for databases that are already in simple recovery mode.  Add an 'OR' statement if you use bulk_logged
    select 'alter database ['+name+'] set recovery simple' from master.sys.databases where database_id > 4 and state_desc = 'online' AND recovery_model_desc = 'full;'

    I use your script all the time and have to add that AND recovery_model_desc = 'Full;' part so I thought others might like the addition.

    'nix