Mirror Mirror on ...
Database mirroring in SQL Server 2005. Great stuff, easy to setup, easy to maintain... .
For all that are intrested in setting up failover in SQL Server have a look here or here.
Or better yet download the Beta 2 and search the BOL.
One minor problem I came accross:
After shutting down the Principal SQL Server instance "YUKON" (to simulate an automatic failover), I was no longer able to bring up the database properties
of the new Principal database (previously mirror copy - SQL Server instance "MIRROR").
Just kept getting the error message:
After checking out the SYS.SYSFILES system view, it revield to me that the log and datafile were located on instance "YUKON", where I would have expected the "MIRROR"
instance...
One workaround I found (by accident) was setting up a new Mirror Database. After which I could access the properties again.
Checking the SYS.SYSFILES system view again, the location had "changed" to the "MIRROR" instance.
Simulating another failover though brings the error back.
Maybe the cause is setting up all three instances (Principal, Mirror, Witness) on the same machine (which is not the general idea, but just for testing...).
I'll revive my desktop pc and give it a try on two machines (wireless :-)))
3:08:03 PM 
|
