SQL log shipping for reporting

Posted by Patrick J Collins on Server Fault See other posts from Server Fault or by Patrick J Collins
Published on 2009-11-09T10:40:44Z Indexed on 2010/03/22 12:01 UTC
Read the original article Hit count: 350

I would like to create a read-only copy of my SQL Server 2008 database on a secondary server for reporting and analysis. I've been testing log shipping, configured to run every 5 minutes or so. Alas, there appears to be a stumbling block, for exclusive access is required on the target database during the restore, which in turn requires killing all active connections. This is far from ideal, especially if a user is in the middle of running a report. Any better suggestions?

Edit : I'm doing this on the Express edition.

© Server Fault or respective owner

Related posts about log-shipping

Related posts about sql-server-2008