Ask - DB Snapshots with Mirroring

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Ask

Ask questions, discuss or help others by answering


	Ask a question


	Subscribe..

DB Snapshots with Mirroring

Feb 22 2010 12:00AM by dhandapani

When would I use Database Snapshots with Mirroring to create a reporting server?

When would I use Replication instead of Mirroring and Snapshots?

Submitted under: Microsoft SQL Server · DBA · Recovery · DATABASE DESIGN ·

Previous: clustering
Next: Mirroring instead of Clustering

dhandapani

598 · 0% · 59

2 Replies

A database snapshot gives you a copy of the data as of the time at which the snapshot is created. If you dont need the most recent data, you can do reporting from a snapshot

If your reports needs to have real-time data, you might need to use replication (if you dont want to query from the primary database)

commented on Feb 22 2010 8:00AM

Jacob Sebastian

1 · 100% · 32004

While mirroring mirroed database is nor accessible. but using snaphots you can access it.

But database snapshots are available only with Enterprise Edition of SQL Server

commented on Feb 23 2010 10:55PM

Dinesh Asanka

116 · 1% · 444

Your Reply

Sign Up or Login to post a comment.