MSSQL SERVER 2005 - Take backup from Remote Server To Local Server

1 replies
We need to take backup from Remote Server To Local Server. We are using MS SQL SERVER 2005 - SQL SERVER Management Studio.

Remote Database, We Connected through SQL SERVER Management Studio .
If we go for Backup option its showing remote path only.

Remote server database should save into local machine. (.bak)

Please any one suggest me !

------------------------------------------------------------------------------------------------------------------

247 Web Directory
#2005 #backup #local #mssql #remote #server
  • Profile picture of the author garyk1968
    Yes of course because it can only see the local file system. You need to setup a share on the remote system that your local machine can see. Or if the file isnt that big and the remote machine has net access then email it to yourself.
    {{ DiscussionBoard.errors[1028267].message }}

Trending Topics