Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Remote Database Expand / Collapse
Author
Message
Posted Monday, June 2, 2008 12:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 13, 2014 9:36 AM
Points: 9, Visits: 66
Hi all. Is it possible to backup a remote database onto a local machine using SSMS? I am trying to run a job on Server A to backup Server B's database to Server A, as opposed to running job directly on Server B, to see if there are any performance changes. Server B is running SQL Server 2005 Enterprise ed, and is the publisher and distributor.
Post #510186
Posted Monday, June 2, 2008 1:43 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 5, 2013 4:43 PM
Points: 1,473, Visits: 1,314
The answer is YES. Use network path in your backup command.
Post #510239
Posted Monday, June 2, 2008 1:51 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 13, 2014 9:36 AM
Points: 9, Visits: 66
Thanks. Could you show me where I would put the network path in this example?

BACKUP DATABASE [database2] TO DISK =
Post #510251
Posted Monday, June 2, 2008 1:56 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 5, 2013 4:43 PM
Points: 1,473, Visits: 1,314
BACKUP DATABASE [database2] TO DISK = '\\myServer\C$\myDB.bak'
Post #510255
Posted Monday, June 2, 2008 2:02 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 13, 2014 9:36 AM
Points: 9, Visits: 66
I don't think that would help me. That appears to backup the local database to a remote server. I am looking for a way to specify that the database I am trying to copy is on a different server, while backing up on the local server, through a job running on the local server.
Post #510261
Posted Tuesday, June 3, 2008 2:19 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 4, 2009 7:34 AM
Points: 129, Visits: 130
dbhelp (6/2/2008)
I don't think that would help me. That appears to backup the local database to a remote server. I am looking for a way to specify that the database I am trying to copy is on a different server, while backing up on the local server, through a job running on the local server.

Thanks SQL ORACLE, You mentioned correct. You have to give the Correct network path. I have SSDS environment and I use the same to take a backup of the DB in other server AS SQL ORACLE mentioned above.

First have mo make sure that file system have proper permission on it.

\\abcdefg\$E\MSSQL\MSSQL1\Backup


Manoj

MCP, MCTS (GDBA/EDA)
Post #510959
Posted Thursday, February 13, 2014 9:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 3, 2014 2:11 AM
Points: 5, Visits: 11
Yes you can do this. Use this tool: BAK to local it will directly put a BAK file to your local machine.
Post #1541299
Posted Monday, March 3, 2014 9:44 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 4:23 PM
Points: 1,194, Visits: 2,209
SQL ORACLE (6/2/2008)
BACKUP DATABASE [database2] TO DISK = '\\myServer\C$\myDB.bak'


Follow this advice from SQL ORACLE. It works

--
SQLBuddy
Post #1547001
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse