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: 284
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