i am trying to setup mirroring on a GP database, till now i did it successfully on the database level and i can perform failover among the two databases, the problem is GP is working on the principal database and i can log in when the principal database is working, but when i make it the mirror database and make the other as the principal, then i try to log in to GP i revieve the following error :
a get/change first operation on table 'coProcess' (45)
More Info :
[Microsoft][SQL Server Native Client 10.0][SQL Server]The database "CILT" cannot be opened. It is acting as a mirror database.
[Microsoft][SQL Server Native Client 10.0][SQL Server]The database "CILT" cannot be opened. It is acting as a mirror database.
[Microsoft][SQL Server Native Client 10.0][SQL Server]The database "CILT" cannot be opened. It is acting as a mirror database.
please advise
*This post is locked for comments
I have the same question (0)