Creating Backup of Database MS SQL

Asked By sam hudson 1200 points N/A Posted on - 05/28/2011

Hi to all,

I am an IT student. I just started using MS SQL Server. I am using 2005 edition of MS SQL. As I said I am new, so I am not familiar with all the tools. I created a database in the computer and I need to create the same database in another computer. So I need to take a back up of the existing database. I tried but I failed to create a back up.

I need some help.

• Status: Open
• Question Views: 1458
• Answer Count: 1
• Vote Up 13 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by jakie

Go To Solution

Best Answer

Best Answer

Answered By jakie 450 points N/A #101801

Creating Backup of Database MS SQL

Hello dear Sam, Welcome to the database management world. Creating backup of databases is one of the most necessary things. It is easy to create a backup of an existing database with MS SQL 2005.

As you have an existing database, open the SQL server and connect it. Now, in the object explorer, go to your database. Right click on your database. There will be a list. Find Backup option, as shown in the figure. Now there is a new window open. In the down side of the window you can see the created file path. It is default to go to your installed MS SQL folder in your hard disk. You can create this backup anywhere as you want. For this, first remove the existing path. Then click add. Now another window opens, by this window you can browse your computer. Now select the folder or drive where you want to create the backup and click OK. Now you return to the first window. Now see the path is shown as you want. Now just click OK.

It takes several seconds to create the backup.

Hope you can fix it.

About jakie

Questions
2

Answers
11

Best Answers
8

• Vote Up 0 Vote Down

• Posted on - 05/28/2011
• Question Category: MS SQL Server