Checklist to configure SQL Server Database Mirroring.
- Enable SQL TCP and UDP(for Named instances) in firewall.
- Start MSSQLSERVER Services with Domain user credentials (instead of Local System Account) on principal database Server and Mirror Database Server.
- Enable DB mirror Ports in Firewall (Principal, Mirror and Witness).
- principal DB should be FULL Recover model.
- Take latest full backup and Logbackup.
- Restore full and Log backup with no recovery option.
- The end point should have the status started.
This comment has been removed by the author.
ReplyDelete