July 14, 2010 at 4:30 pm
Hello,
I'm evaluating database mirror in SQL 2008. I'm new, and have configured database mirroring on two (2) physical servers:
o/s: server 2008
sql: ms-sql server 2008
instance: default instance
I executed a simple update script (t-sql) on the principle.
How may I query the mirror?
Thanks,
bob
July 14, 2010 at 4:36 pm
you cannot directly. If you have enterprise edition you could create a database sbapshot of it.
If you update the principal, it WILL get copied to the mirror.
---------------------------------------------------------------------
July 14, 2010 at 4:46 pm
So is the only way that I can see that the mirror has indeed been synched correctly is to perform the failover test (which I haven't yet read in detail about)?
My test db is small .. can I back it up and restore it somewhere so I can query the tables?
thanks much,
bob
July 15, 2010 at 3:07 am
you cannot backup a mirror database.
if this is a test database I would:
make the changes on the primary
set mirroring to synchronous mode (if not already)
failover. (alter database dbname set partner failover). this swaps the roles of the databases
check your changes are there
swap the roles back, alter database dbname set partner failover again
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply