Showing posts with label alli. Show all posts
Showing posts with label alli. Show all posts

Friday, March 30, 2012

Replication transcations

Hi All
I had stopped transactional replication for about 5 hours and now i have
restarted it. The replication is so slow. How can i calculate how many
transactions are left to be replicated? Both the log reader and distribution
agent are running although at times they time out.. I have tried to query the
table MSrepl_transcations but nothing makes sense to me.Thank you in advance.
query select * from distribution.dbo.msdistribution_status or execute
sp_browsereplcmds in the distribution 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
"MittyKom" <MittyKom@.discussions.microsoft.com> wrote in message
news:54BB99E9-1F10-4AE4-8747-3B99F27DE83B@.microsoft.com...
> Hi All
> I had stopped transactional replication for about 5 hours and now i have
> restarted it. The replication is so slow. How can i calculate how many
> transactions are left to be replicated? Both the log reader and
distribution
> agent are running although at times they time out.. I have tried to query
the
> table MSrepl_transcations but nothing makes sense to me.Thank you in
advance.

Wednesday, March 28, 2012

replication tables with forign key

Hi all

i have one central site and 7 remote sites, there are one mssqlserver 2k in each sites.
i have to replicate 4 table in one DB(my DB have about 20 tables) in my 8 sites.
this 4 table have forignkey between themselves and other15 tables
i planed to transactional replication but i cant becuse forign keys occure erros
if needed i can send my DB digram to you.

can anyone help me? :confused:

Thanx
M.J.Daneshhttp://www.microsoft.com/technet/prodtechnol/sql/2000/books/c09ppcsq.mspx for reference on configuring Merge/Transactional/snapshot replication types.

Monday, March 26, 2012

replication script

Hi All:
I set up a merge replication on my own local computer and works fine, so i
generated a script and tried to run this script in another computer ,which
already has a replication. (i change the server name before running script)
but still got two errors:
Server: Msg 14099, Level 16, State 1, Procedure sp_adddistributor, Line 72
The server 'repl_distributor' is already defined as a Distributor.
The dependent aliases were mapped to the new database owner.
Database owner changed.
Server: Msg 14074, Level 16, State 1, Procedure sp_adddistpublisher, Line
196
The server 'NICK' is already listed as a Publisher.
but the my replication still works even i got two errors when run script.
so how can i change my script to avoid those two errors when running script?
Cheers
Nick
Nick,
comment out the calls to sp_adddistributor and sp_adddistpublisher.
Rgds,
Paul Ibison
|||Thanks Paul.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:#iJ4CmXCFHA.560@.TK2MSFTNGP15.phx.gbl...
> Nick,
> comment out the calls to sp_adddistributor and sp_adddistpublisher.
> Rgds,
> Paul Ibison
>

Friday, March 9, 2012

Replication of a large database

Hi, all!
I will greatly appreciate if you share your experience of the replication of
large database.
Our production database is over 100 GB. There is transactional replication
of all the tables of the database to another server. The replicated database
on the subscriber is used as failover and for running reports. We run almost
24x7 environment.
There are some database schema changes coming with a new application version
which cause dropping and recreating the publication.
1.Can transactional replication of the large database be settled completely
online with the concurrent snapshot option? Will it cause great amount of
transactions waiting to be delivered? The production database is heavily used.
2.Last time the initial synchronization was running 8 hours. No sync
initialization could be a solution but I found information that it raises
errors creating stored procedures on the subscriber with SP4, and I have SP3
on the publisher and SP4 on the subscriber. Is it better idea to divide
publication of the large database logically in several smaller articles?
3.Because the database is large, I am going to implement partitioning using
partitioned views for historical data archiving. Do you know some tips
concerning transactional replication of partitioned views?
1) Yes it can be done, but I would not recommend it. I would try a backup
restore with a no sync option. Then you have to fix all triggers,
constraints, identity columns, etc.
2) Can you elaborate on this problem? I have not run into it.
3) Indexed Views can be replicated as views or tables. DPV's would typically
reside on your main server. To get them to work correctly you must implement
check constraints, so you would have to make sure that the check constraints
were applied on the subscriber(s).
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
"Elena" <Elena@.discussions.microsoft.com> wrote in message
news:DC26B8CB-34EB-4FCC-A258-DCD7D3064EF7@.microsoft.com...
> Hi, all!
> I will greatly appreciate if you share your experience of the replication
of
> large database.
> Our production database is over 100 GB. There is transactional replication
> of all the tables of the database to another server. The replicated
database
> on the subscriber is used as failover and for running reports. We run
almost
> 24x7 environment.
> There are some database schema changes coming with a new application
version
> which cause dropping and recreating the publication.
> 1.Can transactional replication of the large database be settled
completely
> online with the concurrent snapshot option? Will it cause great amount of
> transactions waiting to be delivered? The production database is heavily
used.
> 2.Last time the initial synchronization was running 8 hours. No sync
> initialization could be a solution but I found information that it raises
> errors creating stored procedures on the subscriber with SP4, and I have
SP3
> on the publisher and SP4 on the subscriber. Is it better idea to divide
> publication of the large database logically in several smaller articles?
> 3.Because the database is large, I am going to implement partitioning
using
> partitioned views for historical data archiving. Do you know some tips
> concerning transactional replication of partitioned views?
|||Thanks for reply, Hilary
2) I am afraid that No sync initialization can cause more problems which can
take longer time to fix
(http://support.microsoft.com/default...b;en-us;827175) than just
initial syncronization.
Also I wonderif it is reasonable to create several small publications on the
logical basis instead of creating one publication of all the tables of the
database. And then if necessary recreate small publication if database schema
changes.
"Hilary Cotter" wrote:

> 1) Yes it can be done, but I would not recommend it. I would try a backup
> restore with a no sync option. Then you have to fix all triggers,
> constraints, identity columns, etc.
> 2) Can you elaborate on this problem? I have not run into it.
> 3) Indexed Views can be replicated as views or tables. DPV's would typically
> reside on your main server. To get them to work correctly you must implement
> check constraints, so you would have to make sure that the check constraints
> were applied on the subscriber(s).
> --
> 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
> "Elena" <Elena@.discussions.microsoft.com> wrote in message
> news:DC26B8CB-34EB-4FCC-A258-DCD7D3064EF7@.microsoft.com...
> of
> database
> almost
> version
> completely
> used.
> SP3
> using
>
>