ARTICLE

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
1629
1

0

Reader Level: Beginner

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

Login to add your contents and source code to this article

Related Articles

post comment

Is the same procedure for 2005 and 2008

Posted by Krishna Garad on Mar 29, 2011

TOP LEADERS

TRENDING UP

Learn MVC (Model view controller) Step by Step in 7 days – Day 3 Learn C# Corner - Home Using Border Radius and Gradients in CSS3: Part I Learn C# Corner - Footer Learn .NET and C# in 60 Days Lab13(Day 5): - Classes and objects iPhone 5 First Look Samsung Galaxy Note Review WCF - Authentication and Authorization in Enterprise Architecting How to write a good article on C# Corner How to Display Data in ListBox From SQL Database in ASP.NET

Become a Sponsor

MOST LIKED ARTICLE

Learn .NET in 60 days – Part 1 (13 Labs) Working with ProgressBar in C# Resizable TextBox in ASP.NET using AjaxControlToolKit Word Processing with an Extended Rich Text Box Control Notepad in C#

PREMIUM SPONSORS

Dynamic PDF

ceTE software specializes in components for dynamic PDF generation and manipulation. The DynamicPDF™ product line allows you to dynamically generate PDF documents, merge PDF documents and new content to existing PDF documents from within your applications. Visit DynamicPDF here

ASP.NET 4 Hosting

Get 2 Months Free of ASP.NET Hosting for Only $4.95/month! Receive FREE MS SQL and MySQL Databases Including ASP.NET 4/3.5, MVC 3.0, Silverlight 4, Windows 2008/IIS 7.0 Plus FREE IIS 7 Modules. Host UNLIMITED ASP.NET Web Sites - Click Here!

LATEST JOBS

Applying for job Metro Style App Developer .NET Developer WPF or Silverlight exp Boston MA ASP .Net Developers Split Testing Designer .NET Developer Web Developer Application Engineer Expert .NET Developer Application Developer

View All Jobs |Post a New Job

Team Foundation Server Hosting

Become a Sponsor

WHITEPAPERS AND BOOKS

Essentials of Capacity Planning: Microsoft SharePoint Server 2010 Chapter 15: Customizing the Display Chapter 9: OpenType Font Support Successfirmations: Think, Reveal, Receive SharePoint Designer 2010 Essentials Building Standalone Data-Driven Applications using SQL Server Compact 4.0 Programming XML with C# Reporting with Reports Viewer in Visual Studio 2005 Programming C# for Beginners Programming Windows Common Dialogs with Visual C# 2010