August 4, 2010 at 10:23 pm
Hi all,
This is what i am looking for:
I have a database created on sql server 2008 enterprise edition which populates every morning by a big load.
This database is used a lot during the day and i need to create another snapshot database on another server that will be used for reporting purposes only.
Another requirement is that we should be able to snapshot this database to several different servers in the future.
What is the best approach/options out there?
What is the difference between database snapshot and replication snapshot and where one should be used over another?
Thanks
August 4, 2010 at 10:54 pm
Database snapshot always reside on the same server instance as the database.
Replication snapshot can be replicated to several different servers.
August 4, 2010 at 11:06 pm
As suggested, I feel Snapshot Replication meets your requirements.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply