[prasad.weer]

There are 2 servers. (I named those 2 servers in this post as "server1" and "server2". Those 2 servers are link together via VPN) i want to backup server1 data to server2. This should be done automatically in every day in some fix time. I know how to back up server1 data to some location of server1. But Still i couldn't find a way to do this with 2 servers. PLEASE TELL ME HOW TO DO THIS.
Server version: SQL server 2008

[modi123_1]

Like this?

http://msdn.microsof...y/ms190923.aspx

[prasad.weer]

Modi, nothing in this link.....
("This Topic Is No Longer Available")

[modi123_1]

https://webcache.goo...n&ct=clnk&gl=us

[prasad.weer]

Actually modi the problem is I want to back up on schedule by using SQL management studio. Is there any method for doing it.....?

[modi123_1]

You would either schedule something in the command line with the 'schedule tasks' in the OS's control panel or fiddle with the jobs.

http://msdn.microsof...y/ms191439.aspx

[BBeck]

What you probably want to do is backup to a local hard-drive, then copy the backup file to the other computer. It's a really bad idea to backup across the network, because you can actually lock up the database that way if lag gets serious enough. Generally, you want to backup to a local file, which is quick and easy. Then do a straight forward file copy to the other location.

I assume you are not trying to automatically restore to the second server. If that's the case, you should be looking at either log shipping, replication, or database mirroring. Snapshot replication is pretty much the easiest to implement.