First, apologies if this is the wrong forum for this post - if so please
gently redirect me to the correct place to post.
I have taken over as the DBA/developer on a ProjectServer instance. In my
database there are some groups of talbes that I don't think should be their.
I can't link them to anything in MSPS and they are probably from some
tutorial. The three sets begin with DS_, OBJ_, and UNV_.
The DS_ tables are DS_PENDING_JOBS and DS_USER_LIST
The OBJ_ tables have names like OBJ_M_ACTOR and OBJ_M_CHANNEL
The UNV_ tables have names like UNV_RELATIONS and UNV_TAB_OBBJ
As best as I can tell - reviewing MSPS documentation - these have nothing to
do with ProjectServer. They look like they might have been involved in some
sort of Use Case modeling tool or something.
Is anybody familiar with these tables? Am I free to delete them?
Thanks
Bob,
Looks like Business Objects to me. All ProjectServer tables are prefixed
with MSP_.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Bob wrote:
> First, apologies if this is the wrong forum for this post - if so please
> gently redirect me to the correct place to post.
> I have taken over as the DBA/developer on a ProjectServer instance. In my
> database there are some groups of talbes that I don't think should be their.
> I can't link them to anything in MSPS and they are probably from some
> tutorial. The three sets begin with DS_, OBJ_, and UNV_.
> The DS_ tables are DS_PENDING_JOBS and DS_USER_LIST
> The OBJ_ tables have names like OBJ_M_ACTOR and OBJ_M_CHANNEL
> The UNV_ tables have names like UNV_RELATIONS and UNV_TAB_OBBJ
> As best as I can tell - reviewing MSPS documentation - these have nothing to
> do with ProjectServer. They look like they might have been involved in some
> sort of Use Case modeling tool or something.
> Is anybody familiar with these tables? Am I free to delete them?
> Thanks
>
2012年3月22日星期四
Anybody recognize these tables?
First, apologies if this is the wrong forum for this post - if so please
gently redirect me to the correct place to post.
I have taken over as the DBA/developer on a ProjectServer instance. In my
database there are some groups of talbes that I don't think should be their.
I can't link them to anything in MSPS and they are probably from some
tutorial. The three sets begin with DS_, OBJ_, and UNV_.
The DS_ tables are DS_PENDING_JOBS and DS_USER_LIST
The OBJ_ tables have names like OBJ_M_ACTOR and OBJ_M_CHANNEL
The UNV_ tables have names like UNV_RELATIONS and UNV_TAB_OBBJ
As best as I can tell - reviewing MSPS documentation - these have nothing to
do with ProjectServer. They look like they might have been involved in some
sort of Use Case modeling tool or something.
Is anybody familiar with these tables? Am I free to delete them?
ThanksBob,
Looks like Business Objects to me. All ProjectServer tables are prefixed
with MSP_.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Bob wrote:
> First, apologies if this is the wrong forum for this post - if so please
> gently redirect me to the correct place to post.
> I have taken over as the DBA/developer on a ProjectServer instance. In my
> database there are some groups of talbes that I don't think should be their.
> I can't link them to anything in MSPS and they are probably from some
> tutorial. The three sets begin with DS_, OBJ_, and UNV_.
> The DS_ tables are DS_PENDING_JOBS and DS_USER_LIST
> The OBJ_ tables have names like OBJ_M_ACTOR and OBJ_M_CHANNEL
> The UNV_ tables have names like UNV_RELATIONS and UNV_TAB_OBBJ
> As best as I can tell - reviewing MSPS documentation - these have nothing to
> do with ProjectServer. They look like they might have been involved in some
> sort of Use Case modeling tool or something.
> Is anybody familiar with these tables? Am I free to delete them?
> Thanks
>sql
gently redirect me to the correct place to post.
I have taken over as the DBA/developer on a ProjectServer instance. In my
database there are some groups of talbes that I don't think should be their.
I can't link them to anything in MSPS and they are probably from some
tutorial. The three sets begin with DS_, OBJ_, and UNV_.
The DS_ tables are DS_PENDING_JOBS and DS_USER_LIST
The OBJ_ tables have names like OBJ_M_ACTOR and OBJ_M_CHANNEL
The UNV_ tables have names like UNV_RELATIONS and UNV_TAB_OBBJ
As best as I can tell - reviewing MSPS documentation - these have nothing to
do with ProjectServer. They look like they might have been involved in some
sort of Use Case modeling tool or something.
Is anybody familiar with these tables? Am I free to delete them?
ThanksBob,
Looks like Business Objects to me. All ProjectServer tables are prefixed
with MSP_.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Bob wrote:
> First, apologies if this is the wrong forum for this post - if so please
> gently redirect me to the correct place to post.
> I have taken over as the DBA/developer on a ProjectServer instance. In my
> database there are some groups of talbes that I don't think should be their.
> I can't link them to anything in MSPS and they are probably from some
> tutorial. The three sets begin with DS_, OBJ_, and UNV_.
> The DS_ tables are DS_PENDING_JOBS and DS_USER_LIST
> The OBJ_ tables have names like OBJ_M_ACTOR and OBJ_M_CHANNEL
> The UNV_ tables have names like UNV_RELATIONS and UNV_TAB_OBBJ
> As best as I can tell - reviewing MSPS documentation - these have nothing to
> do with ProjectServer. They look like they might have been involved in some
> sort of Use Case modeling tool or something.
> Is anybody familiar with these tables? Am I free to delete them?
> Thanks
>sql
Anybody recognize these tables?
First, apologies if this is the wrong forum for this post - if so please
gently redirect me to the correct place to post.
I have taken over as the DBA/developer on a ProjectServer instance. In my
database there are some groups of talbes that I don't think should be their.
I can't link them to anything in MSPS and they are probably from some
tutorial. The three sets begin with DS_, OBJ_, and UNV_.
The DS_ tables are DS_PENDING_JOBS and DS_USER_LIST
The OBJ_ tables have names like OBJ_M_ACTOR and OBJ_M_CHANNEL
The UNV_ tables have names like UNV_RELATIONS and UNV_TAB_OBBJ
As best as I can tell - reviewing MSPS documentation - these have nothing to
do with ProjectServer. They look like they might have been involved in some
sort of Use Case modeling tool or something.
Is anybody familiar with these tables? Am I free to delete them?
ThanksBob,
Looks like Business Objects to me. All ProjectServer tables are prefixed
with MSP_.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Bob wrote:
> First, apologies if this is the wrong forum for this post - if so please
> gently redirect me to the correct place to post.
> I have taken over as the DBA/developer on a ProjectServer instance. In my
> database there are some groups of talbes that I don't think should be thei
r.
> I can't link them to anything in MSPS and they are probably from some
> tutorial. The three sets begin with DS_, OBJ_, and UNV_.
> The DS_ tables are DS_PENDING_JOBS and DS_USER_LIST
> The OBJ_ tables have names like OBJ_M_ACTOR and OBJ_M_CHANNEL
> The UNV_ tables have names like UNV_RELATIONS and UNV_TAB_OBBJ
> As best as I can tell - reviewing MSPS documentation - these have nothing
to
> do with ProjectServer. They look like they might have been involved in so
me
> sort of Use Case modeling tool or something.
> Is anybody familiar with these tables? Am I free to delete them?
> Thanks
>
gently redirect me to the correct place to post.
I have taken over as the DBA/developer on a ProjectServer instance. In my
database there are some groups of talbes that I don't think should be their.
I can't link them to anything in MSPS and they are probably from some
tutorial. The three sets begin with DS_, OBJ_, and UNV_.
The DS_ tables are DS_PENDING_JOBS and DS_USER_LIST
The OBJ_ tables have names like OBJ_M_ACTOR and OBJ_M_CHANNEL
The UNV_ tables have names like UNV_RELATIONS and UNV_TAB_OBBJ
As best as I can tell - reviewing MSPS documentation - these have nothing to
do with ProjectServer. They look like they might have been involved in some
sort of Use Case modeling tool or something.
Is anybody familiar with these tables? Am I free to delete them?
ThanksBob,
Looks like Business Objects to me. All ProjectServer tables are prefixed
with MSP_.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Bob wrote:
> First, apologies if this is the wrong forum for this post - if so please
> gently redirect me to the correct place to post.
> I have taken over as the DBA/developer on a ProjectServer instance. In my
> database there are some groups of talbes that I don't think should be thei
r.
> I can't link them to anything in MSPS and they are probably from some
> tutorial. The three sets begin with DS_, OBJ_, and UNV_.
> The DS_ tables are DS_PENDING_JOBS and DS_USER_LIST
> The OBJ_ tables have names like OBJ_M_ACTOR and OBJ_M_CHANNEL
> The UNV_ tables have names like UNV_RELATIONS and UNV_TAB_OBBJ
> As best as I can tell - reviewing MSPS documentation - these have nothing
to
> do with ProjectServer. They look like they might have been involved in so
me
> sort of Use Case modeling tool or something.
> Is anybody familiar with these tables? Am I free to delete them?
> Thanks
>
2012年2月16日星期四
Any documentation to set up multi instance cluster
I want to set up 3 active and 1 passive on a 4 node cluster and would like
to see an install guide for something like that. Can anyone redirect me to
one ?
Thanks
Use the guide you found for the first instance, then follow the books online
to install the rest of the instances.
Remember each instance will need an IP and dedicated disk(s).
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Hassan" <hassan@.hotmail.com> wrote in message
news:eVo9tfnRHHA.3948@.TK2MSFTNGP05.phx.gbl...
>I want to set up 3 active and 1 passive on a 4 node cluster and would like
>to see an install guide for something like that. Can anyone redirect me to
>one ?
> Thanks
>
|||Are you having trouble setting up the cluster or the SQL Server instances?
If you are running N + I, then when you install SQL Server, you only include
two nodes as potential resource owners.
If we designate nodes 1, 2, and 3 as the active nodes and 4 as the passive,
then for instance 1 you would include nodes 1 and 4, for instance 2, nodes 2
and 4, and for instance 3, nodes 3 and 4.
Other than this, the setup for SQL Server is exactly the same as for a
single instanced, 2-node cluster.
Perhaps I am not understanding your question fully.
Here are two references, one for multi-node clusters, and one for SQL Server
failover clustering (the document is for SS2K but applicable for SS2K5; it
also provides a link to SS2K5 related information).
See the Number of Nodes and Failover Plan section:
http://technet2.microsoft.com/WindowsServer/en/library/f41adff5-87df-483e-9edd-8484501d79921033.mspx?mfr=true
SQL Server:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en
Sincerely,
Anthony Thomas
"Hassan" <hassan@.hotmail.com> wrote in message
news:eVo9tfnRHHA.3948@.TK2MSFTNGP05.phx.gbl...
> I want to set up 3 active and 1 passive on a 4 node cluster and would like
> to see an install guide for something like that. Can anyone redirect me to
> one ?
> Thanks
>
to see an install guide for something like that. Can anyone redirect me to
one ?
Thanks
Use the guide you found for the first instance, then follow the books online
to install the rest of the instances.
Remember each instance will need an IP and dedicated disk(s).
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Hassan" <hassan@.hotmail.com> wrote in message
news:eVo9tfnRHHA.3948@.TK2MSFTNGP05.phx.gbl...
>I want to set up 3 active and 1 passive on a 4 node cluster and would like
>to see an install guide for something like that. Can anyone redirect me to
>one ?
> Thanks
>
|||Are you having trouble setting up the cluster or the SQL Server instances?
If you are running N + I, then when you install SQL Server, you only include
two nodes as potential resource owners.
If we designate nodes 1, 2, and 3 as the active nodes and 4 as the passive,
then for instance 1 you would include nodes 1 and 4, for instance 2, nodes 2
and 4, and for instance 3, nodes 3 and 4.
Other than this, the setup for SQL Server is exactly the same as for a
single instanced, 2-node cluster.
Perhaps I am not understanding your question fully.
Here are two references, one for multi-node clusters, and one for SQL Server
failover clustering (the document is for SS2K but applicable for SS2K5; it
also provides a link to SS2K5 related information).
See the Number of Nodes and Failover Plan section:
http://technet2.microsoft.com/WindowsServer/en/library/f41adff5-87df-483e-9edd-8484501d79921033.mspx?mfr=true
SQL Server:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en
Sincerely,
Anthony Thomas
"Hassan" <hassan@.hotmail.com> wrote in message
news:eVo9tfnRHHA.3948@.TK2MSFTNGP05.phx.gbl...
> I want to set up 3 active and 1 passive on a 4 node cluster and would like
> to see an install guide for something like that. Can anyone redirect me to
> one ?
> Thanks
>
订阅:
博文 (Atom)