SQL 2005 db mirroring -- sql server replication

MGeles
6/26/2006 10:01:01 AM

I know that I should just try this, but I thought I'd ask anyway.
I set up db mirroring between 2, 2k5 servers. The mirror dbs are in a
(Mirror, Syncronized, Restoring...) state. If I had restored the dbs on the
Mirror server using STANDBY, would the database be accessable in read-only
mode for purposes of verifying that the data is there/good? If not, is there
a way to verify the data on the mirror without breaking the mirror?

Thanks
--

Hilary Cotter
6/26/2006 3:21:52 PM

I would create a database snapshot on the mirror. You can check it this way.

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

[quoted text, click to view]

sql server replication : SQL 2005 db mirroring