|
|
|
April 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Best practices for backup and restore of large replicated databases Posted by Vemund Haga at 9/30/2004 3:57:17 PM Hello,
I am working on a project where we have a large database that is replicated.
My task is to create a backup/restore plan for this project.
I know the basics for backup/restore, but are looking for best practices and
experiences from you who have done this already on a large scale.
B...more >>
Do not lock table... Posted by ChrisR at 9/30/2004 2:46:51 PM sql2k sp3
Whats good/ bad to checking/ not checking the "Do not
lock table during snapshot..." button?
TIA, ChrisR...more >>
error subscribing to publication Posted by ranjeet at 9/30/2004 2:03:57 PM Hi All,
[CURRENT SET UP]
I have two SQL 2k Ent servers in two locations.
SVR1 has 2 publications (snapshot and merge) the SVR2 subscribes to.
SVR2 republishes these, so that a number of local MSDE clients can
subscribe to them.
SVR1 also has a number of local MSDE subscribers.
[PROBLEM]...more >>
missing of data in merge replication. Posted by itimilsina NO[at]SPAM savannaenergy.com at 9/30/2004 1:20:22 PM Hi there,
we are using merge replication with anonymous subscribtion.
window 2000, sql 2000 sp3 - server
wind 2000/XP, msde 2000 sp3 - subscriber
Synchronizing data with Active XControl.
we have around 50 subscriber and in our database we are using identity
range management(defult by...more >>
replication without deletes? Posted by Sherpa at 9/30/2004 12:31:51 PM Hello All,
I have a database that is going to be replicated. I need to keep only
about 3 months worth of data but the replicated database needs to keep
about 3 years worth of data for reporting. What's the easiest way to do
this? Is there a way to have replication not replicate the deletes?
I...more >>
Results of Altering Trigger NOT FOR REPLICATION Posted by michelle at 9/30/2004 12:04:21 PM We decided to replicate a database post-design and deployment and have had a
few struggles. The first one was with the numerous foreign key constraints
that were not marked NOT FOR REPLICATION. We altered them and are now not
getting duplicate data errors. I understand that this is b/c certain up...more >>
replication fail Posted by stoitchko at 9/30/2004 10:23:27 AM Hi,
I have establish transactional replication between 2 of
my servers, everything were fine for about 2-3 months but
now it stops
Violation of primary key constraint 'PK-measure'. Cannot
insert duplicate key.
It is also strange how it could happen as I have the same
db constrains on...more >>
Merge SQL 7 to 2000 problem Posted by George Randall at 9/30/2004 9:59:12 AM I am having a problem running a merge replication between
a SQL 7 publisher/distributor and a SQL 2000 subscriber
(push). After the subscription is initialized, the agent
fails with the error "The process could not query row
metadata at the Subscriber." The error details
says "Could not fi...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Add new column in merge replication...HELP Posted by dev-dba in distress on the prod side at 9/30/2004 8:35:03 AM I need to know how to add a new column for the client using Merge
Replication, the book I have is cryptic as all getout.
It looks like I can use sp_repladdcolumn but do I need to shut anything
down, turn anything over, flip anything around...
Thanks in advance....more >>
ErrorFile option Posted by Fausto at 9/30/2004 7:43:05 AM The documentation point out that "distribution agent utility" can accept the
option "-ErrorFile". But the distributor always refuse it. Why?
Thanks
...more >>
dynamic filters causes unwanted deletes at subscriber Posted by Marco Broenink at 9/30/2004 7:35:07 AM I use replication with dynamic filters. In my system it is possible that data
is added to the subscriber that doesnot pass the filter. When replicating,
this data is deleted at the subscriber and added to the publisher.
Why deletes the merge agent data that is not in the scope of the dynamic ...more >>
Changing the value of -ExchangeType . Posted by Ray at 9/29/2004 7:14:12 PM Hi All,
I need to change the value of -ExchageType in a Merge
Publication , How could I make it ?
Thanks in advanced,
Ray....more >>
Problem with identity range Posted by Leila at 9/29/2004 3:57:04 PM Hi,
I have a table that has different owner than DBO. When I include this table
in publication, SQL Server does not allow to enable automatic identity range
for this article.
Any help would be greatly appreciated.
Leila
...more >>
Bidirectional transactional replication question Posted by OJ at 9/29/2004 11:56:55 AM Hi,
I'm confused. I have bidirectional transactional
replication configured between 2 servers (sql server 2000
sp3). Same table is publisher and subscriber on both
servers.
Execution of:
sp_helpsubscription <publication name>
shows that loopback_detection is set to "No" on both
serv...more >>
Reporting Database Posted by csl at 9/29/2004 11:48:07 AM We want to create a reporting database from our OLTP database. We are
thinking to take an initial snapshot and then use transactional replication.
However, we also want to keep the OLTP database with only one year of data.
If after one year, we remove records from OLTP, the transactional
replic...more >>
Changing IP Posted by ndpace NO[at]SPAM att.net at 9/29/2004 11:39:22 AM I am using merge replication with SQL ver 7, on a NT4 box. I need to
move one of seven subscribing servers to a new location which means
changing the IP address. I want to do the move without taking down
replication if possible. My plan is to move the box and change to new
IP address. Then u...more >>
2-way Replication Posted by Samuel at 9/29/2004 10:54:58 AM Hello,
What requirements do i need to setup replication.
I have a sql server running at one location where the most updates occur and
another location where minimum updates occur (mostly read data requests).
The bandwith to connect each other is beneath 512kb.
Thnx
...more >>
process could not execute 'sp_repldone/sp_replcounters.. Another log reader is replicating the db Posted by Combfilter at 9/29/2004 10:31:29 AM Hilary, Paul.
I have read some of your threads on some sites
regarding this. You had suggested that maybe
restarting sql agent/server would resolve this.
I tried that with no luck. I have yet to reboot
the server, because it's in a production
enviroment. I will try that this weekend...more >>
Filter Merge Publication depending on field value Posted by Alfonso at 9/29/2004 10:27:06 AM
Hi All!
I have a Merge Publication of two tables with several subscribers. Now, all
data of two tables are in server and all subscribers. I want to filter data
of one table. This filter depends on value of one field. I need several
subscribers will have rows which "myFilterField=1", others...more >>
Merge Rep errors! Posted by Gene S. at 9/29/2004 9:57:23 AM Hello,
Within a merge replication scenario I keep getting the
error message "The process could not enumerate deletions
at the 'Publisher'". I set the query timeout higher and
keep getting the same error. Can anyone tell me why this
is happening?
Any help would be greatly appreciated!...more >>
sp_MSload_replication_status Posted by larry at 9/29/2004 9:31:41 AM What dB should sp_MSload_replication_status executed in
to fix that pesky red 'X' in replication monitor?...more >>
Subscriber insert problem. Posted by Alex Rybalov at 9/29/2004 8:59:36 AM Hi,
I have transactional replication with queued updating.
When I'm running this function on subscriber:
INSERT INTO matchup_edge
(fk_game_id, offense, defense, coaching, misc,
intangibles, overall, evaluator)
VALUES (1292, - 1, - 1, - 1, - 1, - 1, - 1, 'Covers
Team')
SELECT @@...more >>
Port requirements for SQL Server Agent Posted by Anthony Small at 9/29/2004 8:46:30 AM When replicating across a firewall are there any special considerations that
need to be made for the SQL Server Agent? A colleague mentioned that he saw
some information detailing the configuring of firewall ports for the SQL
Server Agent.
With SQL Server Agent being another client to SQL Ser...more >>
Transactional Replication - Backup Considerations Posted by Roby2222 at 9/29/2004 8:25:01 AM We have a db that we would like to replicate. The plan is to use
transactional replication on this server (db1) and push it to another
server(db2). db1 will be the publisher and the distributor, while db2 will
be the subscriber.
Currently, db1 is not replicated and our backups are setup...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |