If the database can do with just a simple backup/recovery model, then…
- Change database from “Full” recovery model to “Simple” recovery model (Database Properties -> Options)
- Shrink database log file (Tasks -> Shrink -> Files -> Shrink Log Files)
If the database can do with just a simple backup/recovery model, then…
Comments