ARTICLE

321 163

How to Restore a Database in SQL Server 2008

Posted by Vamshi Krishna in Articles | SQL Server 2012 on March 29, 2011

Tags: Restore Database in SQL Server 2008, SQL Server 2008, SQL Server IDE, SQL Server Management studio, VS 2010

You will learn how to restore a database in SQL Server 2008

Tweet
3784
0

Reader Level: Beginner

Step 1:

Copy a backup file and paste it into your system (that means paste into any drive (D:/, E:/ ...))

Step 2:

Open SQL Server Management studio.
Go to Object Explorer (it is located in the left side) in the SQL Server IDE.
Select "Database" and Right-click.
A window will open; in that window select the "Restore Databases.." Option.
Another window will open.
That window has...
"Todatabase" option; you can give any Database name.
And select "From Device" radio button and go to browse ... and select "backup file".
Specify Backup window; in that window click the "Add" button.
The drives window displays; select your backup file from your system drives.
Click OK button.
Another wIndow displays; in that window ...
Check the "Restore" checkbox.
Click "OK" button.
The MSQLMS window is displayed.
And click Ok.
After completing all processes ...
Again go to "Object Explorer" and press the "Refresh" button.
Go to the database option and expand the database.
"Project" is our database name

This Feature is Sponsored By

DynamicPDF Merger is a developers dream for interacting with any existing PDF documents. Merge, append, split, form fill, flatten stamp and so much more.

comments

COMMENT USING

PREMIUM SPONSORS

DynamicPDF Developer Components

DynamicPDF™ product line allows you to dynamically generate PDF documents, merge PDF documents and add new content to existing PDF documents from within your applications.

TRENDING UP

Simple Tooltip Using HTML and CSS Kolkata Chapter Developer Day Official Recap Object Oriented Programming Using C#: Part 9 JsAction with T4 Template Logging Using Log4net in Compact Framework 2.0 in Visual Studio 2008 Learn OOP Interface Using C# How To Find A Doctor Near Your Home in SQL Server S.O.L.I.D Principle Inversion of Control and Resolution With Dependency Injection Creating Simple MVVM Application With Data Binding Folder Structure of ASP.Net MVC Project

View All

MOST LIKED ARTICLE

WCF Introduction and Contracts - Day 1 Create SSRS Report Using Report Wizard CREATE READ UPDATE and DELETE - CRUD Operation Using LINQ to SQL WCF - Data Contract - Day 4 Factory Design Pattern

Follow @twitterapi

SPONSORED BY

DynamicPDF ReportWriter Suite

PDF reports have never been easier to create. With our included WYSIWYG Designer, you can layout your reports, set up your data source and let DynamicPDF ReportWriter do the rest.

WHITEPAPERS AND BOOKS

Interview Questions on SharePoint 2013 SharePoint 2010 Administration & Development Getting Started with Managed Metadata Service in SharePoint 2010 Windows Phone 7 Hileleri Windows Phone Development Step by Step Tutorial Essentials of SharePoint 2010: Business Intelligence Capabilities Working with Directories in C# FileInfo in C# Programming List with C# Source Code: Graphics Programming with GDI+

View All

Poll Result All Polls


Speed of C# Corner

How do you find speed of C# Corner when visiting the site?

Very Fast OK Slow Very Slow

Options	Votes	%
Very Fast	4	7.69
OK	42	80.77
Slow	4	7.69
Very Slow	2	3.85
Total	52	100%

In Focus

How to Restore a Database in SQL Server 2008

Related Articles