Reporting Server - 2nd SQL Server

Hi,
I have a SQL server running in our production environment. I would like to
create a test/reporting environment running on a seperate server. I will
take my DB backups from the production server and then restore it onto my
2nd server. What is the best way to get the 2nd system updated? I do not
want a live replication all day long. I simply need a method to update the
2nd server once a day at a scheduled time.
Ideas?
Thank you.You can use the log shipping model. This means that you can restore the logs
from your production server on the reporting server.
Here are some details you can actually see how it could be implemented:
http://www.sql-server-performance.com/sql_server_log_shipping.asp
Let me know if it helps..
"Dragon" wrote:
> Hi,
> I have a SQL server running in our production environment. I would like to
> create a test/reporting environment running on a seperate server. I will
> take my DB backups from the production server and then restore it onto my
> 2nd server. What is the best way to get the 2nd system updated? I do not
> want a live replication all day long. I simply need a method to update the
> 2nd server once a day at a scheduled time.
> Ideas?
> Thank you.
>
>|||The log shipping model will leave your second server in a read only
state, rendering it useless for testing.|||The link I posted states pros and cons of this model. It all depends of what
type of testing.
"mryan" wrote:
> The log shipping model will leave your second server in a read only
> state, rendering it useless for testing.
>|||Thank you all for your replies.
Unfortunately I will need a totally indipendent system for my testing.
Having read only will not work as we will not be able to test applications
against it. Any other ideas? What about incremental backups and restores?
"Edgardo Valdez, MCSD, MCDBA"
<EdgardoValdezMCSDMCDBA@.discussions.microsoft.com> wrote in message
news:5B49860B-A765-49CE-9719-EE982B37ED00@.microsoft.com...
> The link I posted states pros and cons of this model. It all depends of
> what
> type of testing.
> "mryan" wrote:
>> The log shipping model will leave your second server in a read only
>> state, rendering it useless for testing.
>>