Click here to Skip to main content
15,921,905 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have 2 server

Ex. 192.168.0.11 and 192.168.0.12

now I want take DB backup from 11 to on 12 server in sharing folder direct via sql server

Please if any one know this then help me.

Thanks
Posted
Updated 16-Feb-15 19:10pm
v2

 
Share this answer
 
v2
Comments
Maciej Los 25-Feb-15 14:57pm    
+5
Personally I wouldn't take the backup directly to a network drive. Instead I'd do it in two phases:

  • Take the backup to a local directory
  • Copy the backup to remote directory

The reason for this is that this way the backup is always taken properly regardless of possible network problems and the duration of the backup isn't affected by the network speed.

Of course it's vital to copy the backup to the remote server or some other safe place so I'd include the copy operation to the job that creates the backup. This way it would be easy to set up the error notifications etc.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900