Generate SQL Script to Set Simple Recovery Model and Shrink Databases

Tore Olav Kristiansen

Rate me:

4.60/5 (3 votes)

1 Jan 2016CPOL

12.1K

When you create a new SQL Server database, the default recovery model is Full. This model takes up a lot of disk space. It is ordinarily not necessary for developer images. This tip has a SQL script that helps you change this.

Views

Daily Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Tore Olav Kristiansen

Technical Lead IdentityStream

Norway

My name is Tore Olav Kristiansen and I am a developer. I am passionate about making coherent people-friendly solutions.

I have worked as a software engineer for 18 years. I am the founder of IdentityStream.

I have a masters in computer science from the University of Stavanger, Norway.

Generate SQL Script to Set Simple Recovery Model and Shrink Databases

Views

License

Comments and Discussions