Last post Nov 02, 2009 06:04 PM by rtpHarry
Oct 31, 2009 09:54 AM|rtpHarry|LINK
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:
Nov 02, 2009 05:50 AM|vishwaraj1|LINK
I there any way by which I can take bakup of online database to my local system.
Nov 02, 2009 06:36 AM|rtpHarry|LINK
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.
Then you can copy/paste this into a local .sql file and you have your backup
Nov 02, 2009 07:29 AM|vishwaraj1|LINK
no i actually i want the record also.. so is there any way to do it, except copy and paste the records..
Nov 02, 2009 08:14 AM|rtpHarry|LINK
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.
Nov 02, 2009 12:57 PM|vishwaraj1|LINK
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.??
Nov 02, 2009 06:04 PM|rtpHarry|LINK
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: