Re: warm standby server

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

From: Kristofer Gafvert (kgafvert_at_NEWSilopia.com)
Date: 05/24/04


Date: Mon, 24 May 2004 22:34:54 +0200

Hello,

Is the problem only with SQL Server?

In SQL Server Books Online, you have a section called "Using Standby
Servers" (Administrating SQL Server ->Managing Servers) that you might want
to read.

-- 
Regards,
Kristofer Gafvert - IIS MVP
http://www.ilopia.com - When you need help!
"Shane Daniels" <shanedaniels101@yahooo.com> wrote in message
news:ulCJHlaQEHA.3596@tk2msftngp13.phx.gbl...
> Hi,
>
> I have a Windows 2003 server running an IIS6 website which uses a MS SQL
> Server 2000 database on the same server and would like to create another
> similar server to act as a hot standby. What do most people do in this
> situation? I'd ideally like to have the SQL database as identical as
> possible on the standby server (preferably not going down the replication
> route) but the web files are probably ok not to be replicated real-time
(was
> thinking of using Robocopy every 5 mins or so?). Do I need to use the
> cluster services on Windows 2003 or NLB (automatic failover would be
> preferable but not essential)? Maybe would be better to use something like
> the NSI Double-Take software (this seems expensive though)?
>
> Thanks for any suggestions.
>
> Shane.
>
>
>


Relevant Pages

  • Re: SharePoint and SQL Sercer replication
    ... the DR SQL server in non useable mode. ... can then turn the standby SQL server into recieving requests but again the ... server when replication takes place and even after the farm fails the ...
    (microsoft.public.sharepoint.portalserver)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)