Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dsharma
Starting Member
4 Posts |
 Posted - 2010-12-16 : 05:47:09
|
Hi All,I have SQL Server 2005 install on "A" system and I want to store the backup on some drive of "B" system. To make this possible I tried to make a network drive but the location for the backup I am not able to see in the backup window where we have to give the location for the backup file.Can anyone help me out for how to take backup on the Remote machine.Thanks Deepak SharmaD.B.A |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-12-16 : 10:02:10
|
| The easiest way to backup to a remote location is to:a) make a backup locallyb) COPY (or MOVE) the file to the remote location - e.g. using RoboCopyRoboCopy is robust and tolerant of network outage etc, and running as part of a scheduled task you are more likely (in the first instance) to be able to sort out permission / login issues etc.Also, if the network fails you still have the backup on the local machine, to fall back on.Whereas if you backup direct to remote location and there are network issues then you have NO backup |
 |
|
|
|
|
|
Facing Problem while backup in SQL Server 2005