How to import/export data from sql server hosted remotely using query only!

Posted by Coolbharat under Sql Server on 3/13/2014 | Points: 10 | Views : 1291 | Status : [Member] | Replies : 1
We managed to create BackUp of a database hosted remotely or in shared hosting environment by using Export/Import Wizard in SSMS by right clicking database in SSMS.Then we can have the version of database in our local sql server which can be taken BackUp of.But we want to do ot using query only without using wizard so that the instance of the database can be created in our local server and we can proceed usually to create .BAK file of the database.How can we do it?

Thanks in advance


Posted by: Bandi on: 3/14/2014 [Member] [MVP] Platinum | Points: 25

Means you want to take back up remote server database and then restore that backed up data to your local database?

Mark This Response as Answer

Coolbharat, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response