moving from a single server to multiple servers



Hi all,

We have a Single Windows 2000 server (Back office edition, configured as a
Primary domain controller).

It has SQL server 2000 running, which serves a bespoke database application.
The server is also used as a simple fileserver for documents, etc... We do
not use Exchange Server.

I need to have a way to kind of replicate this server to another server
incase this server was to crash, with the other server instantly, or very
quickly taking over, either automatically or through a quick reconfiguration
of IP addresses, etc...

Now, one of the issues is that the server has certain networked applications
that are not SQL server, or Active directory integrated.

The third requirement is to hopefully have a solution where the main server
can be backed up whole to the backup server off-site over a Hi speeed SDSL
connection.

My initial thinking was to setup another server localy, and they would both
connect to a Network attached storage device. Then somehow copy that drive
over the SDSL connection.

Does anyone have suggestions on which road to take on this ?

Any suggestions are welcome, even ones that involve new hardware.

Also would the task be easier if I upgraded them both to 2003 server ?

Regards,

Mike.


.



Relevant Pages

  • 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)
  • Re: Best replication architecture?
    ... Looking for a SQL Server replication book? ... So if it is subscribing to Publisher 1, ...
    (microsoft.public.sqlserver.replication)