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 - SQL Server Tutorial
From the course: SQL Server 2008 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.