I would like to add a table to an existing merge replication. The DB is
approximately 11GB in size. When I proceed through the steps to add the
table using Enterprise Manager, SQL Server 2000 responds as follows:
"After adding a new merge article, you must generate a new snapshot before
changes from any subscription can be merged."
"Although a snapshot of all articles must be generated, only the snapshot of
the new article will be used to synchronize existing subscriptions."
I remember generating an new snapshot for this DB... it took a Loooonnnnggg
time. When SQL2000 says it must generate a snapshot, does it mean for the
entire DB or just the new article?
I thought one of the features of SQL Server 2000 was the ability to add
articles "on the fly" without disturbing what exists.? It is NOT good if I
have to, first, generate a snapshot of the ENTIRE DB... AGAIN! This is not
the way I understand the documentation.
Someone please clarify.?
Brent
brent.erb@.philips.com
IIRC, just a snapshot for the new article will be generated, and distributed
along with metadata for this article.
"Berb" <berb1969@.earthlink.net> wrote in message
news:826193B1-ED96-4D11-B66D-81C4E17D80CF@.microsoft.com...
>I would like to add a table to an existing merge replication. The DB is
> approximately 11GB in size. When I proceed through the steps to add the
> table using Enterprise Manager, SQL Server 2000 responds as follows:
> "After adding a new merge article, you must generate a new snapshot before
> changes from any subscription can be merged."
> "Although a snapshot of all articles must be generated, only the snapshot
> of
> the new article will be used to synchronize existing subscriptions."
> I remember generating an new snapshot for this DB... it took a
> Loooonnnnggg
> time. When SQL2000 says it must generate a snapshot, does it mean for the
> entire DB or just the new article?
> I thought one of the features of SQL Server 2000 was the ability to add
> articles "on the fly" without disturbing what exists.? It is NOT good if
> I
> have to, first, generate a snapshot of the ENTIRE DB... AGAIN! This is
> not
> the way I understand the documentation.
> Someone please clarify.?
>
> Brent
> brent.erb@.philips.com
>
Showing posts with label steps. Show all posts
Showing posts with label steps. Show all posts
Tuesday, March 20, 2012
Thursday, March 8, 2012
Adding new step to SQL Agent Job
I am attempting to add a new step to an existing sql server 2000 job. The
existing job starts upon SQL Server Agent startup. The steps consist of
running a stored procedure on several databases. The last step (4) is
simply a 'wait delay', then the steps begin again. When I insert a new step,
I receive a warning indicating that a circular reference is detected. I've
added steps to the same job in other databases, but did not receive the
warning. Is this something to be concerned about? Thanks in advance for any
suggestions.
For example,
Step 1: Process1
Step 2: Process2
Step 3: Process3
Step 4: Wait30seconds
If I attempt to insert a step between 1 and 2, the warning states:
"WARNING: Circular reference detected: Step [1] 'Process1 flows to Step[4]
'Wait30Seconds', and Step [4] 'Wait30Seconds' flows back to
Step[1]'Process1'. Are you sure that is what you want?
Thank you, Will.
"Will Alber" wrote:
> It sounds like this is exactly what you're wanting - as you want the steps
> to repeat (thus a circular reference is fine).
> This job will run forever, that's what it's warning you about.
> "danid12" <danid12@.discussions.microsoft.com> wrote in message
> news:15E030EF-B183-42B7-BCCA-53F0C456EBCB@.microsoft.com...
>
>
existing job starts upon SQL Server Agent startup. The steps consist of
running a stored procedure on several databases. The last step (4) is
simply a 'wait delay', then the steps begin again. When I insert a new step,
I receive a warning indicating that a circular reference is detected. I've
added steps to the same job in other databases, but did not receive the
warning. Is this something to be concerned about? Thanks in advance for any
suggestions.
For example,
Step 1: Process1
Step 2: Process2
Step 3: Process3
Step 4: Wait30seconds
If I attempt to insert a step between 1 and 2, the warning states:
"WARNING: Circular reference detected: Step [1] 'Process1 flows to Step[4]
'Wait30Seconds', and Step [4] 'Wait30Seconds' flows back to
Step[1]'Process1'. Are you sure that is what you want?
Thank you, Will.
"Will Alber" wrote:
> It sounds like this is exactly what you're wanting - as you want the steps
> to repeat (thus a circular reference is fine).
> This job will run forever, that's what it's warning you about.
> "danid12" <danid12@.discussions.microsoft.com> wrote in message
> news:15E030EF-B183-42B7-BCCA-53F0C456EBCB@.microsoft.com...
>
>
Friday, February 24, 2012
Adding Full-Text Search Indexing to a Cluster
Ihave an Active/Passive Cluster. Can someone point me to a Technet
article or provide the steps for adding Full-text indexing?
I can't seem to find one!
Thank you.
Jay
SQL FTS has to be installed from the start on a cluster. The SQL Server 2000
High availablilty book is pretty good for installing a cluster.
<jay.griffin@.burke.com> wrote in message
news:1107212619.013634.8160@.c13g2000cwb.googlegrou ps.com...
> Ihave an Active/Passive Cluster. Can someone point me to a Technet
> article or provide the steps for adding Full-text indexing?
> I can't seem to find one!
> Thank you.
> Jay
>
|||Jay,
Could you post the full output of -- SELECT @.@.version -- as this is helpful
in understanding your current clustered environment.
For the time being, I'm going to assume that you have a clustered SQL Server
2000 A/P environment. Correct? If so, then you should be using SQL Server
2000 Enterprise Edition and Full-text Indexing (and Full-text Search, often
referred to as SQL FTS) is installed by default.
You can use the SQL Enterprise Manager and select Server and database, you
want to FT-enable and click on Tools -> Full-text Indexing to launch the FT
Indexing Wizard. This wizard (SQLFTWiz.exe) will walk you though all the
necessary steps for adding Full-text Indexing to a selected table. Note, the
table, must have a single column, non-nullable, unique index to qualify for
a table to be FT Indexed. Also, the only restriction for FTI in a clustered
environment, is that the FT Catalog, must be created on the shared disk
drive in your clustered environment.
You may also want to do this via pure T-SQL code, and if so, checkout "Full
Text Indexing using T-SQL from a Profiler Trace" at
http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!304.entry
and this blog entry will walk you though all the necessary T-SQL code.
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
<jay.griffin@.burke.com> wrote in message
news:1107212619.013634.8160@.c13g2000cwb.googlegrou ps.com...
> Ihave an Active/Passive Cluster. Can someone point me to a Technet
> article or provide the steps for adding Full-text indexing?
> I can't seem to find one!
> Thank you.
> Jay
>
|||Thanks for your help. It is SQL 2000 Enterprise (A/P) on Windows 2000
Adv Server. Sorry to omit that important information.
Here is my problem -- Full Text indexing is not installed. When I try
to do what you indicated, Full Text Indexing is grayed out.
I was installing some other software which was going to create a
database. It gave the a warning that Full text indexing was not
installed and the software would not function properly.
If I go into the SQL Setup, I can't add/remove components. The only
option I have is to Uninstall. I am wondering how I can add full-text
indexing.
Thanks for your help,
Jay
John Kane wrote:
> Jay,
> Could you post the full output of -- SELECT @.@.version -- as this is
helpful
> in understanding your current clustered environment.
> For the time being, I'm going to assume that you have a clustered SQL
Server
> 2000 A/P environment. Correct? If so, then you should be using SQL
Server
> 2000 Enterprise Edition and Full-text Indexing (and Full-text Search,
often
> referred to as SQL FTS) is installed by default.
> You can use the SQL Enterprise Manager and select Server and
database, you
> want to FT-enable and click on Tools -> Full-text Indexing to launch
the FT
> Indexing Wizard. This wizard (SQLFTWiz.exe) will walk you though all
the
> necessary steps for adding Full-text Indexing to a selected table.
Note, the
> table, must have a single column, non-nullable, unique index to
qualify for
> a table to be FT Indexed. Also, the only restriction for FTI in a
clustered
> environment, is that the FT Catalog, must be created on the shared
disk
> drive in your clustered environment.
> You may also want to do this via pure T-SQL code, and if so, checkout
"Full
> Text Indexing using T-SQL from a Profiler Trace" at
>
http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!304.entry
> and this blog entry will walk you though all the necessary T-SQL
code.[vbcol=seagreen]
> Hope that helps!
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> <jay.griffin@.burke.com> wrote in message
> news:1107212619.013634.8160@.c13g2000cwb.googlegrou ps.com...
|||You're welcome, Jay,
Despite what you see as "Full Text Indexing is grayed out", it is most
likely that Full Text Search (FTS) is installed because of what you see when
you attempt to add the "Full-Text Search" components via SQL Setup and
"custom installation" where the "Full-Text Search" component option is
already checkmarked. Correct?
If the above is not correct, you may have the MSSQLServer service running
under a local machine account, if so, then checkout KB article Q270671
(Q270671) "PRB: Full Text Search Menus Are Not Enabled for Local Windows NT
Accounts" at:
http://support.microsoft.com/default...;en-us;q270671
If the above is correct, then you can force the removal of the checkmark via
the removal or renaming of the following tracking registry key and the
following procedure to Re-install" the "Full-text Search" components via
deleting (or renaming) the below "tracking key" and re-install (If you're
not using a named instance, remove "<Instance_Name>\".)
NOTE: be sure to be logged on to the server as either Administrator or as a
member of the server's Admin Group!
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\<Instance_Name>\Tracking\
{E07FDDA7-5A21-11d2-9DAD-00C04F79D434}
Once you're done removed (renamed) the above tracking key, then delete the
MSSearch directory from either:
drive_letter:\Program Files\Common Files\Microsoft Shared\
or
drive_letter::\Program Files\Common Files\System\
Then using your SQL Server 2000 installation CD re-install via "Custom
Installation" the Full-Text Search component (it should be un-checked). When
this completes find and save these files: SearchSetup.log (usually under
\windows or \winnt folders) and sqlsp.log. If any problems, please post
these files.
Re-install the service pack that you may have applied to SQL Server 2000, so
that the newly re-installed MSSearch components are upgraded to SP3a levels
and then re-boot &/or restart the MSSearch and MSSQLServer services.
You may also want to consult or perform the procedures document in the
following Kb article: 827449 "How to manually reinstall the Microsoft Search
service for an instance of SQL 2000" at:
http://support.microsoft.com/default...b;EN-US;827449
Finally, and considering that this is a clustered environment, you may also
want to review the following KB articles:
812666 "How to recover a failed full-text search resource on a clustered
instance of SQL Server 2000" at:
http://support.microsoft.com/default.aspx?kbid=812666
"The full-text search results that are returned in a clustered SQL Server
2000 environment may be different when the active node changes" at:
http://support.microsoft.com/default...b;en-us;889708
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
<jay.griffin@.burke.com> wrote in message
news:1107270434.064396.309410@.c13g2000cwb.googlegr oups.com...
> Thanks for your help. It is SQL 2000 Enterprise (A/P) on Windows 2000
> Adv Server. Sorry to omit that important information.
> Here is my problem -- Full Text indexing is not installed. When I try
> to do what you indicated, Full Text Indexing is grayed out.
> I was installing some other software which was going to create a
> database. It gave the a warning that Full text indexing was not
> installed and the software would not function properly.
> If I go into the SQL Setup, I can't add/remove components. The only
> option I have is to Uninstall. I am wondering how I can add full-text
> indexing.
> Thanks for your help,
> Jay
>
> John Kane wrote:
> helpful
> Server
> Server
> often
> database, you
> the FT
> the
> Note, the
> qualify for
> clustered
> disk
> "Full
>
http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!304.entry
> code.
>
|||Thanks John.
Clarification from my previous post: "If I go into the SQL Setup, I
can't add/remove components. =ADThe only option I have is to Uninstall.
" -- ALL other options are grayed out. It is not a matter of them
already being checked. I have no option to check them. It isn't
installed and it won't let me add it.
I am assuming because this is a cluster, components have to be added
differently. Because I have no option to add/remove components under
the custom install. My only option is to Uninstall. (yes - I am
logged in as administrator).
MSSQLServer is running as a domain account and that account is in the
domain admins group.
|||You're welcome, Jay,
Ok, so we take 10 yards and punt (to use a football analogy)... Before I ask
you to un-cluster your servers and re-install SQL Server (a big effort, I
know), I want you to confirm something for me.
Is this SQL Server installed on a Domain Controller or a backup DC? As I've
seen problems with FTS working correctly when installed on a DC or BDC and
with MSSQLServer service startup account being the Domain Administrators
account. If it's not on a DC or BDC, but you are using an account that is a
member of the DOMAIN Administrator group, could you create a separate
DOMAIN\Account and add that account to the local server's Administrators
Group and then using the SQL Enterprise Manager's server property security
tab, change the MSSQLServer service startup account to the newly created
DOMAIN\Account. This change should prompt you to stop & re-start SQL Server
and click yes to this prompt. Then close and re-launch the Enterprise
Manager and see if the Full Text Indexing is still grayed out. If it is not
grayed out, then failover to your Passive node and do the same thing there.
As I've said I've seen this before in non-clustered environments where SQL
Server 2000 was installed on a DC or BDC and the MSSQLServer service
startup account being the Domain Administrators account. The solution in
this case was as I described above or resetting the MSSQLServer service
startup account use LocalSystem or as a last resort move the SQL Server off
the DC or BDC.
Let me know if this successful for you, otherwise, the fallback solution is
to un-cluster your servers and re-install SQL Server :-(
Thanks,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
<jay.griffin@.burke.com> wrote in message
news:1107277007.739900.246620@.z14g2000cwz.googlegr oups.com...
Thanks John.
Clarification from my previous post: "If I go into the SQL Setup, I
can't add/remove components. XThe only option I have is to Uninstall.
" -- ALL other options are grayed out. It is not a matter of them
already being checked. I have no option to check them. It isn't
installed and it won't let me add it.
I am assuming because this is a cluster, components have to be added
differently. Because I have no option to add/remove components under
the custom install. My only option is to Uninstall. (yes - I am
logged in as administrator).
MSSQLServer is running as a domain account and that account is in the
domain admins group.
|||Based on what you are telling me -- I am going to have to uncluster and
re-install. The servers are not a DC. The special user I setup for
the SQL servers is in the local admins group already.
Do you know of any KB articles that would walk me through this without
losing any information?
|||Jay,
Yep, 10 yards & punt... Re-installing a Clustered SQL server is never easy,
but these references may help:
a.. SQL Server 2000 Clustering Whitepaper,
http://www.microsoft.com/SQL/techinf...vercluster.asp
a.. 815431 PRB: Installation of a Named Instance of SQL Server 2000 Virtual
Server http://support.microsoft.com/?id=815431
a.. 325485 WebCast: Microsoft SQL Server 2000 Virtual Server Basic Setup
http://support.microsoft.com/?id=325485
a.. 274446 INF: Upgrade to SQL Server 2000 Failover Solution Recommended for
All... http://support.microsoft.com/?id=274446
a.. 254321 INF: Clustered SQL Server Do's, Don'ts, and Basic Warnings
http://support.microsoft.com/?id=254321
a.. 243218 INF: Installation Order for SQL Server 2000 Enterprise Edition
http://support.microsoft.com/?id=243218
a.. 260758 INF: Frequently Asked Questions - SQL Server 2000 - Failover
Clustering http://support.microsoft.com/?id=260758
Hope this helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
<jay.griffin@.burke.com> wrote in message
news:1107354007.277719.324960@.g14g2000cwa.googlegr oups.com...
> Based on what you are telling me -- I am going to have to uncluster and
> re-install. The servers are not a DC. The special user I setup for
> the SQL servers is in the local admins group already.
> Do you know of any KB articles that would walk me through this without
> losing any information?
>
|||John,
Thank you for all your help on this issue.
Jay
article or provide the steps for adding Full-text indexing?
I can't seem to find one!
Thank you.
Jay
SQL FTS has to be installed from the start on a cluster. The SQL Server 2000
High availablilty book is pretty good for installing a cluster.
<jay.griffin@.burke.com> wrote in message
news:1107212619.013634.8160@.c13g2000cwb.googlegrou ps.com...
> Ihave an Active/Passive Cluster. Can someone point me to a Technet
> article or provide the steps for adding Full-text indexing?
> I can't seem to find one!
> Thank you.
> Jay
>
|||Jay,
Could you post the full output of -- SELECT @.@.version -- as this is helpful
in understanding your current clustered environment.
For the time being, I'm going to assume that you have a clustered SQL Server
2000 A/P environment. Correct? If so, then you should be using SQL Server
2000 Enterprise Edition and Full-text Indexing (and Full-text Search, often
referred to as SQL FTS) is installed by default.
You can use the SQL Enterprise Manager and select Server and database, you
want to FT-enable and click on Tools -> Full-text Indexing to launch the FT
Indexing Wizard. This wizard (SQLFTWiz.exe) will walk you though all the
necessary steps for adding Full-text Indexing to a selected table. Note, the
table, must have a single column, non-nullable, unique index to qualify for
a table to be FT Indexed. Also, the only restriction for FTI in a clustered
environment, is that the FT Catalog, must be created on the shared disk
drive in your clustered environment.
You may also want to do this via pure T-SQL code, and if so, checkout "Full
Text Indexing using T-SQL from a Profiler Trace" at
http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!304.entry
and this blog entry will walk you though all the necessary T-SQL code.
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
<jay.griffin@.burke.com> wrote in message
news:1107212619.013634.8160@.c13g2000cwb.googlegrou ps.com...
> Ihave an Active/Passive Cluster. Can someone point me to a Technet
> article or provide the steps for adding Full-text indexing?
> I can't seem to find one!
> Thank you.
> Jay
>
|||Thanks for your help. It is SQL 2000 Enterprise (A/P) on Windows 2000
Adv Server. Sorry to omit that important information.
Here is my problem -- Full Text indexing is not installed. When I try
to do what you indicated, Full Text Indexing is grayed out.
I was installing some other software which was going to create a
database. It gave the a warning that Full text indexing was not
installed and the software would not function properly.
If I go into the SQL Setup, I can't add/remove components. The only
option I have is to Uninstall. I am wondering how I can add full-text
indexing.
Thanks for your help,
Jay
John Kane wrote:
> Jay,
> Could you post the full output of -- SELECT @.@.version -- as this is
helpful
> in understanding your current clustered environment.
> For the time being, I'm going to assume that you have a clustered SQL
Server
> 2000 A/P environment. Correct? If so, then you should be using SQL
Server
> 2000 Enterprise Edition and Full-text Indexing (and Full-text Search,
often
> referred to as SQL FTS) is installed by default.
> You can use the SQL Enterprise Manager and select Server and
database, you
> want to FT-enable and click on Tools -> Full-text Indexing to launch
the FT
> Indexing Wizard. This wizard (SQLFTWiz.exe) will walk you though all
the
> necessary steps for adding Full-text Indexing to a selected table.
Note, the
> table, must have a single column, non-nullable, unique index to
qualify for
> a table to be FT Indexed. Also, the only restriction for FTI in a
clustered
> environment, is that the FT Catalog, must be created on the shared
disk
> drive in your clustered environment.
> You may also want to do this via pure T-SQL code, and if so, checkout
"Full
> Text Indexing using T-SQL from a Profiler Trace" at
>
http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!304.entry
> and this blog entry will walk you though all the necessary T-SQL
code.[vbcol=seagreen]
> Hope that helps!
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> <jay.griffin@.burke.com> wrote in message
> news:1107212619.013634.8160@.c13g2000cwb.googlegrou ps.com...
|||You're welcome, Jay,
Despite what you see as "Full Text Indexing is grayed out", it is most
likely that Full Text Search (FTS) is installed because of what you see when
you attempt to add the "Full-Text Search" components via SQL Setup and
"custom installation" where the "Full-Text Search" component option is
already checkmarked. Correct?
If the above is not correct, you may have the MSSQLServer service running
under a local machine account, if so, then checkout KB article Q270671
(Q270671) "PRB: Full Text Search Menus Are Not Enabled for Local Windows NT
Accounts" at:
http://support.microsoft.com/default...;en-us;q270671
If the above is correct, then you can force the removal of the checkmark via
the removal or renaming of the following tracking registry key and the
following procedure to Re-install" the "Full-text Search" components via
deleting (or renaming) the below "tracking key" and re-install (If you're
not using a named instance, remove "<Instance_Name>\".)
NOTE: be sure to be logged on to the server as either Administrator or as a
member of the server's Admin Group!
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\<Instance_Name>\Tracking\
{E07FDDA7-5A21-11d2-9DAD-00C04F79D434}
Once you're done removed (renamed) the above tracking key, then delete the
MSSearch directory from either:
drive_letter:\Program Files\Common Files\Microsoft Shared\
or
drive_letter::\Program Files\Common Files\System\
Then using your SQL Server 2000 installation CD re-install via "Custom
Installation" the Full-Text Search component (it should be un-checked). When
this completes find and save these files: SearchSetup.log (usually under
\windows or \winnt folders) and sqlsp.log. If any problems, please post
these files.
Re-install the service pack that you may have applied to SQL Server 2000, so
that the newly re-installed MSSearch components are upgraded to SP3a levels
and then re-boot &/or restart the MSSearch and MSSQLServer services.
You may also want to consult or perform the procedures document in the
following Kb article: 827449 "How to manually reinstall the Microsoft Search
service for an instance of SQL 2000" at:
http://support.microsoft.com/default...b;EN-US;827449
Finally, and considering that this is a clustered environment, you may also
want to review the following KB articles:
812666 "How to recover a failed full-text search resource on a clustered
instance of SQL Server 2000" at:
http://support.microsoft.com/default.aspx?kbid=812666
"The full-text search results that are returned in a clustered SQL Server
2000 environment may be different when the active node changes" at:
http://support.microsoft.com/default...b;en-us;889708
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
<jay.griffin@.burke.com> wrote in message
news:1107270434.064396.309410@.c13g2000cwb.googlegr oups.com...
> Thanks for your help. It is SQL 2000 Enterprise (A/P) on Windows 2000
> Adv Server. Sorry to omit that important information.
> Here is my problem -- Full Text indexing is not installed. When I try
> to do what you indicated, Full Text Indexing is grayed out.
> I was installing some other software which was going to create a
> database. It gave the a warning that Full text indexing was not
> installed and the software would not function properly.
> If I go into the SQL Setup, I can't add/remove components. The only
> option I have is to Uninstall. I am wondering how I can add full-text
> indexing.
> Thanks for your help,
> Jay
>
> John Kane wrote:
> helpful
> Server
> Server
> often
> database, you
> the FT
> the
> Note, the
> qualify for
> clustered
> disk
> "Full
>
http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!304.entry
> code.
>
|||Thanks John.
Clarification from my previous post: "If I go into the SQL Setup, I
can't add/remove components. =ADThe only option I have is to Uninstall.
" -- ALL other options are grayed out. It is not a matter of them
already being checked. I have no option to check them. It isn't
installed and it won't let me add it.
I am assuming because this is a cluster, components have to be added
differently. Because I have no option to add/remove components under
the custom install. My only option is to Uninstall. (yes - I am
logged in as administrator).
MSSQLServer is running as a domain account and that account is in the
domain admins group.
|||You're welcome, Jay,
Ok, so we take 10 yards and punt (to use a football analogy)... Before I ask
you to un-cluster your servers and re-install SQL Server (a big effort, I
know), I want you to confirm something for me.
Is this SQL Server installed on a Domain Controller or a backup DC? As I've
seen problems with FTS working correctly when installed on a DC or BDC and
with MSSQLServer service startup account being the Domain Administrators
account. If it's not on a DC or BDC, but you are using an account that is a
member of the DOMAIN Administrator group, could you create a separate
DOMAIN\Account and add that account to the local server's Administrators
Group and then using the SQL Enterprise Manager's server property security
tab, change the MSSQLServer service startup account to the newly created
DOMAIN\Account. This change should prompt you to stop & re-start SQL Server
and click yes to this prompt. Then close and re-launch the Enterprise
Manager and see if the Full Text Indexing is still grayed out. If it is not
grayed out, then failover to your Passive node and do the same thing there.
As I've said I've seen this before in non-clustered environments where SQL
Server 2000 was installed on a DC or BDC and the MSSQLServer service
startup account being the Domain Administrators account. The solution in
this case was as I described above or resetting the MSSQLServer service
startup account use LocalSystem or as a last resort move the SQL Server off
the DC or BDC.
Let me know if this successful for you, otherwise, the fallback solution is
to un-cluster your servers and re-install SQL Server :-(
Thanks,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
<jay.griffin@.burke.com> wrote in message
news:1107277007.739900.246620@.z14g2000cwz.googlegr oups.com...
Thanks John.
Clarification from my previous post: "If I go into the SQL Setup, I
can't add/remove components. XThe only option I have is to Uninstall.
" -- ALL other options are grayed out. It is not a matter of them
already being checked. I have no option to check them. It isn't
installed and it won't let me add it.
I am assuming because this is a cluster, components have to be added
differently. Because I have no option to add/remove components under
the custom install. My only option is to Uninstall. (yes - I am
logged in as administrator).
MSSQLServer is running as a domain account and that account is in the
domain admins group.
|||Based on what you are telling me -- I am going to have to uncluster and
re-install. The servers are not a DC. The special user I setup for
the SQL servers is in the local admins group already.
Do you know of any KB articles that would walk me through this without
losing any information?
|||Jay,
Yep, 10 yards & punt... Re-installing a Clustered SQL server is never easy,
but these references may help:
a.. SQL Server 2000 Clustering Whitepaper,
http://www.microsoft.com/SQL/techinf...vercluster.asp
a.. 815431 PRB: Installation of a Named Instance of SQL Server 2000 Virtual
Server http://support.microsoft.com/?id=815431
a.. 325485 WebCast: Microsoft SQL Server 2000 Virtual Server Basic Setup
http://support.microsoft.com/?id=325485
a.. 274446 INF: Upgrade to SQL Server 2000 Failover Solution Recommended for
All... http://support.microsoft.com/?id=274446
a.. 254321 INF: Clustered SQL Server Do's, Don'ts, and Basic Warnings
http://support.microsoft.com/?id=254321
a.. 243218 INF: Installation Order for SQL Server 2000 Enterprise Edition
http://support.microsoft.com/?id=243218
a.. 260758 INF: Frequently Asked Questions - SQL Server 2000 - Failover
Clustering http://support.microsoft.com/?id=260758
Hope this helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
<jay.griffin@.burke.com> wrote in message
news:1107354007.277719.324960@.g14g2000cwa.googlegr oups.com...
> Based on what you are telling me -- I am going to have to uncluster and
> re-install. The servers are not a DC. The special user I setup for
> the SQL servers is in the local admins group already.
> Do you know of any KB articles that would walk me through this without
> losing any information?
>
|||John,
Thank you for all your help on this issue.
Jay
Sunday, February 12, 2012
Adding Article/Table!
Hello All,
I'm using Transactional Replication and it's Push subscription.
Can you plz give me the complete steps to add a single table w/o starting
snapshot for all tables.
And another question,
BOL says sp_refreshsubscription for Pull and
sp_reinitsubscription is for Push Subscription.
But I saw newgroup an it says BOL is wrong sp_refreshsubscription works for
both.
What is the difference b/w sp_refreshsubscription and
sp_reinitsubscription?
Thanks in advance.
Naveed.
I just tried to do this:
sp_addarticle 'pubs','jobs','jobs'
I then generated my snapshot - and restarted my distribution agent. Only the
jobs table went over in the new snapshot.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Naveed" <nrehman@.marsonssoft.com> wrote in message
news:OqzXJ94qEHA.3900@.TK2MSFTNGP10.phx.gbl...
> Hello All,
> I'm using Transactional Replication and it's Push subscription.
> Can you plz give me the complete steps to add a single table w/o starting
> snapshot for all tables.
> And another question,
> BOL says sp_refreshsubscription for Pull and
> sp_reinitsubscription is for Push Subscription.
> But I saw newgroup an it says BOL is wrong sp_refreshsubscription works
for
> both.
> What is the difference b/w sp_refreshsubscription and
> sp_reinitsubscription?
> Thanks in advance.
> Naveed.
>
>
I'm using Transactional Replication and it's Push subscription.
Can you plz give me the complete steps to add a single table w/o starting
snapshot for all tables.
And another question,
BOL says sp_refreshsubscription for Pull and
sp_reinitsubscription is for Push Subscription.
But I saw newgroup an it says BOL is wrong sp_refreshsubscription works for
both.
What is the difference b/w sp_refreshsubscription and
sp_reinitsubscription?
Thanks in advance.
Naveed.
I just tried to do this:
sp_addarticle 'pubs','jobs','jobs'
I then generated my snapshot - and restarted my distribution agent. Only the
jobs table went over in the new snapshot.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Naveed" <nrehman@.marsonssoft.com> wrote in message
news:OqzXJ94qEHA.3900@.TK2MSFTNGP10.phx.gbl...
> Hello All,
> I'm using Transactional Replication and it's Push subscription.
> Can you plz give me the complete steps to add a single table w/o starting
> snapshot for all tables.
> And another question,
> BOL says sp_refreshsubscription for Pull and
> sp_reinitsubscription is for Push Subscription.
> But I saw newgroup an it says BOL is wrong sp_refreshsubscription works
for
> both.
> What is the difference b/w sp_refreshsubscription and
> sp_reinitsubscription?
> Thanks in advance.
> Naveed.
>
>
Thursday, February 9, 2012
Adding a table to transactional repliaction
I am adding a table to an existing publication that has one pull subscription
using the steps listed below. When I run the snapshot agent, it does not
recognize the newly added article ("no subscriptions needed initialization").
I WANT TO RUN THE SNAPSHOT FOR JUST ONE TABLE. Do I need to drop and readd
the subscriber or subscription? If so, please let me know the steps.
ALSO, the steps below did work on a QA server but failed in production.
-- Thanks for your help.
exec sp_addarticle @.publication = N'my_PUBLICATION', @.article = N'my_TABLE',
@.source_owner = N'dbo', @.source_object = N'my_TABLE', @.destination_table =
N'my_TABLE', @.type = N'logbased', @.creation_script = null, @.description =
null, @.pre_creation_cmd = N'drop', @.schema_option = 0x00000000000000F3,
@.status = 16, @.vertical_partition = N'false', @.ins_cmd = N'CALL
sp_MSins_my_TABLE', @.del_cmd = N'CALL sp_MSdel_my_TABLE', @.upd_cmd = N'MCALL
sp_MSupd_my_TABLE', @.filter = null, @.sync_object = null, @.auto_identity_range
= N'false', @.force_invalidate_snapshot = 1
GO
select * from distribution..msArticles where article = 'my_TABLE'
go
EXEC sp_refreshsubscriptions
N'my_PUBLICATION'
go
exec sp_reinitsubscription
@.publication = 'my_PUBLICATION',
@.article = 'my_TABLE',
@.for_schema_change = 1,
@.subscriber = 'all'
GO
exec sp_addsubscription
@.publication = 'my_PUBLICATION',
@.article = 'my_TABLE',
@.subscriber = N'SUB_SERVER',
@.destination_db = N'pub_sub_database',
@.sync_type = N'automatic',
@.update_mode = N'read only'
I think you need to run sp_refreshpublications to get it to pick up the
changes.
Hilary Cotter
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
"sbawa" <sbawa@.discussions.microsoft.com> wrote in message
news:F24C7DED-985E-4011-B4E7-F2C5E972F8EC@.microsoft.com...
>I am adding a table to an existing publication that has one pull
>subscription
> using the steps listed below. When I run the snapshot agent, it does not
> recognize the newly added article ("no subscriptions needed
> initialization").
>
> I WANT TO RUN THE SNAPSHOT FOR JUST ONE TABLE. Do I need to drop and
> readd
> the subscriber or subscription? If so, please let me know the steps.
> ALSO, the steps below did work on a QA server but failed in production.
> -- Thanks for your help.
>
> exec sp_addarticle @.publication = N'my_PUBLICATION', @.article =
> N'my_TABLE',
> @.source_owner = N'dbo', @.source_object = N'my_TABLE', @.destination_table =
> N'my_TABLE', @.type = N'logbased', @.creation_script = null, @.description =
> null, @.pre_creation_cmd = N'drop', @.schema_option = 0x00000000000000F3,
> @.status = 16, @.vertical_partition = N'false', @.ins_cmd = N'CALL
> sp_MSins_my_TABLE', @.del_cmd = N'CALL sp_MSdel_my_TABLE', @.upd_cmd =
> N'MCALL
> sp_MSupd_my_TABLE', @.filter = null, @.sync_object = null,
> @.auto_identity_range
> = N'false', @.force_invalidate_snapshot = 1
> GO
> select * from distribution..msArticles where article = 'my_TABLE'
> go
> EXEC sp_refreshsubscriptions
> N'my_PUBLICATION'
> go
> exec sp_reinitsubscription
> @.publication = 'my_PUBLICATION',
> @.article = 'my_TABLE',
> @.for_schema_change = 1,
> @.subscriber = 'all'
> GO
> exec sp_addsubscription
> @.publication = 'my_PUBLICATION',
> @.article = 'my_TABLE',
> @.subscriber = N'SUB_SERVER',
> @.destination_db = N'pub_sub_database',
> @.sync_type = N'automatic',
> @.update_mode = N'read only'
>
|||I tried using object search but unable to find this procedure in any of the
databases. Please help.
Your book on transactional replication is great. But you can probably see
that I haven't gotten too far into it yet.
"Hilary Cotter" wrote:
> I think you need to run sp_refreshpublications to get it to pick up the
> changes.
> --
> Hilary Cotter
> 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
> "sbawa" <sbawa@.discussions.microsoft.com> wrote in message
> news:F24C7DED-985E-4011-B4E7-F2C5E972F8EC@.microsoft.com...
>
>
using the steps listed below. When I run the snapshot agent, it does not
recognize the newly added article ("no subscriptions needed initialization").
I WANT TO RUN THE SNAPSHOT FOR JUST ONE TABLE. Do I need to drop and readd
the subscriber or subscription? If so, please let me know the steps.
ALSO, the steps below did work on a QA server but failed in production.
-- Thanks for your help.
exec sp_addarticle @.publication = N'my_PUBLICATION', @.article = N'my_TABLE',
@.source_owner = N'dbo', @.source_object = N'my_TABLE', @.destination_table =
N'my_TABLE', @.type = N'logbased', @.creation_script = null, @.description =
null, @.pre_creation_cmd = N'drop', @.schema_option = 0x00000000000000F3,
@.status = 16, @.vertical_partition = N'false', @.ins_cmd = N'CALL
sp_MSins_my_TABLE', @.del_cmd = N'CALL sp_MSdel_my_TABLE', @.upd_cmd = N'MCALL
sp_MSupd_my_TABLE', @.filter = null, @.sync_object = null, @.auto_identity_range
= N'false', @.force_invalidate_snapshot = 1
GO
select * from distribution..msArticles where article = 'my_TABLE'
go
EXEC sp_refreshsubscriptions
N'my_PUBLICATION'
go
exec sp_reinitsubscription
@.publication = 'my_PUBLICATION',
@.article = 'my_TABLE',
@.for_schema_change = 1,
@.subscriber = 'all'
GO
exec sp_addsubscription
@.publication = 'my_PUBLICATION',
@.article = 'my_TABLE',
@.subscriber = N'SUB_SERVER',
@.destination_db = N'pub_sub_database',
@.sync_type = N'automatic',
@.update_mode = N'read only'
I think you need to run sp_refreshpublications to get it to pick up the
changes.
Hilary Cotter
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
"sbawa" <sbawa@.discussions.microsoft.com> wrote in message
news:F24C7DED-985E-4011-B4E7-F2C5E972F8EC@.microsoft.com...
>I am adding a table to an existing publication that has one pull
>subscription
> using the steps listed below. When I run the snapshot agent, it does not
> recognize the newly added article ("no subscriptions needed
> initialization").
>
> I WANT TO RUN THE SNAPSHOT FOR JUST ONE TABLE. Do I need to drop and
> readd
> the subscriber or subscription? If so, please let me know the steps.
> ALSO, the steps below did work on a QA server but failed in production.
> -- Thanks for your help.
>
> exec sp_addarticle @.publication = N'my_PUBLICATION', @.article =
> N'my_TABLE',
> @.source_owner = N'dbo', @.source_object = N'my_TABLE', @.destination_table =
> N'my_TABLE', @.type = N'logbased', @.creation_script = null, @.description =
> null, @.pre_creation_cmd = N'drop', @.schema_option = 0x00000000000000F3,
> @.status = 16, @.vertical_partition = N'false', @.ins_cmd = N'CALL
> sp_MSins_my_TABLE', @.del_cmd = N'CALL sp_MSdel_my_TABLE', @.upd_cmd =
> N'MCALL
> sp_MSupd_my_TABLE', @.filter = null, @.sync_object = null,
> @.auto_identity_range
> = N'false', @.force_invalidate_snapshot = 1
> GO
> select * from distribution..msArticles where article = 'my_TABLE'
> go
> EXEC sp_refreshsubscriptions
> N'my_PUBLICATION'
> go
> exec sp_reinitsubscription
> @.publication = 'my_PUBLICATION',
> @.article = 'my_TABLE',
> @.for_schema_change = 1,
> @.subscriber = 'all'
> GO
> exec sp_addsubscription
> @.publication = 'my_PUBLICATION',
> @.article = 'my_TABLE',
> @.subscriber = N'SUB_SERVER',
> @.destination_db = N'pub_sub_database',
> @.sync_type = N'automatic',
> @.update_mode = N'read only'
>
|||I tried using object search but unable to find this procedure in any of the
databases. Please help.
Your book on transactional replication is great. But you can probably see
that I haven't gotten too far into it yet.
"Hilary Cotter" wrote:
> I think you need to run sp_refreshpublications to get it to pick up the
> changes.
> --
> Hilary Cotter
> 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
> "sbawa" <sbawa@.discussions.microsoft.com> wrote in message
> news:F24C7DED-985E-4011-B4E7-F2C5E972F8EC@.microsoft.com...
>
>
Subscribe to:
Posts (Atom)