Search
  • Filip Holub

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


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!


0 views
  • Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon

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

  • Twitter Social Icon
  • Facebook Social Icon
  • LinkedIn Social Icon