Re: SMS 2003 and real-time replication

Hi Steven,
thanks for the response. I am using nsi double-take to replicate the SQL
data in real time to another server. What I need is, in the event my site
server goes down, to be able to bring up those databases on another machine
right away. My question is, in order to do this, does the other server have
to have the same netbios name? IP address? is there anything else I would
need to replicate besides the SQL dbs to get it to come up? I'm trying to
recover from a failure quicker than what is outlined in the SMS Backup manual.
Thanks again.

"Steven D. Kaczmarek (MS)" wrote:

> Hi, Vincent
>
> I am not sure what the exact nature of your question is. SMS does not
> support clustering, even for SQL, and it's not clear how you could get SMS
> to work with a third party product - SMS would not know to go to the other
> instance of SQL.
>
> If you're asking about how to recover an SMS site if a SQL server is down,
> I'd recommend the Scenarios and Procedures for SMS 2003: Maintenance,
> Backup, and Recovery guide at
> http://www.microsoft.com/smserver/techinfo/productdoc.
>
> Regards
> Steven Kaczmarek
> Technical Writing Lead
> System Center Management UA
> This message is posted as is and offers no guarantees or warranties.
> "VincentGagliano" <VincentGagliano@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> message news:2659FA06-E604-4F2E-838D-B134C4C7834D@xxxxxxxxxxxxxxxx
> > Hello!
> > Is there any procedures or methods to utilize real-time (async)
> > replication
> > of the SQL db (and any other files that SMS would need) to provide
> > instantaneous failover to another physical server for the site server?
> > Would
> > I need to failover the name of the server in order SMS to recover? We are
> > using NSI Double-take.
> > So far I've tried to replicate the db's and the SMS shares and I'm able to
> > run the SMS admin console on the failover box, but it doesn't show any of
> > the data in the databases. When I look in SQL Admin - the data is there!
> > Thanks!
>
>
>
.

Relevant Pages

  • MP Control Manager Issue
    ... Windows 2003 Standard Server ... SMS 2003 SP1 ... MP encountered an error when connecting to SQL Server. ... If using a standard SQL security account, ...
    (microsoft.public.sms.admin)
  • Re: sms2003 installation in windows2003 two cluster sql node
    ... > Systems Management Server 2003 cluster support requirements ... >> SMS Questions should be posted over in a different newsgroup in the ... >> In the case of SQL on clusters though Microsoft doesn't support it (or at ...
    (microsoft.public.sms.installer)
  • Re: Fresh Install Doesnt Work...Again!
    ... I will verify the sql service account and get back. ... MVP Windows Server System - SMS ... I am attempting to install SMS 2003 SP1 in a production ...
    (microsoft.public.sms.setup)
  • RE: Cannot isntall management point
    ... The SQL server is a member server, the SMS server is a domain controller. ... The MSSQL Service is running under a user account, ...
    (microsoft.public.sms.setup)
  • RE: copying database files
    ... Basically my company is replacing a .net 2000 application runnning on sql ... server 2000 with a new .net application that will be running on sql server ... The data I want to replicate daily is ... "Paul Ibison" wrote: ...
    (microsoft.public.sqlserver.replication)
Loading