Login or Register

  Welcome: Guest


Home >> Article >> Programming >> DataBase >> Post New Article Bookmark and Share

Back up And Restore Database

June 14, 2010  by: karthivignesh  Points: 15   Category: DataBase  Earning $0.20   Views: 825

Step by Step Sql Data Backup And Restore Database

         

Backup Data Base:
--------------------

Step1: All programs -->Microsoft SQL Server2005-->SQL Server Mgmt studio Exp.

Step2: connect to server window to click connect.

Step3: Click Data Base folder --> Then Right click Database Name folder--> task-->Back Up

Step4: open Backup window

click remove-->Click Add-->type data base name and chose the folder-->ok-->



Restore the Data Base:
-------------------------

Step1: All programs -->Microsoft SQL Server2005-->SQL Server Mgmt studio Exp.

Step2: connect to server window to click connect.

Step3: Then Right click Database Name folder--> Create New Database--> give Restore database name --> ok.

Step4: Right Click the New Database folder-->Task--> Restore--> click Database.
.
Step4: Restore Database Window open now.

Step5: In general-->Select From Device Radio Button--> Click Browse-->Add--> In file of type--> select All files in combo box--> Select location path from Restore Database backup file-->then ok

Step6: In restore Database window--> Click Option -->Select Checkbox--> overwrite the Existing Database




Comment(s)

No response found. Be the first to respond to this post

Post Comment

Please Log In  to post comment

Related Resources



Restore desktop Icon, Show Desktop
This tips will tell you to restore the desktop from menu. This is tested in XP machine.

Restore Show desktop Icon on the task bar
This tips will show how Restore Show desktop Icon on the task bar. This one tested on XP operating system.

create database source name (DSN)
database source name craetion Steps

Database Synchronization
Database Synchronization prossesses and Database Comparison

Some ways to get your Ex back.
This is my article will help you to know some ways to get your Ex back.

Latest Resources From The Same Category



Tips & Tricks For Developers.
Here are some useful tips and tricks that can make developers life easier.

Database Synchronization
Database Synchronization prossesses and Database Comparison

Back up And Restore Database
Step by Step Sql Data Backup And Restore Database

create database source name (DSN)
database source name craetion Steps

 

Top Performers     Top Contributors     Share and Earn     Terms of Service    Privacy Policy     Contact Us