In the database mirroring, if the database has been configured with the witness server, there are certain advantages and certain disadvantages.
The advantages includes when the principal server fails, the mirror automatically takes over, please as soon as the sql service in the principal server fails.
The disadvantage if you want to restart the principal server even at that point the mirror server takes over, then to bring this back again, we need to login to the mirror server and click on the failover.
To remove the witness server from database mirroring after it has been configured with witness server adopt the following steps.
Please note before doing this, this needs to planned off the working times, also there should be complete backups and log backups done before this.
1. Stop the mirroring on the principal server.
2. Take a log back up.
3. Then configure again only with principal and mirror server.
the analysis of selected documents can be performed by various data recovery solutions. You may try the illustrator recovery utility for example, it is one of the most efficient tools
ReplyDelete