I want to Synchronize two Database in two server in sql server 2008. Database Mirroring is not working for me... I've created Master key, Certificate, endpoints... Everything is perfect.. But, even though, the Mirroring is not working.. Is there any other way to attain synchronization... Plz, Anybody Could help me???
A:
What are you trying to achieve here? Are you looking for a hot standby for disaster recovery purposes or are you looking for a second server for reporting?
Database mirroring is for high-availability. The mirror database is not accessible and cannot be queried.
GilaMonster
2009-09-25 14:48:33
When I add Database Mirroring after setting all prerequisites, error occured...
Nila
2009-10-06 06:13:08
While Restoring the database with norecovery, I cannot access that database... It is in the middle of the restoring
Nila
2009-10-06 06:13:41
Yes, that's how it's supposed to be. By specifying norecovery you're telling SQL to restore the database but leave it in a restoring state so that more backups can be applied.Again I'm going to ask you, what are you trying to achieve here?
GilaMonster
2009-10-06 14:14:05