N/APosted 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.
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.