Majority Node Set ?

Hello All
Has anyone created a clustered sql2000 instance on windows 2003 in different
geographical areas? I gather this can be done, but there is no shared
storage as such. I believe one has to replicate data another way.
I am looking for some docs on this before I dive in!
Thanks
Simone
Save yourself the trouble. SQL depends on shared storage for the data as
well as the cluster state. No Majority Node Set for SQL Server.
Geoff N, Hiten
Microsoft SQL Server MVP.
"Simone Harris" <pleasenospam@.here.com> wrote in message
news:%23eWcFPTYFHA.3712@.TK2MSFTNGP09.phx.gbl...
> Hello All
> Has anyone created a clustered sql2000 instance on windows 2003 in
> different geographical areas? I gather this can be done, but there is no
> shared storage as such. I believe one has to replicate data another way.
> I am looking for some docs on this before I dive in!
> Thanks
> Simone
>
|||Many thanks
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:efOOlvVYFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Save yourself the trouble. SQL depends on shared storage for the data as
> well as the cluster state. No Majority Node Set for SQL Server.
> Geoff N, Hiten
> Microsoft SQL Server MVP.
> "Simone Harris" <pleasenospam@.here.com> wrote in message
> news:%23eWcFPTYFHA.3712@.TK2MSFTNGP09.phx.gbl...
>

Maintenance Plans cannot be seen by other DBA's

I am not sure if this is the right area or not but here goes. I have a W2K3
SP4- SQL 2005 SP1 running in a clustered environm,ent. I received a call that
the other DBA's cannot see any maintneace plans when they expand the
Management Folder. They do not have any server roles but are the dbo owners
of the 12 databases on the system. I am using Windows Authentication as there
are no loegacy apps which require Mixed Mode Authentication.
I can see the plans as I have server role rights. I have been searching but
cannot find anything relatd as to the security required for them to see
Mainteneace Plans created for their databases.
What group would they have to be in to see the plans? They cannot be part of
any server roles.
Any info would be appreciated.
carl
From Books Online.
http://msdn2.microsoft.com/en-us/library/ms187658.aspx
You must be a member of the sysadmin role to create and manage maintenance
plans, and to view them in Object Explorer. The SQL Server Agent node in
Object Explorer is only displayed for members of the sysadmin fixed server
role, SQLAgentReaderRole, SQLAgentUserRole, or SQLAgentOperatorRole fixed
database roles.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"carl" <carl@.discussions.microsoft.com> wrote in message
news:FF2A2C7E-B34A-40C4-B0F8-44239ADFE4E7@.microsoft.com...
>I am not sure if this is the right area or not but here goes. I have a W2K3
> SP4- SQL 2005 SP1 running in a clustered environm,ent. I received a call
> that
> the other DBA's cannot see any maintneace plans when they expand the
> Management Folder. They do not have any server roles but are the dbo
> owners
> of the 12 databases on the system. I am using Windows Authentication as
> there
> are no loegacy apps which require Mixed Mode Authentication.
> I can see the plans as I have server role rights. I have been searching
> but
> cannot find anything relatd as to the security required for them to see
> Mainteneace Plans created for their databases.
> What group would they have to be in to see the plans? They cannot be part
> of
> any server roles.
> Any info would be appreciated.
> carl

Maintenance Plans cannot be seen by other DBA's

I am not sure if this is the right area or not but here goes. I have a W2K3
SP4- SQL 2005 SP1 running in a clustered environm,ent. I received a call that
the other DBA's cannot see any maintneace plans when they expand the
Management Folder. They do not have any server roles but are the dbo owners
of the 12 databases on the system. I am using Windows Authentication as there
are no loegacy apps which require Mixed Mode Authentication.
I can see the plans as I have server role rights. I have been searching but
cannot find anything relatd as to the security required for them to see
Mainteneace Plans created for their databases.
What group would they have to be in to see the plans? They cannot be part of
any server roles.
Any info would be appreciated.
carlFrom Books Online.
http://msdn2.microsoft.com/en-us/library/ms187658.aspx
You must be a member of the sysadmin role to create and manage maintenance
plans, and to view them in Object Explorer. The SQL Server Agent node in
Object Explorer is only displayed for members of the sysadmin fixed server
role, SQLAgentReaderRole, SQLAgentUserRole, or SQLAgentOperatorRole fixed
database roles.
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"carl" <carl@.discussions.microsoft.com> wrote in message
news:FF2A2C7E-B34A-40C4-B0F8-44239ADFE4E7@.microsoft.com...
>I am not sure if this is the right area or not but here goes. I have a W2K3
> SP4- SQL 2005 SP1 running in a clustered environm,ent. I received a call
> that
> the other DBA's cannot see any maintneace plans when they expand the
> Management Folder. They do not have any server roles but are the dbo
> owners
> of the 12 databases on the system. I am using Windows Authentication as
> there
> are no loegacy apps which require Mixed Mode Authentication.
> I can see the plans as I have server role rights. I have been searching
> but
> cannot find anything relatd as to the security required for them to see
> Mainteneace Plans created for their databases.
> What group would they have to be in to see the plans? They cannot be part
> of
> any server roles.
> Any info would be appreciated.
> carl

Maintenance Plans cannot be seen by other DBA's

I am not sure if this is the right area or not but here goes. I have a W2K3
SP4- SQL 2005 SP1 running in a clustered environm,ent. I received a call tha
t
the other DBA's cannot see any maintneace plans when they expand the
Management Folder. They do not have any server roles but are the dbo owners
of the 12 databases on the system. I am using Windows Authentication as ther
e
are no loegacy apps which require Mixed Mode Authentication.
I can see the plans as I have server role rights. I have been searching but
cannot find anything relatd as to the security required for them to see
Mainteneace Plans created for their databases.
What group would they have to be in to see the plans? They cannot be part of
any server roles.
Any info would be appreciated.
carlFrom Books Online.
http://msdn2.microsoft.com/en-us/library/ms187658.aspx
You must be a member of the sysadmin role to create and manage maintenance
plans, and to view them in Object Explorer. The SQL Server Agent node in
Object Explorer is only displayed for members of the sysadmin fixed server
role, SQLAgentReaderRole, SQLAgentUserRole, or SQLAgentOperatorRole fixed
database roles.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"carl" <carl@.discussions.microsoft.com> wrote in message
news:FF2A2C7E-B34A-40C4-B0F8-44239ADFE4E7@.microsoft.com...
>I am not sure if this is the right area or not but here goes. I have a W2K3
> SP4- SQL 2005 SP1 running in a clustered environm,ent. I received a call
> that
> the other DBA's cannot see any maintneace plans when they expand the
> Management Folder. They do not have any server roles but are the dbo
> owners
> of the 12 databases on the system. I am using Windows Authentication as
> there
> are no loegacy apps which require Mixed Mode Authentication.
> I can see the plans as I have server role rights. I have been searching
> but
> cannot find anything relatd as to the security required for them to see
> Mainteneace Plans created for their databases.
> What group would they have to be in to see the plans? They cannot be part
> of
> any server roles.
> Any info would be appreciated.
> carl