| Author |
Topic |
|
thotrang
Starting Member
13 Posts |
 Posted - 2006-10-12 : 06:12:34
|
| I have two server. The first is in a remote server which hosts my site and the second server is in my office.I want to back up data : - One is stored in the same server (for disaster recovery purposes) - One stored in the server in my office (happen immediately, coz I want to use for other task )My questions are: - when I do that how it efects on peformance of system ? (data in one day it's quite big ) - How can I set up this job automaticaly? (Please show me step by step because 'm not DBA)Anyone could help me?Thanks a lot. |
|
|
dewacorp.alliances
452 Posts |
Posted - 2006-10-12 : 20:20:59
|
| Correct if I am understanding your requirement is. Both server are backing up locally and other backup is backing up from One server to another. Correct?Depending on the size of database, while you do a full backup .. yes it will affecting the perfomance on the system. To setup job automatically, there are two approach you can use Maintenance Plan (that's will be the easy way) or using a script. Search on Book Online regarding Maintenance Plan regarding this. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-12 : 22:24:23
|
| first verify if you can even do backup at the remote server, have access to the backup directory, atleast read and write, and can transfer files across to your destinations--------------------keeping it simple... |
|
|
|
thotrang
Starting Member
13 Posts |
Posted - 2006-10-12 : 22:47:54
|
| What I mean is once backup locally and the other back up from one server to the another. The most important thing I want to know is how it will affecting the perfomance on the system. Can you analyse for me the advatage and disadvantage when I do that? To jen: yes I have full right on both server.Thanks a lot. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-12 : 22:58:16
|
| so the backup's done and the task remaining is doing the file transfer?the concern here is how large the file is, transfer rate, bandwidth, network traffic etc, not particularly on the server itselffor automated task, you can create a job in the windows task scheduler to simplify it or buy a third party tool to transfer the file out securely...openSSH is free, they have for windows tooHTH--------------------keeping it simple... |
|
|
|
thotrang
Starting Member
13 Posts |
Posted - 2006-10-13 : 00:03:46
|
| Sorry I use wrong word. What I want is creat a mirror process between 2 server. One is in locall for recovery purpose, one is in another server for another task. (not transfer file )Can I do it ?can you advise something ? |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-13 : 00:12:46
|
what is the extent of the mirror? system files? registry keys? or just content?there are a lot of third party tools available to handle the load, repliweb, opendeploy, etcalso, I think you need to reasses your requirement in order to come up with a good solution  --------------------keeping it simple... |
|
|
|
thotrang
Starting Member
13 Posts |
Posted - 2006-10-15 : 22:32:07
|
| what I want just content . can u advise for me one tool you thing is better? |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-15 : 23:01:47
|
| I can't recommend. You asked the wrong person with regards to third party tools...But you can start with opendeploy and repliweb (I heard they're ok, though not cheap)HTH--------------------keeping it simple... |
|
|
|
|
Backup Job, Replication