sql server 2005 standard mirror problem
Database for sql server 2005 standard mirror in my company .One day mirror server database was principal ,but quondam principal database server was not do mirror ,so then the database server is two principal ,this is very strange is two principal server databases. And i find witness server log, discovery witness server error think quondam principal server was failure, so then mirror server database was principal, in fact principal server was not failure.
But, productive data was writed in quondam principal server, was not writed quondam mirror server.
For one principal and mirror database servers, so i would quondam mirror database server was restart, and then quodam mirror was not become mirror database,
was principal database. Then, i restart quondam principal server, the server was mirror, and let two server in-phase data, later i find losed data, was quondam mirror data. Is not quondam principal server data.
Please me! Get back lose data. I did not backup sql server log file.
THKS!!!
|