0
votes
1answer
61 views

Restore backup from SQL 2008 to 2008R2 with standby

We are looking to replicate our production database to another instance so that when reports are run, it doesn't slow down the application to the point of being barely usable. I had limited success ...
2
votes
1answer
499 views

How to Configure SQL Server 2008 R2 Log Shipping

I need to set up a standby server using SQL Server Log Shipping. This is my first time doing this, so I'm following the instructions in the SQL Help step by step. Of course, I ran into a problem at ...
2
votes
1answer
410 views

Can I log ship from SQL Server 2008 R2 to Sql Server 2008 “R1”?

I have two sql server instances, on is SQL Server 2008 R2, one is the first release of SQL Server 2008 ("R1"), is it possible to log ship from the R2 machine to the R1 machine? If is not possible, is ...
3
votes
4answers
1k views

Log Shipping to an Existing Database

We have a few huge databases we would like to log ship on SQL Server 2008. Unfortunately the link between primary and secondary servers is fast enough to handle log shipping but the initial ...