This is not my expertise, so would appreciate some help.
Is it possible to create an active/passive failover setup or database
mirroring without a shared disk? Client has two sql servers that they
wanted to upgrade SQL 2000 to SQL 2005 and then use the second box for an
active/passive configuration. They do not have a shared disk which I am
being told is necessary for this.
Unfortunately, I do not have the expertise on this and am reaching out to
the gurus here.
Also if any of the SQL experts in this group want some consulting work in
NYC for this job, please contact me off the list.
Lawrence Abrams
MVP - Windows Security
http://www.bleepingcomputer.com
Thank you very much for the info. Starting to make a bit more sense? I
assume for the mirror and the witness they would need to be fully licensed?
Also does the witness need to be as powerful as the actual DB servers?
If you know of any SQL MVPs in the NY area, please have them contact me if
they are interested in possibly doing consulting for this setup.
-L
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:efiHUMteHHA.5052@.TK2MSFTNGP06.phx.gbl...
> With no shared storage you rule out clustering but Database Mirroring will
> be fine.A couple of whitepapers to help get your head around DB mirroring
> http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
> http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx
> http://www.microsoft.com/technet/prodtechnol/sql/2005/mirroringevents.mspx
>
|||The witness needs a license, but the mirror does not require a SQL license,
provided it is used for failover only. The witness can be a workstation
grade system since all it is doing is observing.
NOTE: Always verify licensing for your configuration with your Microsoft
rep.
While I am not based on the NY area, the company I work for does have a NY
office and would be happy to quote on this project. Email me directly and I
will put you in touch with one of our Business Directors. My posting
address is a valid email address.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Lawrence Abrams" <grinler-REMOVETHIS@.bleepingcomputer.com> wrote in message
news:%23l0LVXteHHA.4604@.TK2MSFTNGP06.phx.gbl...
> Thank you very much for the info. Starting to make a bit more sense? I
> assume for the mirror and the witness they would need to be fully
> licensed? Also does the witness need to be as powerful as the actual DB
> servers?
> If you know of any SQL MVPs in the NY area, please have them contact me if
> they are interested in possibly doing consulting for this setup.
> -L
>
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:efiHUMteHHA.5052@.TK2MSFTNGP06.phx.gbl...
>
No comments:
Post a Comment