Run ALL SQL Server instances with the same domain account.
Run ALL SQL services with the same domain account.
Ensure that TCP/IP was enabled as a protocol on ALL SQL Server.
Start the SQL Browser Service on ALL SQL Servers.
Ensure that Database on Principle Server is in full recovery model.
On Principal Server Perform a Full backup Transaction Log.
Use the backup file to restore database on Mirror Server with NORECOVERY Option.
Configure Security as below:
1- Right-click the database, select “Tasks->Mirror…”
2- Click “Configure Security”
3- Click Next
4- Select "Yes" if you need a witness server to configure automatic failover and “No” and Click Next. if this case we will select "No"
5- Click Next
6- Set up the Principal first.
7- Connect to the Mirror Server by the domain account.
8- Type the Service Account that run SQL Instance
9- Click Finish
10- Must see status “Success”
11- Click “Start Mirroring”
No comments:
Post a Comment