Database Mirroring of SQL server

Posted by jbp117 on Stack Overflow See other posts from Stack Overflow or by jbp117
Published on 2010-04-02T09:36:25Z Indexed on 2010/04/02 9:43 UTC
Read the original article Hit count: 602

I have two databases that are mirrored to another server using database mirroring. The mirror server has to be down for some reason for few days. Now the production server is having principal databases in (PRINCIPAL/DISCONNECTED) State. Clients can access those databases. So what happens when they keep on adding data to these databases?? Will the data get committed or waits till the mirror comes up?

© Stack Overflow or respective owner

Database Mirroring of SQL server

Posted by jbp117 on Server Fault See other posts from Server Fault or by jbp117
Published on 2010-04-02T10:42:59Z Indexed on 2010/04/02 10:53 UTC
Read the original article Hit count: 602

I have two databases that are mirrored to another server using database mirroring. The mirror server has to be down for some reason for few days. Now the production server is having principal databases in (PRINCIPAL/DISCONNECTED) State. Clients can access those databases. So what happens when they keep on adding data to these databases?? Will the data get committed or waits till the mirror comes up?

© Server Fault or respective owner

Related posts about sql-server

Related posts about sql-server-2005