SQL Server Performance Forum – Threads Archive

backup and remote restore

Hi,
I am looking for a solution to my problem. I have two servers, a production server and a drp server. Every day I must create a backup for bd1 on the prod server and to restore the bd1 on the drp server.
For a good synchronisation I want to create only one job, with 2 steps, on the prod server. Is it possible and how can I do? Anybody can help me? Thanks in advance.

Joanne, see if my answer on www.sqlteam.com helps. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] MeanOldDBA [email protected] When life gives you a lemon, fire the DBA.

Why not take help of log shipping in this case, it works as warm standby server in case of any disaster issues. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Hi, I forgot to tell you that I use sql server 2000, standard edition.
derrickleggett, which article I must read? Thanks again to all.

Articles on implementing Log shipping using SE:
http://www.windowsitpro.com/Article/ArticleID/23231/23231.html
http://www.windowsitpro.com/SQLServer/Article/ArticleID/23230/23230.html http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx – using BORK. Also review articles on this website Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

thanks very, very much, satya

]]>