June 2, 2008 at 12:56 pm
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.
June 2, 2008 at 1:43 pm
The answer is YES. Use network path in your backup command.
June 2, 2008 at 1:51 pm
Thanks. Could you show me where I would put the network path in this example?
BACKUP DATABASE [database2] TO DISK =
June 2, 2008 at 1:56 pm
BACKUP DATABASE [database2] TO DISK = '\\myServer\C$\myDB.bak'
June 2, 2008 at 2:02 pm
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.
June 3, 2008 at 2:19 pm
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
MCP, MCTS (GDBA/EDA)
February 13, 2014 at 9:35 am
Yes you can do this. Use this tool: BAK to local it will directly put a BAK file to your local machine.
March 3, 2014 at 9:44 am
SQL ORACLE (6/2/2008)
BACKUP DATABASE [database2] TO DISK = '\\myServer\C$\myDB.bak'
Follow this advice from SQL ORACLE. It works
--
SQLBuddy
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply