February 13, 2008 at 11:36 am
I'm in the process of migrating from SQL SERVER 2000 to SQLSERVER 2005. We are currently using replication and the replication database is used for: 1) failover, 2) reporting to keep the contention off of the source database. I will also add that we will be using failover clustering(active/passive nodes) in place of mirroring/log shipping in our new SQL SERVER 2005 Environment. I want to continue to keep the contention down on the source database. Is Snapshot Database's the way to go. From what I have read, I would think the answer would be no because if no data pages have been changed, the Snapshot Database uses the data pages
from the MDF File. I'm not really clear on this.
February 13, 2008 at 12:56 pm
I've been using snapshots in order to provide a static read-only copy of the database for reporting (SSRS/SSAS) w/ great success. Take a look here -
http://www.sqlservercentral.com/Forums/Topic452904-146-1.aspx
Tommy
Follow @sqlscribeViewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply