<div>
<div class="content wysiwyg-content">
Hello, I would like to know what I have to do to have the following procedure work correctly.<br />
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 &nbsp;on any of these servers. If &nbsp;I have to do additional things can you please tell me how, where or what to do.<br />
Thanks
</div>
</div>


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

Restoring SQL 2005 database

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.