Click here to read Part 1 Click here to read Part 2 Incremental Method This method has a few names and is fairly simple to implement. It involves determining how long you wish to maintain a copy of your data and how many tapes you wish to use. It is based on labeling each backup with a number and then …
So you have a backup for your SQL Server but are you certain it’s good enough for your business needs? Are you 100% sure you’ve configured your backup and restore plan correctly? If you answered No or Maybe to either of these questions you should revisit your backup/plan or freshen up your resume. Yep, it can be dangerous operating a …
25% OFF SQL Server Backup and Recovery Course Coupon Code: BACKUPFEB Expires: February 28th at 11:59pm This complete course will help you determine if you have a sufficient backup strategy and restore plan OR will help you build one from scratch.
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 »
Backup Retention Part 1 Backup Retention Part 3 In part 1 I spoke about why you would want to restore from backups and some other reasons to have an older backup around. In part 2 I will dive more into the specific types of backup retention methods. Part 3 I will define more on methods but also cover combined methods …
Backup Retention Part 2 Backup Retention Part 3 With backup retention times there is always a balance between keeping enough backups and purging those backups quickly to free up space. Some clients I have worked with only keep 2 to 3 days of backups, and others keep multiple years of backups. I generally like to push for something longer term …
With the rise in ransomware and freak weather we knew we must offer this service! Don’t let the next disaster end your business. With proper planning you can survive, and we can make it easy!
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 …