Re: msmq to sql?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

What happens then when the server that is running msmq goes down? Why would you think that would be more reliable than SQL Server? MSMQ can't even begin to duplicate the functionality of SQL Server and should never be thought of as a backup to or replacement for it. You are better off looking at valid HA or DR means for SQL Server such as Clustering, Database Mirroring, (possibly replication), Log shipping etc. But your goals and business needs will dictate the actual methods used.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Andy" <kc2ine@xxxxxxxxx> wrote in message news:u%23%23CdMEHIHA.1316@xxxxxxxxxxxxxxxxxxxxxxx
Hi,
If I'd like to ensure that in case sql server is down user still can access and write the the data what option do I have? Since writing is more important I thought about MSMQ tu put between the server and the application, but what about reading? Any other techiniques?
In case of MSMQ, can you suggest any example how to use it with SQL server?
thanks


.

Relevant Pages

  • Re: Who is using MSMQ?
    ... SQL Server is one of several services ... that sometime uses DTC to manage distributed transactions. ... to shut down DTC for whatever reason, the dependency logic listed MSMQ as ... Do you know why the SQL Server Service Manager is asking ...
    (microsoft.public.sqlserver.security)
  • Re: Who is using MSMQ?
    ... MSMQ is not installed with SQL ... But as Roger pointed out this is not dependant on SQL Server ... the MSDTC service it can affect other services that depend on MSDTC, ... When I use SQL Server Service Manager to shutdown SQL Server, ...
    (microsoft.public.sqlserver.security)
  • Re: Who is using MSMQ?
    ... SQL Server?" ... and the answer here is that "MSDTC is used by SQL Server but it ... The extent to which SQL Server uses MSMQ is ... MSMQTriggers depend on it. ...
    (microsoft.public.sqlserver.security)
  • Re: Who is using MSMQ?
    ... To add on to the other responses, the MSMQ warning messages you get from the ... SQL Server Service Manager are the same ones you get from the Windows MMC ...
    (microsoft.public.sqlserver.security)
  • Re: Who is using MSMQ?
    ... it is normal to get the qustion asking about MSMQ and MSMQTriggers. ... Do you know why the SQL Server Service Manager is asking ...
    (microsoft.public.sqlserver.security)