Hi,
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