What are some of the common scenarios that may cause you to need to recover from your SQL Server backups? Dropped or truncated table: What if someone dropped a table. How are you going to get that back? Does your current backup strategy have you covered? What if you have a hard drive failure? Do you have backups that are …
So how about flooding or hurricanes? I live in the United States Pacific Northwest, about as far away from Florida as you can be in the lower 48 United States. So I have not experienced hurricanes, I have only heard stories. But I have seen flooding, there’s a lot of lowland areas where flooding can occur. But this is one …
Backup and Recovery – flooding and hurricanes, are you covered? Read more »
All right, so how about someone dropped or truncated a table? What are you going to do? There’s the joke about a child named little Bobby Tables. He is the SQL injection guy who’s parents named him. Robert’); DROP TABLE Students; — And what that name does, is it SQL injection that basically closes out the current SQL statement, then …
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 »