Active/Passive Production with Test Instance

I am trying to setup a SQL cluster with the an
active/passive cluster for production. On the passive
node, I have been told to create a separate disk and
install a developers edition of SQL to use as a test
environment. The developers edition will be a named
instance of SQL to help isolate it from production should
a failover occur.
Does anyone else out there have this type of
configuration in their environment? Have you had any
problems or does it work fine? My gut is not real
comfortable with this, even though we can make it work in
a test lab. I would appreciate any other feed back to
make me feel better, or help me build the case to do
otherwise.
Thanks
Dan,
Reading your description, it appears that you want a production clustered SQL Server instance on one node (that you call active) and another test clustered SQL Server instance on second node (that you called
passive). This will work but then it is not really active/passive, it will be active/active configruation. Basically you are planning to install two clustered SQL Server instances on a two node cluster and each instance
running on seperate nodes. There is no issue in doing this except that you will need make sure that at any time the resources on a single node is enough for both the SQL Server instances.
SQL Server 2000 Failover Clustering is a High Availablity solution. Hence, one would not want to have production and test instances on the same cluster. I would not recommend having prod and test on same cluster
and I have not seen this. I have seen many clusters with two instances of SQL (infact 16 instances are supported) on the same cluster but all the instances are for production and they are configured such that even if
one node fails the other node can run all the instances without any issues.
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||
>--Original Message--
>Dan,
>Reading your description, it appears that you want a
production clustered SQL Server instance on one node
(that you call active) and another test clustered SQL
Server instance on second node (that you called
>passive).
Actually, the test instance of SQL would not be
clustered, but exist solely on the second box. We do not
plan any failover for the test instance.
This will work but then it is not really active/passive,
it will be active/active configruation. Basically you are
planning to install two clustered SQL Server instances on
a two node cluster and each instance
>running on seperate nodes. There is no issue in doing
this except that you will need make sure that at any time
the resources on a single node is enough for both the SQL
Server instances.
>SQL Server 2000 Failover Clustering is a High
Availablity solution. Hence, one would not want to have
production and test instances on the same cluster. I
would not recommend having prod and test on same cluster
>and I have not seen this. I have seen many clusters with
two instances of SQL (infact 16 instances are supported)
on the same cluster but all the instances are for
production and they are configured such that even if
>one node fails the other node can run all the instances
without any issues.
>HTH,
>Best Regards,
>Uttam Parui
>Microsoft Corporation
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Are you secure? For information about the Strategic
Technology Protection Program and to order your FREE
Security Tool Kit, please visit
http://www.microsoft.com/security.
>Microsoft highly recommends that users with Internet
access update their Microsoft software to better protect
against viruses and security vulnerabilities. The easiest
way to do this is to visit the following websites:
>http://www.microsoft.com/protect
>http://www.microsoft.com/security/guidance/default.mspx
>
>.
>
|||Even if the second instance of SQL Server is standalone and not clustered, I would not recommend installing it on a production cluster. The passive node is like
Sometimes there is the notion especially in a single-instance SQL Serve cluster (active/passove) that the unused node (passive node) is being wasted. However, the passive node serve as an insurance policy in
the event of a failure. If you start utilizing the wasted node for something else, what will happen in a failover? Will SQL Server have enough resources to allocate to it?
I will give an example. Few yrs ago, one of my customers who had a SQL Server 7.0 active/passive production cluster thought that the passive node was being wasted and they installed a TEST SQL Server 2000
standalone instance on the passive node. What they didn't realize is that MDAC 2.6 got installed with SQL 2K and MDAC 2.6 can break SQL 7.0 cluster. So, unknowingly they affected their Highly Available
solution.Thats the reason, you don't want to do any test/dev stuff on your prod cluster. Ideally, you should have an identical dev/test cluster where you do all your development and testing and after getting successful
results, do that on the prodcution cluster.
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Active/Passive Failover or Database Mirror without a Shared disk?

This is not my expertise, so would appreciate some help.
Is it possible to create an active/passive failover setup or database
mirroring without a shared disk? Client has two sql servers that they
wanted to upgrade SQL 2000 to SQL 2005 and then use the second box for an
active/passive configuration. They do not have a shared disk which I am
being told is necessary for this.
Unfortunately, I do not have the expertise on this and am reaching out to
the gurus here.
Also if any of the SQL experts in this group want some consulting work in
NYC for this job, please contact me off the list.
Lawrence Abrams
MVP - Windows Security
http://www.bleepingcomputer.com
Thank you very much for the info. Starting to make a bit more sense? I
assume for the mirror and the witness they would need to be fully licensed?
Also does the witness need to be as powerful as the actual DB servers?
If you know of any SQL MVPs in the NY area, please have them contact me if
they are interested in possibly doing consulting for this setup.
-L
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:efiHUMteHHA.5052@.TK2MSFTNGP06.phx.gbl...
> With no shared storage you rule out clustering but Database Mirroring will
> be fine.A couple of whitepapers to help get your head around DB mirroring
> http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
> http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx
> http://www.microsoft.com/technet/prodtechnol/sql/2005/mirroringevents.mspx
>
|||The witness needs a license, but the mirror does not require a SQL license,
provided it is used for failover only. The witness can be a workstation
grade system since all it is doing is observing.
NOTE: Always verify licensing for your configuration with your Microsoft
rep.
While I am not based on the NY area, the company I work for does have a NY
office and would be happy to quote on this project. Email me directly and I
will put you in touch with one of our Business Directors. My posting
address is a valid email address.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Lawrence Abrams" <grinler-REMOVETHIS@.bleepingcomputer.com> wrote in message
news:%23l0LVXteHHA.4604@.TK2MSFTNGP06.phx.gbl...
> Thank you very much for the info. Starting to make a bit more sense? I
> assume for the mirror and the witness they would need to be fully
> licensed? Also does the witness need to be as powerful as the actual DB
> servers?
> If you know of any SQL MVPs in the NY area, please have them contact me if
> they are interested in possibly doing consulting for this setup.
> -L
>
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:efiHUMteHHA.5052@.TK2MSFTNGP06.phx.gbl...
>

Active/Passive > Active/Active

You mean going from a single instance cluster to a
multiple instance cluster (this is the correct
terminology).
It depends on your disk setup. Remember that each SQL
virtual server needs its own set of dedicated disks, not
to mention a dedicated disk for the quorum, and if you're
using W2K3, one for MS DTC.
Also, you need to ensure you have enough memory and
processor to handle the additional load.
I suggest you look at any of the numerous sources out
there, including the SQL 2K HA book by MS Press, or the
failover clustering whitepaper on Microsoft.com
Hi Allan,
Thanks for replying. I should make myself clearer.
Right now I have 2 Dell 6450's attached to EMC Clarion.
They are setup as Active/Passive cluster. The company bought 2
new Dell 6650's and I will be swapping out the servers one at a time to upgrade the H/W.
One of the developers wants to go Active/Active and the only way I think I can do this is uninstall SQL and uninstall the cluster, then reinstall the cluster and and reinstall SQL. If that's the case I think we'll stay with Active/Passive since we couldn
't afford the downtime.
"Allan Hirt" wrote:

> You mean going from a single instance cluster to a
> multiple instance cluster (this is the correct
> terminology).
> It depends on your disk setup. Remember that each SQL
> virtual server needs its own set of dedicated disks, not
> to mention a dedicated disk for the quorum, and if you're
> using W2K3, one for MS DTC.
> Also, you need to ensure you have enough memory and
> processor to handle the additional load.
> I suggest you look at any of the numerous sources out
> there, including the SQL 2K HA book by MS Press, or the
> failover clustering whitepaper on Microsoft.com
>
>
|||I think your developer misunderstands the whole 'active-passive...'
nomenclature. Do you want one or two virtual servers on your cluster? If
one, then it is 'active-passive' or 'single-instance'. Two or more means
'active-active' or 'multi-instance'. If you want to transition your
existing single instance to new hosts, that is a different issue.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"plane123" <plane123@.discussions.microsoft.com> wrote in message
news:305B32A8-6A53-4337-A2AE-48F60DE459CB@.microsoft.com...
> Hi Allan,
> Thanks for replying. I should make myself clearer.
> Right now I have 2 Dell 6450's attached to EMC Clarion.
> They are setup as Active/Passive cluster. The company bought 2
> new Dell 6650's and I will be swapping out the servers one at a time to
upgrade the H/W.
> One of the developers wants to go Active/Active and the only way I think I
can do this is uninstall SQL and uninstall the cluster, then reinstall the
cluster and and reinstall SQL. If that's the case I think we'll stay with
Active/Passive since we couldn't afford the downtime.[vbcol=seagreen]
>
> "Allan Hirt" wrote:
|||Thanks for your input.
I think in order for me to create an active/active setup, I need to reconfigure the shared disk, which I can't do, I'd disrupt all the other attached servers.
Thanks
"Geoff N. Hiten" wrote:

> I think your developer misunderstands the whole 'active-passive...'
> nomenclature. Do you want one or two virtual servers on your cluster? If
> one, then it is 'active-passive' or 'single-instance'. Two or more means
> 'active-active' or 'multi-instance'. If you want to transition your
> existing single instance to new hosts, that is a different issue.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "plane123" <plane123@.discussions.microsoft.com> wrote in message
> news:305B32A8-6A53-4337-A2AE-48F60DE459CB@.microsoft.com...
> upgrade the H/W.
> can do this is uninstall SQL and uninstall the cluster, then reinstall the
> cluster and and reinstall SQL. If that's the case I think we'll stay with
> Active/Passive since we couldn't afford the downtime.
>
>

active/active sql node

Hello,
This is my time to setup active/active SQL on two nodes cluster environment.
I am very familiar with active/passive in which setup one virtual name such
as virtualsql01 and publish to user. For active/active, it seems to me that
system does not allow me to have something like virtualsql01 and
virtualsql02 but it forces to key-in instant name like virtualsql01\xxxx.
My question is that how can we have something like virtualsql01 and
virtualsql02 in the same cluster environment. I believe it will be easy for
everyone in my place to call db server in this way.
Thanks.
Your VirtualSQL01 is the default instance for the cluster. Like a
stand-alone server, you only get one default instance, except it is per
cluster, not per node. I avoid the whole default name on a cluster and use
only named instances. That way, I don't have to explain to the developers
why the names look different.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"naruphon" <naruphon@.hotmail.com> wrote in message
news:O5OnMwY2FHA.3416@.tk2msftngp13.phx.gbl...
> Hello,
> This is my time to setup active/active SQL on two nodes cluster
> environment. I am very familiar with active/passive in which setup one
> virtual name such as virtualsql01 and publish to user. For active/active,
> it seems to me that system does not allow me to have something like
> virtualsql01 and virtualsql02 but it forces to key-in instant name like
> virtualsql01\xxxx. My question is that how can we have something like
> virtualsql01 and virtualsql02 in the same cluster environment. I believe
> it will be easy for everyone in my place to call db server in this way.
> Thanks.
>
|||Just want to add that if you already have virutalsql01 in a cluster, you
can't have virtualsql01\xxx in that same cluster. In other words, there can
be only a single SQL instance per virtual server.
Suffice it to say that you are not the only person puzzled by this peculiar
design choice. I for one would much prefer what you wanted, i.e. simply
virtualsql01, virutalsql02, and so on for different SQL instances in a
cluster.
But if you are willing to explicitly use port numbers, you don't have to
force your users to use the format of virtualserver\sqlinstance. Instead,
they can use <fqdn>,<port number> (e.g. nycsql01.nyc.myfirm.com,9876) to
connect. Some people consider using an explicit port number in a connection
string not to be best practice, I should note.
Linchi
"naruphon" <naruphon@.hotmail.com> wrote in message
news:O5OnMwY2FHA.3416@.tk2msftngp13.phx.gbl...
> Hello,
> This is my time to setup active/active SQL on two nodes cluster
> environment. I am very familiar with active/passive in which setup one
> virtual name such as virtualsql01 and publish to user. For active/active,
> it seems to me that system does not allow me to have something like
> virtualsql01 and virtualsql02 but it forces to key-in instant name like
> virtualsql01\xxxx. My question is that how can we have something like
> virtualsql01 and virtualsql02 in the same cluster environment. I believe
> it will be easy for everyone in my place to call db server in this way.
> Thanks.
>
|||Normally, on a stand-alone system, you would get 1 ServerName (default
instance) and then possibly several named instances ServerName\Instance1,
ServerName\Instance2, . . ., ServerName\Instance15, up to 15 named and 1
default, or 16 namedactually, you can have many more, but Microsoft only
supporting up to 16 total instances, named or default.
The problem with clusters is that each participating node looks like a stand
alone server in that each may host all instances; thus, the binaries and the
naming convention above still applies; however, for a cluster, you have to
create a virtual server resource group for each instance to support the Disk
(which is the critical factor), IP, and Network Name. It is the Network
Name, which knows nothing of SQL Server instances, that must each be unique
within the cluster installation.
So, you end up with unique network names because of clustering, which is a
restriction even before SQL Server is installed, and unique instance names
because of multiple concurrent SQL Server hosting on any one failover node.
Sincerely,
Anthony Thomas

"naruphon" <naruphon@.hotmail.com> wrote in message
news:O5OnMwY2FHA.3416@.tk2msftngp13.phx.gbl...
> Hello,
> This is my time to setup active/active SQL on two nodes cluster
environment.
> I am very familiar with active/passive in which setup one virtual name
such
> as virtualsql01 and publish to user. For active/active, it seems to me
that
> system does not allow me to have something like virtualsql01 and
> virtualsql02 but it forces to key-in instant name like virtualsql01\xxxx.
> My question is that how can we have something like virtualsql01 and
> virtualsql02 in the same cluster environment. I believe it will be easy
for
> everyone in my place to call db server in this way.
> Thanks.
>
|||Thanks to everyone, very straight to the point, keen and concise.
Naruphon
"Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
news:%23AOg2vi2FHA.1576@.TK2MSFTNGP15.phx.gbl...
> Normally, on a stand-alone system, you would get 1 ServerName (default
> instance) and then possibly several named instances ServerName\Instance1,
> ServerName\Instance2, . . ., ServerName\Instance15, up to 15 named and 1
> default, or 16 namedactually, you can have many more, but Microsoft only
> supporting up to 16 total instances, named or default.
> The problem with clusters is that each participating node looks like a
> stand
> alone server in that each may host all instances; thus, the binaries and
> the
> naming convention above still applies; however, for a cluster, you have to
> create a virtual server resource group for each instance to support the
> Disk
> (which is the critical factor), IP, and Network Name. It is the Network
> Name, which knows nothing of SQL Server instances, that must each be
> unique
> within the cluster installation.
> So, you end up with unique network names because of clustering, which is a
> restriction even before SQL Server is installed, and unique instance names
> because of multiple concurrent SQL Server hosting on any one failover
> node.
> Sincerely,
>
> Anthony Thomas
>
> --
> "naruphon" <naruphon@.hotmail.com> wrote in message
> news:O5OnMwY2FHA.3416@.tk2msftngp13.phx.gbl...
> environment.
> such
> that
> for
>

Active Directory connection from SSIS

I'm trying to query against AD to grab some data. I've done this setup and got it to work at my location but can't get it working at one of my customers.

Per information I've found via this site I did the following:

Task: from SS2005, select data elements from Active Directory and populate in ODS (using an

SS2005 Package in SSIS)

1. I created a linked server on the MS2005
   1. EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5', 'ADSDSOObject', 'adsdatasource'
2. I then created the following View (in the Master DB):

CREATE VIEW viewADContacts

AS

SELECT [NAME],MAIL

FROM OPENQUERY( ADSI,

'SELECT NAME, MAIL

FROM ''LDAP://#######/ DC=####,DC=###''

')

The View created w/ no errors

3. When I execute

select * from viewADContacts

I get this error:

Cannot fetch a row from OLE DB provider "ADSDSOObject" for linked server "ADSI".

Any thoughts on this error? Again, I did the exact same thing at my office (against my local AD) and it worked fine.

Thanks in advance

Tom

Still stuck on this - I did install ldapbrowser on the Sql Server 2005 box and was able to query the Active Directory using my windows login (which is how I connect to the sql server). I'm thinking it's something w/ the Provider - any suggestions on how to debug?

thanks

|||

I've changed directions and am trying a Script task using the example from the SS online books

The code is this:

Public Sub Main()

Dim directory As DirectoryServices.DirectorySearcher

Dim result As DirectoryServices.SearchResult

Dim email As String

email = Dts.Variables("email").Value.ToString

Try

directory = New _

DirectoryServices.DirectorySearcher("(mail=" & email & ")")

result = directory.FindOne

Dts.Variables("name").Value = _

result.Properties("name").ToString()

Dts.TaskResult = Dts.Results.Success

Catch ex As Exception

Dts.Events.FireError(0, _

"Script Task Example", _

ex.Message & ControlChars.CrLf & ex.StackTrace, _

String.Empty, 0)

Dts.TaskResult = Dts.Results.Failure

End Try

Dts.TaskResult = Dts.Results.Success

End Sub

End Class

My problem is I'm not getting a value for 'Name' instead when I display in a dataflow task (using dataviewer)following the script task the value of Name = 'System.DirectoryServices.ResultPropertyValueCollection'

It's seems like it is telling me its property not the value. I'm not a VB/.Net developer so I'm just guessing as to what the value means.

Any help would be appreciated.

thanks

Active Directory connection from SSIS

I'm trying to query against AD to grab some data. I've done this setup and got it to work at my location but can't get it working at one of my customers.

Per information I've found via this site I did the following:

Task: from SS2005, select data elements from Active Directory and populate in ODS (using an

SS2005 Package in SSIS)

1. I created a linked server on the MS2005
   1. EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5', 'ADSDSOObject', 'adsdatasource'
2. I then created the following View (in the Master DB):

CREATE VIEW viewADContacts

AS

SELECT [NAME],MAIL

FROM OPENQUERY( ADSI,

'SELECT NAME, MAIL

FROM ''LDAP://#######/ DC=####,DC=###''

')

The View created w/ no errors

3. When I execute

select * from viewADContacts

I get this error:

Cannot fetch a row from OLE DB provider "ADSDSOObject" for linked server "ADSI".

Any thoughts on this error? Again, I did the exact same thing at my office (against my local AD) and it worked fine.

Thanks in advance

Tom

Still stuck on this - I did install ldapbrowser on the Sql Server 2005 box and was able to query the Active Directory using my windows login (which is how I connect to the sql server). I'm thinking it's something w/ the Provider - any suggestions on how to debug?

thanks

|||

I've changed directions and am trying a Script task using the example from the SS online books

The code is this:

Public Sub Main()

Dim directory As DirectoryServices.DirectorySearcher

Dim result As DirectoryServices.SearchResult

Dim email As String

email = Dts.Variables("email").Value.ToString

Try

directory = New _

DirectoryServices.DirectorySearcher("(mail=" & email & ")")

result = directory.FindOne

Dts.Variables("name").Value = _

result.Properties("name").ToString()

Dts.TaskResult = Dts.Results.Success

Catch ex As Exception

Dts.Events.FireError(0, _

"Script Task Example", _

ex.Message & ControlChars.CrLf & ex.StackTrace, _

String.Empty, 0)

Dts.TaskResult = Dts.Results.Failure

End Try

Dts.TaskResult = Dts.Results.Success

End Sub

End Class

My problem is I'm not getting a value for 'Name' instead when I display in a dataflow task (using dataviewer)following the script task the value of Name = 'System.DirectoryServices.ResultPropertyValueCollection'

It's seems like it is telling me its property not the value. I'm not a VB/.Net developer so I'm just guessing as to what the value means.

Any help would be appreciated.

thanks

Actiuve/Active

Hi,
I have to setup a Active/Active cluster and I need to know if there has to
be made any change in the applications that the user has? For example, direct
the app to the other virtual server, etc...
Thanks
What do you mean by "Active-Active"? It sounds like you may be
misunderstanding what the terms mean. "Active-Active" describes an onder
clustering technology that went away after SQL 7.0. The current correct
term is "multi-instance" and acts just like having multiple instances of SQL
Server on a single, non-clustered host.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Fred" <Fred@.discussions.microsoft.com> wrote in message
news:A2B00583-DDC2-41A1-94D9-394F2E985C6B@.microsoft.com...
> Hi,
> I have to setup a Active/Active cluster and I need to know if there has to
> be made any change in the applications that the user has? For example,
> direct
> the app to the other virtual server, etc...
>
> Thanks
|||Sorry,
what I meant was, we're going in a process of installing a cluster using
something similar to what then was called "Active/Active" in a sense that one
server serves a set of databases a acts as a failover through a instance what
will be activated in case of a failure in the other server. Something like:
Server1: Actives databases: A, B, C
Inactives databases: D, E, F
Server2: Actives databases: D, E, F
Inactives databases: A, B, C
In case of a failure in Server1, the Server2, serves not only databases D,
E, F, but also A, B, C. I think that's called in the old terminology
"Active/Active". My major point is, do I have to make some sort of change in
my applications to "redirect" them to the "new server" or the cluster can
that care of that automatically?
Is there any source that really clarifies clustering technology in terms of
applications made by our programmers?
Thanks for your observations, point taken.
"Geoff N. Hiten" wrote:

> What do you mean by "Active-Active"? It sounds like you may be
> misunderstanding what the terms mean. "Active-Active" describes an onder
> clustering technology that went away after SQL 7.0. The current correct
> term is "multi-instance" and acts just like having multiple instances of SQL
> Server on a single, non-clustered host.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Fred" <Fred@.discussions.microsoft.com> wrote in message
> news:A2B00583-DDC2-41A1-94D9-394F2E985C6B@.microsoft.com...
>
>
|||Ok, you do have an almost correct picture of SQL Clustering.
It works more like this:
Instance 1: Databases A, B, C
Instance 2: Databases D, E, F
Host machines: Node 1, Node 2
Normal operation has Instance 1 on Node 1 and Instance 2 on Node 2. If node
2 fails, Node 1 grabs the resources for Instance 2 and starts up Instance 2
on Node 1. The outside world still sees Instance 2 with the exact same
names, security, and IP address(es) as before. The two( or more depending
on your cluster configuration) instances look like completely different and
independent servers to the outside world. Reconnection is necessary since
the SQL service stopped and restarted, but no client redirection is required
since the clients connect to a virtual IP address.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Fred" <Fred@.discussions.microsoft.com> wrote in message
news:C20D7184-9C4B-4D63-B3F8-AA37951F3CC0@.microsoft.com...[vbcol=seagreen]
> Sorry,
> what I meant was, we're going in a process of installing a cluster using
> something similar to what then was called "Active/Active" in a sense that
> one
> server serves a set of databases a acts as a failover through a instance
> what
> will be activated in case of a failure in the other server. Something
> like:
> Server1: Actives databases: A, B, C
> Inactives databases: D, E, F
> Server2: Actives databases: D, E, F
> Inactives databases: A, B, C
> In case of a failure in Server1, the Server2, serves not only databases D,
> E, F, but also A, B, C. I think that's called in the old terminology
> "Active/Active". My major point is, do I have to make some sort of change
> in
> my applications to "redirect" them to the "new server" or the cluster can
> that care of that automatically?
> Is there any source that really clarifies clustering technology in terms
> of
> applications made by our programmers?
> Thanks for your observations, point taken.
>
> "Geoff N. Hiten" wrote:
|||Thanks, this post helped a lot to clarify these points to me.
"Geoff N. Hiten" wrote:

> Ok, you do have an almost correct picture of SQL Clustering.
> It works more like this:
> Instance 1: Databases A, B, C
> Instance 2: Databases D, E, F
> Host machines: Node 1, Node 2
> Normal operation has Instance 1 on Node 1 and Instance 2 on Node 2. If node
> 2 fails, Node 1 grabs the resources for Instance 2 and starts up Instance 2
> on Node 1. The outside world still sees Instance 2 with the exact same
> names, security, and IP address(es) as before. The two( or more depending
> on your cluster configuration) instances look like completely different and
> independent servers to the outside world. Reconnection is necessary since
> the SQL service stopped and restarted, but no client redirection is required
> since the clients connect to a virtual IP address.
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Fred" <Fred@.discussions.microsoft.com> wrote in message
> news:C20D7184-9C4B-4D63-B3F8-AA37951F3CC0@.microsoft.com...
>
>

ack message not picked up by stored procs

Hi

I setup a message between 2 database on a local instance. The message is send to the target and the target did send a reply. However, the reply is not picked up by the initiator. I did a try but there was nothing telling me why it did not pick up the reply. there is nothing in the textdata of the brokerclassify event. I query the queue on the initiator, the message is there, but the stored proc attached to the queue is not doing anything it seems. What else can I check here,

thanks

P

If you're positive the reply is in the initiator's queue but activation does not kick in, I'd look at the following:
- activation is not turned on. Check the is_activation_enabled column of sys.service_queues. If is 0, ALTER QUEUE <queueName> WITH ACTIVATION (STATUS = ON);
- the procedure has a bug and it runs, but has no effects. Check in Profiler if the Broker:Activation (Strat/Stop) events are being traced.

HTH,
~ Remus

Accidental Log Shipping?

Hi there, was just wondering...
I setup database replication , creating a publisher and a subscriber....
all seemed to go well.
Anyway, my question is... Can Log Shipping be setup accidently while doing
this process? I know nothing
about log shipping.. and someone is trying to point blame on me for creating
'Log shipping'.
Is it possible that I could have created log shipping without even knowing..
or does it require a bit of know how.
Also... if Log shipping was setup... Does it run automatically?
And last but not least.. If it was setup, and the standby server was turned
off.. and not running... Would log shipping run?
Sorry about my ignorance.. but I have a feeling the people who are making
these accusations are out to create / pass blame across to poor old me for
their own mistakes.
thanks in advance everyone
-Simon
That depends. On SQL Server Enterprise Edition and Developer Edition it is
conceivable that someone could blunder their way through the wizard being
totally ignorant about what they are doing. However most noobs would get
scared and back out of the dialogs pretty soon fearing they were doing
something destructive.
On other editions log shipping requires significant "programming" and the
chances of setting it up unintentionally are very remote.
It is possible that you scheduled transaction log dumps which are an
important step in log shipping (but only the first step and not the only
step). This can be done using the maintenance wizard.
All in all its pretty remote.
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
"Simon" <none@.none.com> wrote in message
news:deeKf.12140$yK1.10202@.news-server.bigpond.net.au...
> Hi there, was just wondering...
> I setup database replication , creating a publisher and a subscriber....
> all seemed to go well.
> Anyway, my question is... Can Log Shipping be setup accidently while doing
> this process? I know nothing
> about log shipping.. and someone is trying to point blame on me for
> creating 'Log shipping'.
> Is it possible that I could have created log shipping without even
> knowing.. or does it require a bit of know how.
> Also... if Log shipping was setup... Does it run automatically?
> And last but not least.. If it was setup, and the standby server was
> turned off.. and not running... Would log shipping run?
> Sorry about my ignorance.. but I have a feeling the people who are making
> these accusations are out to create / pass blame across to poor old me for
> their own mistakes.
> thanks in advance everyone
> -Simon
>
>
|||Hi Hilary, Thanks very much for your response.
If it was in my error, Would there have to be transactions in the
msdb.logshipping_primaries / secondaries table on the standby server to show
that Log shipping actually took place?
Where on the stanby server could I check history of Log shipping taking
place.
Thanks in advance once again
P.S. They have already 'supposedly' turned off Log shipping on the primary
machine... but the 'accused' standby machine hasnt been connected to the
network for months.. so if log shipping did take place months ago before it
was removed from the network, would I be able to check its history some how.
Thanks again
-Simon
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ueq2k1fNGHA.984@.tk2msftngp13.phx.gbl...
> That depends. On SQL Server Enterprise Edition and Developer Edition it is
> conceivable that someone could blunder their way through the wizard being
> totally ignorant about what they are doing. However most noobs would get
> scared and back out of the dialogs pretty soon fearing they were doing
> something destructive.
> On other editions log shipping requires significant "programming" and the
> chances of setting it up unintentionally are very remote.
> It is possible that you scheduled transaction log dumps which are an
> important step in log shipping (but only the first step and not the only
> step). This can be done using the maintenance wizard.
> All in all its pretty remote.
> --
> 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
>
> "Simon" <none@.none.com> wrote in message
> news:deeKf.12140$yK1.10202@.news-server.bigpond.net.au...
>
|||You would really have to be day dreaming pretty badly to "accidentally" set
this up. Using the wizards in 2000 or 2005, you would have to wade through
at least half a dozen screens, some of which have at least a dozen options
that have to be set. You could conceivably load up a script from a Resource
Kit, hit the button and create a log shipping set up, but you would have to
edit the script in the first place with at least server names and share
names, not something that I would call accidental. So, I would pretty much
have to say that it is not possible to "accidentally" setup log shipping.
That would be pretty analogous to someone accidentally building a house, it
just doesn't happen.
If log shipping is setup, you will see at least 3 jobs. Backup, copy, and
restore. The backup jb will generally be on the primary. The copy and
restore would generally be on the secondary. You will have the backup job
creating the backups in a share on the primary. The copy job would pull
them from the share on the primary to the share on the secondary. So you
can look in two places for the pieces. SQL Server Agent will have the jobs.
The file system on both primary and secondary will have a share created
which will contain tran log backups.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Simon" <none@.none.com> wrote in message
news:deeKf.12140$yK1.10202@.news-server.bigpond.net.au...
> Hi there, was just wondering...
> I setup database replication , creating a publisher and a subscriber....
> all seemed to go well.
> Anyway, my question is... Can Log Shipping be setup accidently while doing
> this process? I know nothing
> about log shipping.. and someone is trying to point blame on me for
> creating 'Log shipping'.
> Is it possible that I could have created log shipping without even
> knowing.. or does it require a bit of know how.
> Also... if Log shipping was setup... Does it run automatically?
> And last but not least.. If it was setup, and the standby server was
> turned off.. and not running... Would log shipping run?
> Sorry about my ignorance.. but I have a feeling the people who are making
> these accusations are out to create / pass blame across to poor old me for
> their own mistakes.
> thanks in advance everyone
> -Simon
>
>

Accessing MSDE 2000

I have downloaded msde 2000. I have edited and saved the setup.ini file for
a sa password.
[Options]
SAPWD="cfm56z"
Setup appears to run and install msde. However when I try to access it with
DbatMGR, I get
SQL Server does not exist or access is denied
Any suggestions would be helpful.
Thanks,
Fred Herring
hi Fred,
Fred Herring wrote:
> Setup appears to run and install msde. However when I try to access
> it with DbatMGR, I get
> SQL Server does not exist or access is denied
>
this kind of error is a general exception raised by MDAC... please check
http://support.microsoft.com/default...06&Product=sql
for more info on how to troubleshoot it
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply