Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
reems
Starting Member
2 Posts |
 Posted - 2009-02-19 : 08:18:46
|
| Hello,I'm using SQL server 2008 express (Advanced services) in the principal and the mirror servers.the servers are with same platform and operation system.What I'm trying to do is to configure both server to be High-Safety (synchronous) which back one each other.My problem is when I'm trying to do what explain in "Configure a Database Mirroring Session" (see link below).In step 3, I supposed to get "Mirror" option when I'm doing "right-click" on the DB that restored before, there is no "Mirror" option under Task option, I couldn't find any Mirror wizard.How can I get Mirror wizard ???By the way - I did all things to prepare the mirroring.Please - Help me, help me, help me.Configure a Database Mirroring Session - http://msdn.microsoft.com/en-us/library/ms188712.aspxThank you.Re'em |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-02-19 : 08:33:29
|
| Mirroring is only available in Standard and Enterprise editions. You can use express as a witness but not a primary or secondary server. The first bullet in your link you sent has this:The principal and mirror server instances must be running the same edition of SQL Server—either Standard or Enterprise. Also, we strongly recommend that they run on comparable systems that can handle identical workloads.Mike"oh, that monkey is going to pay" |
 |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-02-19 : 08:52:41
|
| You can use this functionality in the developer edition as well, but you can't use that instance in a production enviroment without upgrading the license to a standard or enterprise |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-19 : 09:40:40
|
| Database names and edition should be same in mirroring. |
|
|
|
|
|
|
Mirroring problems