Thursday, May 18, 2017

SQl SERVER: How to set recovery model to SIMPLE for all databases

Steps on how to set recovery model to SIMPLE for all databases 

Step 1. Run script
SELECT 'ALTER DATABASE ' + [Name] + ' SET RECOVERY SIMPLE'
FROM sys.databases
WHERE recovery_model_desc = 'FULL'
Step 2. Copy output and execute

No comments:

Post a Comment