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 businesses are impacted. There was a lot of things happening on Capitol Hill in Seattle last summer or the summer …
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 failure! Generally, with system failures, when you need to restore from backup, even if you have a lame backup plan, …
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 when the system fails what is the worst case for a point in time that you can restore up to. …
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 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 »
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 backups and the log file work is that the log file is made up of internal virtual log files (VLFs). …
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, Differential, and Log backups so that we can do a solid point in time restore when needed. I also like …
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 hard to sort out if you have dozens or hundreds of log backups to restore. Your sure don’t want to …
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 home office computer saved the day. Drive Failure Last Year A year ago not long after starting working at …
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 go to the server browse to the various directories holding backups, and check on the latest files. This can be …
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 Report has been added to the SQL Health Reports. The Backup Set Report is the 7th report to be added to the Database …
Backup Set Report added to FREE Server Health Reports Read more »