Re: SMS 2.0 moved to new hardware - new db server

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

From: Mark McClure (mrkmcclure_at_excite.com)
Date: 03/22/04 

Date: Mon, 22 Mar 2004 18:57:49 -0500

Not supported or just flat doesn't work? I don't want to have
something that isn't suported but I'm curious why my queries and site
status stopped working.

So what is the easiest way to get the roles off of the SQL server? I
couldn't do that before the recovery was complete. Now if I want to
move the SQL Monitor back to the SMS site server, what is the best way
to do so?

I'll be upgrading the site to SMS 2003 which I believe will ask during
the installation/upgrade. Might that be the best route?

- Mark

On Mon, 22 Mar 2004 08:25:57 -0800, "Stan White [MS]"
<stanwh@microsoft.com> wrote:

>Unfortunately no SMS site system roles are supported on clustered SQL
>Server.
>
>Also - if you followed the instructions in the SMS 2003 Recovery Expert
>(hardware swapping) you should have a good chance of moving the site
>successfully. Other methods have not been as successful.
>--
>--
>Stan [MSFT]
>--
>--
>This posting is provided "AS IS" with no warranties, and confers no rights.
>--

Relevant Pages

  • Re: Handling an exception
    ... Kind regards ... | to start SQL server & connect to the DB then if it s successful then have ... "goto retry" could be used for evil, however it can also be used for good... ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Handling an exception
    ... | to start SQL server & connect to the DB then if it s successful then have ... | line saying Resume Next & then continue with whatever I wanted to do. ... "goto retry" could be used for evil, however it can also be used for good... ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: How trace logon failed
    ... You'd have to capture the host name (which may not ... >> SQL Server supports four kinds of Audit levels to record the user accesses ... All - successful and failed login attempts are both audited. ...
    (microsoft.public.sqlserver.security)
  • How can a datatable be written to a new SQL Server table?
    ... SQL Server from where it can be manipulated. ... SQL Server table, (this has been apparently successful), ... ByVal strTableName As String) As Boolean ... Dim blnRVal As Boolean = False ...
    (microsoft.public.dotnet.framework.adonet)