If you have a SQL Server you must have a backup and restore plan. If you don’t you’re in for a rude awakening for sure. Backups are absolutely essential for your SQL Server protection from a dropped table to a ransomware attack. But building a backup strategy and restore plan can be daunting task if you’re new at it or …

Build a backup strategy and restore plan from scratch Read more »

To switch a database from simple to full recovery model, it is simple to do when you have one or two databases that need to be switched. You can either do it through the dialogs in SSMS by right clicking on the database and changing the recovery model, or you can run an alter database script. The difference between simple …

Switching multiple databases to FULL recovery model. Read more »