I tried to perform SQL Server database Mirroring(with SQL Server 2008R2). And I got success to perform mirroring with "High Safety" mode.
And for that I have used three instances of SQL Server database.One for Principal second for Mirror and third for Witness.
As I mentioned I used three instances but all of those instances was on the same SQL Server.
But when I tried to perform mirroring with different SQL Server instances then it was not successful.
So I want to know can we perform mirroring with different SQL Server instances? Or we can only do it with instances on same server?
Also in mirroring how many instance we can configure as a Mirroring server ?
And is it a right way to achieve database availability? Or is there any other/advance way to achieve database availability and security?