Database Mirroring

Question

Hello there,

In my SQL server web edition

"Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64)   Aug 19 2014 12:21:34   Copyright (c) Microsoft Corporation  Web Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: )"

I couldn't find database mirroring option by right clicking on database!

Answer 1

Hello Amita,

See Features Supported by the Editions of SQL Server 2008 R2; Mirroring as source or target is not supported in Web Edition, it can only act as Witness

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

witness only? what does it mean/

Answer 3

witness only? what does it mean/

That means witness is the server which just enables the mirror server for automatic failover when primary server is down due to some issue.

Its explained here

https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-sql-server

Look at High Safety mode for witness usage

---

Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page