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!
Database mirroring option not available in sql server management studio 2008
3k views Asked by Paul At
1
Have a look here a list of sql server editions and high availability features supported by each edition.
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.