Re: Data Mirroring in addition to Cluster

Check out:

http://technet.microsoft.com/en-us/magazine/cc162479.aspx

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada

"LanLan" <LanLan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4A8B8637-4AE8-499E-BD87-B60747B3F20A@xxxxxxxxxxxxxxxx
Basically, we have a 24/7 database on the MS SQL 2005 cluster. Last week,
the
cluster failed due to the NIC fault. The service was stopped for almost 4
hours. The penality is heavy. My manager want to add another layer to ensure
the availability of service, such as data mirroring.

I just want to check whether anyone here has adapted such technology and
could share some experience.


.

Relevant Pages

  • Re: Database recovery with data file only
    ... Basically using that command breaks your business logic as there's no ... "Dan Guzman" wrote in message ... >> database Backup as well as ... >>> SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: How critical is the transaction log file?
    ... Tibor Karaszi, SQL Server MVP ... file when you have only one file (no log file). ... circumstances it is supported to attach only an mdf file. ... > This development database that we're building does not have any 'user' ...
    (microsoft.public.sqlserver.tools)
  • Re: commiting the transaction log?
    ... Tibor Karaszi, SQL Server MVP ... been that the file growth (such as that by alter database or autogrowth) is ... Is that the reason for the log file (in the file system) having time stamp that is pretty old ... But even if I run the FULL backup, and then the T-log backup, I can see that ...
    (microsoft.public.sqlserver.server)
  • Re: Inserting new rows that use divided values
    ... Mary Bray [SQL Server MVP] ... > it to an existing database. ... > REFERENCES order_cost; ... > correct syntax. ...
    (microsoft.public.sqlserver.programming)
  • Re: Failing Log Backups
    ... My production database is marked suspect and nobody can use it. ... SQL Server MVP ... Since then, the log backups for the above database began to fail, but it still appears to be writing the log files. ... or index rebuild job failed with the same error message for this database. ...
    (microsoft.public.sqlserver.server)
Loading