sql 2005 snapshot of mirror?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

togbabe - 31 May 2006 06:28 GMT

Can anybody tell me if it is possible to make a snapshot (not a log
shipping or replication snapshot. The new 2005 snapshot) of a mirrored
database even though the mirror ends up is held in a 'continually
restoring state?'

Reply to this Message

Hilary Cotter - 31 May 2006 10:24 GMT

It is possible to create a snapshot on your mirror.

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Can anybody tell me if it is possible to make a snapshot (not a log
> shipping or replication snapshot. The new 2005 snapshot) of a mirrored
> database even though the mirror ends up is held in a 'continually
> restoring state?'

Reply to this Message