unable to find Mirroring option in sql server 2008 R2 (SP1)

Question

I have recently install 3 instances of SQL SERVER 2008 R2 and try to setup Mirroring but there is no mirroring option available on database property. I have then install SP1 as well. still no luck. 

have some idea?

I have Windows 7 , SQL SERVER 2008 R2, SP1 Build 7600

This is the Version Information

Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)   Jun 17 2011 00:54:03   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) 

---

Shamas Saeed (if Post helpful please mark as Answer) http://shamas-saeed.blogspot.com

Answer 1

Here is a link to setup Database Mirroring using SQLCMD Scripts:

http://sudeeptaganguly.wordpress.com/2012/03/06/database-mirroring-with-sqlcmd/

If you installed all the instances on a single machine, then you need to change the Database Mirroring endpoint ports; however if you installed it on separate machines, then the above script will configure the database Mirroring for you.

If you want to use Database Mirroring with Automatic Failover, check the following post:

http://sudeeptaganguly.wordpress.com/2010/07/25/how-to-configure-database-mirroring-in-an-active-directory-environment-using-sql-server-2008/

Let me know, if this helps :)

---

SKG: Please Marked as Answered, if it resolves your issue.

Answer 2

Database mirroring is supported in SQL Server Standard Edition and Enterprise Edition... Can  you post a print screen?

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 3

thanks i am able to see Mirror link in database task but there is no mirror option in database properties. see attached image.

i have another server with same sql server but its version is 1627 and it shows mirror option in database properties. is there any difference.

---

Shamas Saeed (if Post helpful please mark as Answer) http://shamas-saeed.blogspot.com

Answer 4

Yes i have all 3 instances on same server. thanks for endpoint information. Let me install mirror setup and i will post my answer. 

thanks

---

Shamas Saeed (if Post helpful please mark as Answer) http://shamas-saeed.blogspot.com

Answer 5

Shamas,

Did you check the recovery model of the database? Only Full recovery model is supported.

And Check the screenshot from Uri's reply, you can find it within Task option.

---

SKG: Please Marked as Answered, if it resolves your issue.

Answer 6

Yes i have tried but Task option returns same screen i have attached above. 

Option is Full and AutoShrink is true

---

Shamas Saeed (if Post helpful please mark as Answer) http://shamas-saeed.blogspot.com

Answer 7

Is that possible you are seeing an EXPRESS Edition??

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 8

select @@Version

Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)   Jun 17 2011 00:54:03   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) 

is this helpfull

---

Shamas Saeed (if Post helpful please mark as Answer) http://shamas-saeed.blogspot.com

Answer 9

On another machine i am able to see both options and its version is

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64)   Apr 22 2011 19:23:43   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor) 

Is this helpfull

---

Shamas Saeed (if Post helpful please mark as Answer) http://shamas-saeed.blogspot.com

Answer 10

You have a mismatch in SQL Server Patch version, the above screenshot says Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) and the first one says Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)

One more thing, are you trying the same database? The size of the database on both the screen are different too.

Could you please mention, the steps you have followed till now?

---

SKG: Please Marked as Answered, if it resolves your issue.

Answer 11

I am trying to setup mirror on a machine which shows version 

Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)

and there is another machine which have already have mirror setup and that shows 

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64)

that is why i have uploaded both screen shots. I am also confused why i am not able to setup on first machine.

---

Shamas Saeed (if Post helpful please mark as Answer) http://shamas-saeed.blogspot.com

Answer 12

Last thought, do you connect to that database with the same login/user as you do to the database where you do see Mirroring? Is that possible permissions? Moreover , did you install e "Management Tools - Complete" component  I think it should fix the problem?

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 13

Thanks bro... 

I got the problem just before you post and problem is same. I did following steps for installation on the machine

- visual Studio 2010 with SQL SERVER Express and it installs Management Studio

- Install all 3 instances of SQL SERVER but did not check Management Tools -  Complete

Now i have tried to connect this server to another machine's Management Studio and i am able to view Mirror option.

thanks for your information and help..

---

Shamas Saeed (if Post helpful please mark as Answer) http://shamas-saeed.blogspot.com

Answer 14

All right, here is what you should do:

Consider your First Machine as Machine A : Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)

Second Machine as Machine B:                    Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64)

First thing, you should do is, install SQL Server 2008 R2 SP1 on Machine B. Then create a database in Full Recovery Model, on any of the server, take a full backup and folloowed by a log backup. Restore it on the other machine, with option NORECOVERY. After that follow the steps mentioned in the above blog post.

You may also try to configure it using SQLCMD. I have attached a link to that in my first reply, do change the server name, dbname, service accounts, endpoint name, and port number as per your requirement.

Let me know, if you able to configure it, Hope, this may help :)

---

SKG: Please Marked as Answered, if it resolves your issue.

Answer 15

thanks for your help but i have printed Machine B just for an thought that i am able to setup mirror on this machine. But issue is about SSMS and its new for me...

---

Shamas Saeed (if Post helpful please mark as Answer) http://shamas-saeed.blogspot.com