From the course: SQL Server 2008 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Restoring databases

Restoring databases - SQL Server Tutorial

From the course: SQL Server 2008 Essential Training

Start my 1-month free trial

Restoring databases

One of the reasons I like to get into the habit of backing up regularly even when I'm just working with sample databases on a development server is that it's way too easy to run a little bit a code that maybe does a little bit more than you expected. So I'm pasting in a few delete statements here. This is not the kind of code you want to execute a lot. Well this is going to do with the no WHERE statements is it's going to go through and delete everything in all of those tables. So say this accidentally happened yesterday, a few hours ago, a few seconds ago. And I'm now in the problem that when I go and look at my Customer table, for example, I have nothing whatsoever and this is not what I want. Well luckily I was doing regular backups so I can restore these. I'm going to do this from SQL Server Management Studio, though you can do it from the SQL command line. I'll right-click one of the databases again it doesn't matter. Even if the database wasn't showing up, you can still pick any…

Contents