• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 265
  • Last Modified:

Restoring SQL 2005 database

Hello, I would like to know what I have to do to have the following procedure work correctly.
I have two different sql 2005 servers, I would like to copy the backup from the nightly backup on one server and restore it into a database on another sql 2005 server. I created a job schedule under sql server agent with the necessary syntax scripts. Do I need to do or assign any account or user  on any of these servers. If  I have to do additional things can you please tell me how, where or what to do.
Thanks
0
vera2006
Asked:
vera2006
2 Solutions
 
Imran Javed ZiaCommented:
Hi,
This is technically called replication please follow the following links for step by step details:

http://www.codeproject.com/KB/database/sql2005-replication.aspx
http://blog.csdn.net/longrujun/archive/2006/06/09/783357.aspx

Thanks
0
 
Alpesh PatelAssistant ConsultantCommented:
Please make sure. Where you have created SQL job? give folder permission to where creating file, permission to create backup and restore to another server to the user of the Hosted SQL Server SQL agent user.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now