Database mirroring option not available in sql server management studio 2008

3k views Asked by At

I want to do database mirroring in sql server management studio 2008. I went through many tutorials and in those tutorials there is a option for doing mirroring in ssms 2008. But in my ssms mirroring option is not present. Could somebody please tell me how to enable mirroring in ssms 2008. Thanks in advance!

1

There are 1 answers

5
M.Ali On

Have a look here a list of sql server editions and high availability features supported by each edition.

enter image description here

For more details Visit here here

Looking at this chart the next available option for you seems to be the Standard Edition, it means spending a few quid. but the good thing is you can use your free express edition as witness server if your planning to have an auto failover which requires you to have a witness server in place.