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

tomvinothkumar · 07-29-2009, 02:29 AM

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

garyk1968 · 07-29-2009, 04:58 AM

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.

07-29-2009, 02:29 AM	#1
tomvinothkumar Warrior Member Join Date: Jul 2009 Posts: 3 Thanks: 0 Thanked 0 Times in 0 Posts	MSSQL SERVER 2005 - Take backup from Remote Server To Local Server 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

07-29-2009, 04:58 AM	#2
garyk1968 HyperActive Warrior War Room Member Join Date: May 2009 Posts: 319 Thanks: 36 Thanked 23 Times in 20 Posts	Re: MSSQL SERVER 2005 - Take backup from Remote Server To Local Server 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.
	Marketing Strategies app now in the app store