Restoring backups overview

• DataAnalyst011

  SSCarpal Tunnel

  Points: 4035

  More actions

  March 4, 2019 at 7:56 am

  #416741

  I'm all we have at the moment, and I'm trying to learn everything I can about disaster-handling before the event. I'm working through Brent Ozar's hierarchy here:

  https://www.brentozar.com/archive/2011/06/ozar-hierarchy-database-needs/

  I noticed the video he links to for restoring backups is a few years old. 

  https://sqlbits.com/Sessions/Event8/Back_From_the_Dead_How_to_Restore_a_SQL_Server_in_60_Minutes_or_Less

  Can anyone help me understand if this is still a good, basic overview? I'm setting up a test server to start practice (and test the .baks). As an FYI - We are running mostly SQL 2012 through 2016 using VMware in our nearby data centers.

  (By the way, if this is the wrong spot to be asking this please feel free to backhand me to another spot! 🙂

• Gamleur84

  Default port

  Points: 1475

  More actions

  March 4, 2019 at 7:32 pm

  #2023521

  Hi,

  When it comes to "disaster-event" you need to think about those 3 topics: Backup, High-Availability, Disaster Recovery.

  Now it seems you want to tackle the Backup topic. I guess you should start reading on different type of backups with SQL Servers:
  - https://www.sqlshack.com/understanding-sql-server-backup-types/

  Once you know what type of backup you have in place, then you can read about the restore process.

  I hope it helps.

• blakemcneill

  SSC Enthusiast

  Points: 162

  More actions

  March 5, 2019 at 7:17 am

  #2023564

  You may also want to read up on RTO and RPO: https://www.sqlskills.com/blogs/paul/the-accidental-dba-day-6-of-30-backups-understanding-rto-and-rpo/

  This may be very important to your company and/or customers depending on what their needs or requirements are.