top of page
  • Twitter Social Icon
  • Facebook Social Icon
  • LinkedIn Social Icon

How to Change Recovery Model to Simple or Full for All Users databases?

  • Writer: Filip Holub
    Filip Holub
  • Dec 20, 2016
  • 1 min read

You can find this article helpful, if you have ten or more databases in recovery model "Simple" and you want to change it to "Full", for example because of backuping Logs. My script exclude system databases and all user databases that have "Full" set in Recovery Model.

Here is Condition:

SELECT name FROM sys.databases WHERE database_id > 4 and recovery_model_desc = 'SIMPLE'

Cursor is working only with user databases in "Simple" mode.

You can use my Cursor below!

¡Hasta la vista!

Cursor for Change Recovery model

 
 
 

Comments


RECENT POST
  • Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon

© 2020 All rights reserved. PigeonSQL.com | Filip Holub

bottom of page