This is something that has really come in the news over the last couple years. A lot of civil unrest. Living in the Pacific Northwest, we heard a lot about what was going on in Seattle, and as Seattle decays …
Will your backup and recovery strategy cover you? So what about ransomware? A lot of people are getting hit with ransomware lately. I’ve seen more people lose their systems with ransomware than I have with almost any other type of …
Are you familiar with recovery time objective and recovery point objectives? These are really important factors when you’re planning your SQL Server backup strategy. First, we’ll take a look at the recovery point objective. Recovery Point is really looking at …
Recovery Point Objective and Recovery Time Objective 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 …
Switching multiple databases to FULL recovery model. Read more »
I often times get the question similar to “Why is my log file not shrinking when I do regular backups”? It goes to show there the functionality of the SQL Server transaction log is not entirely clear. The way that …
Why is my log file not shrinking when I do regular backups? Read more »
In the consulting world we come across many different backup and restore options for SQL Server with the different clients that we work with. Personally I am a big fan of the SQL Server backups using a combination of Full, …
When you do a database restore, including log backups, it is very important to get the log chain in the right order, or it won’t work. To restore a full backup, then log backups, the chain of logs could be …
Reliable DBA Services is one of the things I talk about on my business website at http://StedmanSolutions.com, but that can mean many things to different people. To me this has many meanings. Today the reliability of having RAID10 on my …
After rebooting a SQL Server, for whatever reason, it is always good to confirm that the system is running good. There are many things that I check, one of which is to confirm that backups are running. You can always …
In preparation for an upcoming SQL Saturday presentation I have created another report to add to the FREE SQL Server Health reports project. This report has been replaced with the Backup Report in the Database Health Project. The Backup Set …
Backup Set Report added to FREE Server Health Reports Read more »