Replication to SQL Server 2005 Express

Hello.
I have a SQL Server 2005 Enterprise Edition with a database. I want to make
a merge replication of that database to some machines with SQL Server 2005
Express Edition's installed. I have created a merge replication publishment
and if I make a local subscription on the SQL Server 2005 Enterprise Edition
everything works great. But if I make a subscription on a SQL Server 2005
Express Edition which is in the same network with the publisher, the
databases do not synchronize (if I make a pull subscription I have an
'Uninitialized subscripition' warning in the Replication Monitor and if I
make a push subscription the status is 'Synchronizing' but my data is not
replicated).
I tried to do things like enabling remote access to the SQL Express server
and disabling the firewall on that machine, but it still doesn't work. What
should I do?
Thank you in advance,
Stefan Filip
Run profiler on the subscriber/express machine to find out where it is
getting stuck.
http://www.zetainteractive.com - Shift Happens!
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
"Stefan Filip" <StefanFilip@.discussions.microsoft.com> wrote in message
news:2BA863F6-637D-4D0D-8AB2-8FB97EE8AD59@.microsoft.com...
> Hello.
> I have a SQL Server 2005 Enterprise Edition with a database. I want to
> make
> a merge replication of that database to some machines with SQL Server 2005
> Express Edition's installed. I have created a merge replication
> publishment
> and if I make a local subscription on the SQL Server 2005 Enterprise
> Edition
> everything works great. But if I make a subscription on a SQL Server 2005
> Express Edition which is in the same network with the publisher, the
> databases do not synchronize (if I make a pull subscription I have an
> 'Uninitialized subscripition' warning in the Replication Monitor and if I
> make a push subscription the status is 'Synchronizing' but my data is not
> replicated).
> I tried to do things like enabling remote access to the SQL Express server
> and disabling the firewall on that machine, but it still doesn't work.
> What
> should I do?
> Thank you in advance,
> Stefan Filip

Replication Subscription Standard Edition

So I set up a "Replication/Local Publication" on a Production SQL
2005
Database.
It publishes a Database on the production database.
I then set up a "Replication/Local Subscription" on another Database
we call "Report Database"
that will have reports running on it and querying the Subscription
which is feed from the
production database.
They are syncronizing fine and everthing looks great.
My question is how do I access the Subscription? Can I query it like
a
database
using a "Database Engine Query"? Do I have to create a Database
instance on the "Report Database" Server
feeding off the Subscription?
Am I not going to be able to access the subscription because I don't
have snap shots?
I have no idea what to do now? How can I query the subscription? Can
the subscription act like a database?
I am having problems understanding the question. You have transactional
replication set up correctly and it is syncing ok to the Report Database.
This database can now be queried as per usual. if you are concerned about
blocking, you could use read_committed_snapshot isolation level to help with
the concurrency of reports.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||Replication makes copies of tables and their data which by default will be
identical to the tables in the publication database. You should be able to
query them in the same way you query them in the publication database.
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
"jughead" <mike.aarset@.gmail.com> wrote in message
news:1173882913.696871.315700@.o5g2000hsb.googlegro ups.com...
> So I set up a "Replication/Local Publication" on a Production SQL
> 2005
> Database.
> It publishes a Database on the production database.
> I then set up a "Replication/Local Subscription" on another Database
> we call "Report Database"
> that will have reports running on it and querying the Subscription
> which is feed from the
> production database.
>
> They are syncronizing fine and everthing looks great.
>
> My question is how do I access the Subscription? Can I query it like
> a
> database
> using a "Database Engine Query"? Do I have to create a Database
> instance on the "Report Database" Server
> feeding off the Subscription?
> Am I not going to be able to access the subscription because I don't
> have snap shots?
>
> I have no idea what to do now? How can I query the subscription? Can
> the subscription act like a database?
>
|||On Mar 14, 8:12 am, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
> Replication makes copies of tables and their data which by default will be
> identical to the tables in the publication database. You should be able to
> query them in the same way you query them in the publication database.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com
> "jughead" <mike.aar...@.gmail.com> wrote in message
> news:1173882913.696871.315700@.o5g2000hsb.googlegro ups.com...
>
>
>
>
> - Show quoted text -
I'm just wondering how to query the subscription.
When the subscription is created on the Report Database is a database
created on that server?
|||On Mar 14, 8:15 am, "jughead" <mike.aar...@.gmail.com> wrote:
> On Mar 14, 8:12 am, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
>
>
>
>
>
>
>
>
>
> I'm just wondering how to query the subscription.
> When the subscription is created on the Report Database is a database
> created on that server... Hide quoted text -
> - Show quoted text -
I had an existing database on my Report Server that was the same name
of the Database on the Production Server that is getting publicated.
I am going to do a new publication on a different database and see how
it goes. Thanks guys
|||No, its not, you have to pre-create it.
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
"jughead" <mike.aarset@.gmail.com> wrote in message
news:1173885320.499067.58050@.y66g2000hsf.googlegro ups.com...
> On Mar 14, 8:12 am, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
> I'm just wondering how to query the subscription.
> When the subscription is created on the Report Database is a database
> created on that server?
>
|||On Mar 14, 10:58 am, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
> No, its not, you have to pre-create it.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com
> "jughead" <mike.aar...@.gmail.com> wrote in message
> news:1173885320.499067.58050@.y66g2000hsf.googlegro ups.com...
>
>
>
>
>
>
>
>
> - Show quoted text -
You guys are right. I don't know what the heck I was doing when I
created my first Publication and Subscription.
Seems that everything is awesome now!
Thanks everyone
sql

replication question

can replication between sql server 2005 standard edition and express editionSQL Server 2005 Express can only act as the subscriber in a replication
process.
ML
http://milambda.blogspot.com/|||I think it's also the case that it can only subscribe to an sql 2005
publisher, is this right?|||Although this is not quite obvious from the following article, I think SQL
Server 2005 Express can act as a subscriber in a SQL 2000 replication (where
either the Publisher or the Distributer are SQL Sever 2000).
http://msdn2.microsoft.com/en-us/library/ms143699(SQL.90).aspx
I'm not certain.
ML
http://milambda.blogspot.com/|||aahh - I see it depends on the type of replication.
transactional it's fine:
"A read-only Subscriber to a transactional publication can be any
version within two versions of the Publisher version. For example: a
SQL Server version 7.0 Publisher running can have SQL Server 2005
Subscribers; and a SQL Server 2005 Publisher can have SQL Server
version 7.0 Subscribers."
but merge it isn't
"A Subscriber to a merge publication can be any version less than or
equal to the Publisher version."
thanks for the link

replication problem

Hello:

We are using SQL Server 2000 Standard Edition on Windows 2000. If we want to set up a DR site, we have 2 options:

a. transactional replication
b. log shipping

However since we do not have Enterprise Edition, maybe the best option we have is transactional replication.

My problem with transactional replication is when we set it up, we do not seem to have control over initial snapshot. When the database is huge, we prefer to manually take the snapshot and restore it at DR site, is it possible ?

rgds,
eric ngYes, you have a choice between initializing the database to subscriber or not. If you say no, then sql would assume you already have the same schema and data in the subscriber.|||Originally posted by joejcheng
Yes, you have a choice between initializing the database to subscriber or not. If you say no, then sql would assume you already have the same schema and data in the subscriber.

Thank you. The manual does not seem to have step-by-step guidelines on how to manually send the snapshot over to subscriber server before transactional replication starts continous replication.

Btw, I come across a lot of people discouraging people using transactional replication as DR method.

Is it true that transactional replication is very taxing to the production server ?

Is custom log shipping worth trying (if we are using standard edition) ?

Is third-party software eg DoubleTake would be much better in our context ?

rgds,
eric ng|||The other way around that is to disable the snapshot right after you setup the replication. You can disable it in the Replication Monitor or you can disable it as a scheduled task.

Transactional Replication can be very slow if you have large batches coming accross the network. But it provides you more concurrent processing than Log Shipping. Remember, Log Shipping is simply a backup/restore process, and every time you restore the database you would have disallow or kill all the user access. Just imagine this is done hourly, the users will be interrupted every hour. On the other hand, Log Shipping is easier to manage. And if you can restore only once a day in the evening, that could be your choice.

Replication Problem

Hi,
Now, I've installed SQL Server 2000 standard edition, and
I've registered the Remote Computer in my Enterprise
Manager. How ever when I run the "Create Publication
Wizard", I get an Information Message, that:
"SQL Server Agent on 'MyComputer' currently uses the
system account, which causes replication between servers
to fail. In the follwing dialog box, specify another
account for the service startup acccout".
Anyway, once I press OK, I come through a Dialog Box
called "SQL Server Agent Properties - MyComputer", where
in the General Tab "Service Startup Account" is disabled.
After I ignore it and come through another Dialog Box
called "Specify Snaphsot Folder". In that Dialog box, the
default value
was "\\RemoteComputer\C$.....\MSSQL\ReplData", but I do
get another Information Message as saying:
"'\\RemoteComputer\C$.....\MSSQL\ReplData' is not a valid
path, or it referes to a file isntead of folder. Enter
the Path to an existing folder." And this doesn't give to
go through the Wizard.
Why this is happening? how can I use Enterprise Manager
from another computer to configure Replication Scenario's
to a computer with MSDE 2000 Installed, Else If i Cant use
enterprise Manager, how can I use the osql tool to
configure replication. The SQL books online is Complicated
on osql, so please help me by telling how would you
configure this replication without Enterprise Manager on
Computer with only MSDE 2000 installed?
Regards,
Nazeer.
NOTE: My computers are connected to a LAN
Nazeer,
if you're replicating to another computer you'll need to do 2 things:
(1) go to control panel, administrative tools, services and select the sql
server agent service. Change the startup account to a domain user. To make
things easy, put this account in the local admin's group (assuming
builtin/administrators are in sysadmin also on sqlserver). Do the same on
the subscriber, preferably with the same account. This is not the most
granular way to set things up, and for more detailed info, have a look in
the replication, security section of BOL. Initially let's just ensure you
can get this up and working.
(2) on the publisher share the repldata folder as \\computername\repldata
and configure replication to use this share (right-click replication
monitor, distributor properties, publishers tab, publisher elipsis...).
HTH,
Paul bison
|||Hi Paul,
Thanx for your solution, it did work out correctly. OK,
there's one more problem,
In case, If the Publisher is a MSDE 2000, how am I gone to
create a publications, subsribtions etc.? and what is ment
by "Row guide column"?
Nazeer,
>--Original Message--
>Nazeer,
>if you're replicating to another computer you'll need to
do 2 things:
>(1) go to control panel, administrative tools, services
and select the sql
>server agent service. Change the startup account to a
domain user. To make
>things easy, put this account in the local admin's group
(assuming
>builtin/administrators are in sysadmin also on
sqlserver). Do the same on
>the subscriber, preferably with the same account. This is
not the most
>granular way to set things up, and for more detailed
info, have a look in
>the replication, security section of BOL. Initially let's
just ensure you
>can get this up and working.
>(2) on the publisher share the repldata folder as
\\computername\repldata
>and configure replication to use this share (right-click
replication
>monitor, distributor properties, publishers tab,
publisher elipsis...).
>HTH,
>Paul bison
>
>.
>
|||Nazeer,
if you're using MSDE, you could use SQLDMO if you wanted to create the
publication programatically. If you need to do it graphically, the MSDE can
potentially be administered from Enterprise Manager - however, please first
check the licensing documents as I'm not too sure if this is permitted or
not. If you need to create a subscription on the MSDE box , you could use
windows synchronization manager.
GUIDS are used in merge replication and updating subscriber scenarios. Merge
will create a rowguid column or use an existing column having the rowguid
attribute. In merge the guid doesn't change while it does for updating
subscribers but still, they are essentially just unique identifiers for a
row.
HTH,
Paul Ibison
|||I suggest you use the replication ActiveX controls as they have methods in
them which allow you to connect to the Publisher without having to register
the subscribers in EM or using Client Network Utility.
If you use SQL DMO you will still have to use Client Network Utility which
is a violation of your licensing agreement for MSDE.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23quBWZffEHA.712@.TK2MSFTNGP09.phx.gbl...
> Nazeer,
> if you're using MSDE, you could use SQLDMO if you wanted to create the
> publication programatically. If you need to do it graphically, the MSDE
can
> potentially be administered from Enterprise Manager - however, please
first
> check the licensing documents as I'm not too sure if this is permitted or
> not. If you need to create a subscription on the MSDE box , you could use
> windows synchronization manager.
> GUIDS are used in merge replication and updating subscriber scenarios.
Merge
> will create a rowguid column or use an existing column having the rowguid
> attribute. In merge the guid doesn't change while it does for updating
> subscribers but still, they are essentially just unique identifiers for a
> row.
> HTH,
> Paul Ibison
>
|||Hi,
I just want to know, is it possible to replicate some
certain entries only. Now say, that there is a Server
(assume that it's called as MiniServer) which
Maintains "Purchase Orders". This Purchase Orders' Primary
Key is "OrderID" and it's an autoincremental field. Also
this MiniServer's Purchase Order Table's Last OrderID
value is 50. This MiniServer Replicates it's Data to the
MainServer at the end of Each office days.
Just note that the MainServer's Purchase Order Table has
it's Last OrderID = 25, and the MainServer needs all the
OrderID more than 25 from the MiniServer.Is this possible
with Replication? If so, how can I set it in SQL Server
Replication?
Awaiting your Response in Anticipation.
Thanx in Advance.
HIFNI NAZEER

>--Original Message--
>Nazeer,
>if you're using MSDE, you could use SQLDMO if you wanted
to create the
>publication programatically. If you need to do it
graphically, the MSDE can
>potentially be administered from Enterprise Manager -
however, please first
>check the licensing documents as I'm not too sure if this
is permitted or
>not. If you need to create a subscription on the MSDE
box , you could use
>windows synchronization manager.
>GUIDS are used in merge replication and updating
subscriber scenarios. Merge
>will create a rowguid column or use an existing column
having the rowguid
>attribute. In merge the guid doesn't change while it does
for updating
>subscribers but still, they are essentially just unique
identifiers for a
>row.
>HTH,
>Paul Ibison
>
>.
>
|||Hifni,
with merge replication, the it is not normally so difficult to achieve this
setup.
If you were using merge replication, only those records not yet transferred
from MiniServer to MainServer will be replicated, so if 1-25 originated from
MiniServer and are now on MainServer, they won't be replicated again. If the
records 1-25 came originally from MainServer and are now on MiniServer, they
won't be cycled backwards to MainServer, unless they have been modified on
MiniServer.
BTW there is no possibility of (identity & PK) OrderIDs overlapping - they
are partitioned into ranges either during the publication setup or manually.
HTH,
Paul Ibison

Replication on Named Instance SS2K

Is it possible to create a Pull Subscription on a named instance in SQL Server 2000 Developer Edition? When I try, I get an error message 14234 saying that it can't find the value '@.server'. Its hint is to look for the server in sp_helpserver. When I go to QA and connect to that named instance and run sp_helpserver, I see it there.

Sincerely,

can you post the complete error message with all the details. can you also tell us what version of sql server you're connecting to (select @.@.version in query analyzer), as well as what version of sql server you have on the machine that has Enterprise Manager?

Replication Monitor - Publisher is empty, but my replication is still there and working

I have a wired situation..!
I set up transactional replication on one of my development server (SQL
2000 Dev Edition with sp4).
It is running fine without any issues and all of a sudden, i noticed in
my repication monitor tab under Publisher where I usually see the
publication is empty now.
I do see the snapshot agent, log reader and distribution agent under my
agents inside the replication Monitor. But its usefull to see all 3
agents in one window under publisher before. What happend? Is there any
way to get that inside that monitor? Has someone encountered this
sitation before? Please advise...
After that I tried to create a new set of replication on different
database on the same server and i dont see those either under
Replication Monitor - Publishers...
All it says is (No Items)...
I would appreciate any help to correct this issue... Thanks in advance..
Which account are you using to connect to the EM?
"Query Builder" <querybuilder@.gmail.com> wrote in message
news:1162496955.745756.103220@.e3g2000cwe.googlegro ups.com...
>I have a wired situation..!
> I set up transactional replication on one of my development server (SQL
> 2000 Dev Edition with sp4).
> It is running fine without any issues and all of a sudden, i noticed in
> my repication monitor tab under Publisher where I usually see the
> publication is empty now.
> I do see the snapshot agent, log reader and distribution agent under my
> agents inside the replication Monitor. But its usefull to see all 3
> agents in one window under publisher before. What happend? Is there any
> way to get that inside that monitor? Has someone encountered this
> sitation before? Please advise...
> After that I tried to create a new set of replication on different
> database on the same server and i dont see those either under
> Replication Monitor - Publishers...
> All it says is (No Items)...
> I would appreciate any help to correct this issue... Thanks in advance..
>
|||I think your subscription has expired and being dropped. Check to see if the
job exists in the jobs folder, it will have a name similar to the
publication.
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
"Query Builder" <querybuilder@.gmail.com> wrote in message
news:1162496955.745756.103220@.e3g2000cwe.googlegro ups.com...
>I have a wired situation..!
> I set up transactional replication on one of my development server (SQL
> 2000 Dev Edition with sp4).
> It is running fine without any issues and all of a sudden, i noticed in
> my repication monitor tab under Publisher where I usually see the
> publication is empty now.
> I do see the snapshot agent, log reader and distribution agent under my
> agents inside the replication Monitor. But its usefull to see all 3
> agents in one window under publisher before. What happend? Is there any
> way to get that inside that monitor? Has someone encountered this
> sitation before? Please advise...
> After that I tried to create a new set of replication on different
> database on the same server and i dont see those either under
> Replication Monitor - Publishers...
> All it says is (No Items)...
> I would appreciate any help to correct this issue... Thanks in advance..
>
|||I am connected thru EM using the SA account. I also have adimin rights
thru windows authentication...
How do I check my subscriptions are expired or not? I created a new
replication for testing and it is also working fine but i dont see the
replication in the replication monitor.. I do see the publications
under the replication--> publication tree...
THanks for all your input. I would apprecate if you can help me figure
this out...! Thanks again
On Nov 3, 6:34 am, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:[vbcol=seagreen]
> I think your subscription has expired and being dropped. Check to see if the
> job exists in the jobs folder, it will have a name similar to the
> publication.
> --
> 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 FTShttp://www.indexserverfaq.com
> "Query Builder" <querybuil...@.gmail.com> wrote in messagenews:1162496955.745756.103220@.e3g2000cwe.go oglegroups.com...
>
>
>
|||I still have this issue.. Any thoughts? ... ideas.. ?
Thanks in advance..
Query Builder wrote:[vbcol=seagreen]
> I am connected thru EM using the SA account. I also have adimin rights
> thru windows authentication...
> How do I check my subscriptions are expired or not? I created a new
> replication for testing and it is also working fine but i dont see the
> replication in the replication monitor.. I do see the publications
> under the replication--> publication tree...
> THanks for all your input. I would apprecate if you can help me figure
> this out...! Thanks again
>
> On Nov 3, 6:34 am, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
|||I still have this issue.. Any thoughts? ... ideas.. ?
Thanks in advance..
Query Builder wrote:[vbcol=seagreen]
> I am connected thru EM using the SA account. I also have adimin rights
> thru windows authentication...
> How do I check my subscriptions are expired or not? I created a new
> replication for testing and it is also working fine but i dont see the
> replication in the replication monitor.. I do see the publications
> under the replication--> publication tree...
> THanks for all your input. I would apprecate if you can help me figure
> this out...! Thanks again
>
> On Nov 3, 6:34 am, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
|||I finally figured out the issue... I had the sql names changed.. when I
changed it back, the replications appeared under the replication
monitor tab...
So the moral of the whole story(issue) is never change SQL jobs
associated with replication.. It will disspear from the replication
monitor group...
Query Builder wrote:[vbcol=seagreen]
> I still have this issue.. Any thoughts? ... ideas.. ?
> Thanks in advance..
> Query Builder wrote:

Replication issues after a Database Restore - Unable to drop or create Transactional Repli

Hi,

I have transactional replication set up on on of our MS SQL 2000 (SP4)
Std Edition database server

Because of an unfortunate scenario, I had to restore one of the
publication databases. I scripted the replication module and dropped
the publication first. Then did a full restore.

When I try to set up the replication thru the script, it created the
publication with the following error message

Server: Msg 2714, Level 16, State 5, Procedure SYNC_FCR To
GPRPTS_GL00100, Line 1
There is already an object named 'SYNC_FCR To GPRPTS_GL00100' in the
database.

It seems the previous replication has set up these system views
SYNC_FCR To GPRPTS_GL00100. And I have tried dropping the replication
module again to see if it drops the views but it didn't.

The replication fails with some wired error & complains about this
views when I try to run the synch..

I even tried running the sp_removedbreplication to drop the
replication module, but the views do not seem to disappear.

My question is how do I remove these system views or how do I make the
replication work without using these views or create new views.. Why
is this creating those system views in the first place?

I would appreciate if anyone can help me fix this issue. Please feel
free to let me know if any additional information or scripts needed.

Thanks in advance..

Regards,
Aravin Rajendra.you should be able to drop them using query analyzer.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

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
"Query Builder" <querybuilder@.gmail.comwrote in message
news:1189702889.303360.189580@.o80g2000hse.googlegr oups.com...

Quote:

Originally Posted by

Hi,
>
I have transactional replication set up on on of our MS SQL 2000 (SP4)
Std Edition database server
>
Because of an unfortunate scenario, I had to restore one of the
publication databases. I scripted the replication module and dropped
the publication first. Then did a full restore.
>
When I try to set up the replication thru the script, it created the
publication with the following error message
>
Server: Msg 2714, Level 16, State 5, Procedure SYNC_FCR To
GPRPTS_GL00100, Line 1
There is already an object named 'SYNC_FCR To GPRPTS_GL00100' in the
database.
>
It seems the previous replication has set up these system views
SYNC_FCR To GPRPTS_GL00100. And I have tried dropping the replication
module again to see if it drops the views but it didn't.
>
The replication fails with some wired error & complains about this
views when I try to run the synch..
>
I even tried running the sp_removedbreplication to drop the
replication module, but the views do not seem to disappear.
>
My question is how do I remove these system views or how do I make the
replication work without using these views or create new views.. Why
is this creating those system views in the first place?
>
I would appreciate if anyone can help me fix this issue. Please feel
free to let me know if any additional information or scripts needed.
>
Thanks in advance..
>
Regards,
Aravin Rajendra.
>

|||Thanks for your response.. I tried dropping it thru QA.. Now the
replication doesn't show up on the publication. But the replication
monitor still has this replication with a failed status....

Can you please point me to the direction on safely removing all
components of a particular replication module (I have other publishers
in this server)..

Thanks again..

Aravin Rajendar.

On Sep 13, 2:37 pm, "Hilary Cotter" <hilary.cot...@.gmail.comwrote:

Quote:

Originally Posted by

you should be able to drop them using query analyzer.
>
--
RelevantNoise.com - dedicated to mining blogs for business intelligence.
>
Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
>
Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com"Query Builder" <querybuil...@.gmail.comwrote in message
>
news:1189702889.303360.189580@.o80g2000hse.googlegr oups.com...
>

Quote:

Originally Posted by

Hi,

>

Quote:

Originally Posted by

I have transactional replication set up on on of our MS SQL 2000 (SP4)
Std Edition database server

>

Quote:

Originally Posted by

Because of an unfortunate scenario, I had to restore one of the
publication databases. I scripted the replication module and dropped
the publication first. Then did a full restore.

>

Quote:

Originally Posted by

When I try to set up the replication thru the script, it created the
publication with the following error message

>

Quote:

Originally Posted by

Server: Msg 2714, Level 16, State 5, Procedure SYNC_FCR To
GPRPTS_GL00100, Line 1
There is already an object named 'SYNC_FCR To GPRPTS_GL00100' in the
database.

>

Quote:

Originally Posted by

It seems the previous replication has set up these system views
SYNC_FCR To GPRPTS_GL00100. And I have tried dropping the replication
module again to see if it drops the views but it didn't.

>

Quote:

Originally Posted by

The replication fails with some wired error & complains about this
views when I try to run the synch..

>

Quote:

Originally Posted by

I even tried running the sp_removedbreplication to drop the
replication module, but the views do not seem to disappear.

>

Quote:

Originally Posted by

My question is how do I remove these system views or how do I make the
replication work without using these views or create new views.. Why
is this creating those system views in the first place?

>

Quote:

Originally Posted by

I would appreciate if anyone can help me fix this issue. Please feel
free to let me know if any additional information or scripts needed.

>

Quote:

Originally Posted by

Thanks in advance..

>

Quote:

Originally Posted by

Regards,
Aravin Rajendra.

Replication in Standard Edition

Hello,
I hope everybody is doing ok.
I'm trying to set up my first "replication". I have the standard edition
of SQL SERVER 2000. While reading the documentation I am trying to identify
the the objects in the Enterprise Manager that the documentation is refering
to. For example Replication Monitor. I don't see this object in my
Enterprise Manager. I am wondering if this is because of the version that I
have, or maybe there is something else that I have to install?
Thank you very much in advance
Marlene A. Roman
Marlene,
the replication monitor is a utility that will appear in EM directly under
the server registration once you have set up a distributor.
There's no need to reregister and the version you have is fine - it appears
on all editions inc Personal Edition which disallows transactional
replication publishing.
HTH,
Paul Ibison
|||the only time it will not appear on a publisher (AFAIK) is when you have a
remote distributor.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23FVSad8KEHA.892@.TK2MSFTNGP09.phx.gbl...
> Marlene,
> the replication monitor is a utility that will appear in EM directly under
> the server registration once you have set up a distributor.
> There's no need to reregister and the version you have is fine - it
appears
> on all editions inc Personal Edition which disallows transactional
> replication publishing.
> HTH,
> Paul Ibison
>