Re: Log shipping Failover.

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks.


"Hilary Cotter" <hilary.cotter@xxxxxxxxx> escribió en el mensaje
news:uVn3vl5kGHA.4776@xxxxxxxxxxxxxxxxxxxxxxx
No, you can't do this for automatic failover. While it is possible to hard
code this in your application, Microsoft does not recommend you do this as
you should redirect your clients as part of a controlled failover
processes.

Have a look at the section entitled Log Shipping and Application Code in
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part4/c1361.mspx?mfr=true

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Miguel" <sentynel@xxxxxxxxx> wrote in message
news:eU9sPX5kGHA.1276@xxxxxxxxxxxxxxxxxxxxxxx
Hello.

How must I configure SQL Server clients, when a failover occurs between a
primary server and secondary server using Log shipping?

I know that in a Mirroring environment I can configure the SQL provider
with 2 server names. Can I do anything similiar in a Log shipping
environment?

Thanks in advance.





.

Relevant Pages

  • Re: SMS 2003 Installation & Configuration Question
    ... Assuming an even distribution of clients, ... I run SMS and SQL Server on the same ...
    (microsoft.public.sms.setup)
  • Kein Zugriff auf Netzwerklaufwerke.... unklare Situation
    ... WIN2000, SQL Server ... Clients: ... Computer: Computername ...
    (microsoft.public.de.german.windows.server.networking)
  • Re: SQL Server Client/Server architecture advice please.
    ... I have clients that have done what you describe for years. ... By setting up a secure VPN connection, you can build a fairly simple architecture that leverages years of evolution using client-server connections. ... This keeps the bulk of the intelligence on the server and permits you to use well-understood approaches to build your applications. ... I do not recommend using direct TCP/IP connections to SQL Server. ...
    (microsoft.public.sqlserver.connect)
  • Re: "Cult of the Wintel PC" raises head at AWCs switch to Macs
    ... all the clients are Macs running the native VIPS app. ... what you're runnning on the SERVER that determines whether you have to ... Then they have no licensing fees to pay over what ever life ... I went to M$ page on SQL server along with reading the article. ...
    (comp.sys.mac.advocacy)
  • Re: Licensing for Cnetral Subscriber
    ... cals. ... Doing the math for your particular topology assuming 10 clients in each ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)