Read a step by step guide which will show you how to restore a .bak file in Microsoft SQL Server Management Studio. This technique can be used to move databases between servers or restore an existing database to a previous state:

• http://runtingsproper.blogspot.com/2009/10/learn-exactly-how-you-can-restore-bak.html
  

Hi harry,

I there any way by which I can take bakup of online database to my local system.

Hey, not by using the backup sql commands as far as I know.

You can script it to a file though if you have Sql Server Management Studio 2008.

1. Right click on database
2. Click Tasks
3. Click Generate Scripts
4. Click Next
5. Select a database
6. Tick "Script all objects in the selected database"
7. Click next
8. Scroll down in the options list to the "Table/View Options" section
9. Find "Script Data" and set it to true
10. Keep clicking "Select All" in each of the following windows.
11. In the Output Option window choose script to a new window

Then you can copy/paste this into a local .sql file and you have your backup

no i actually i want the  record also.. so is there any way to do it, except copy  and paste the records..

The records are referred to as Data by sql server management studio.

All records will be scripted out to file when you follow step 9 in the tutorial above.

This option is newly available in sql server management studio 2008 so if you have an older version this wont work.

if I have old version of sql 2008 or I have sql 2005.
 how can I take the backuP from the server.
 Is there no way.??

If you can install the latest sql server express and the tooling on your dev computer then you can use the free sql server 2008 management studio to manage older servers.

Get it at:

• http://runtingsproper.blogspot.com/2009/07/where-can-i-get-microsoft-sql-server.html