Lesson Learned: Only Restoring WHERE you want
As a DBA, my job is to protect the company’s data at all costs. But what happens when it’s the DBA who causes data loss? I wrote about this a couple of years ago when I accidentally restored a backup copy on a production instance. One of the things I do on a regular basis [...]
Backing Up for my Primary/Secondary Environments
Every environment is different, and that means everyone does backups differently. I thought I’d talk about how I do it in my environment. For most of our key business applications, we have two sets of servers, a primary and secondary. The secondary servers are in a different data center. Fortunately, bandwidth isn’t a problem. I [...]