|
|
|
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 Query notifications and replication Posted by sqlboy2000 at 4/13/2007 12:48:01 PM Anyone using query notifications with replication? We have a replicated db
(transactional one way) and I have to turn service broker on for an app that
will use query notifications and I was wondering what effect that will have
on replication.
Thanks in advance.
...more >>
Executing the snapshot second time Posted by Ravi Lobo at 4/13/2007 8:42:01 AM My understanding about the snapshot is,
1.Snapshot is like a starting point
2.It creates a schema and data files (most of the time)
3.It needs to be re-executed by the end of publication retention period
I have the following clarification,
I have,
Pubsliher SQL2K5
Subscribers anonymous + ...more >>
Sync mirroring - uncommited trans @ primary and dbase efficiency. Posted by Methodology at 4/13/2007 7:32:05 AM Hi
So imagine the scenario - async SQL 2005 mirroring and the mirror server
goes offline. accordingly the transaction log of uncommitted stuff grows on
the primary.
To what extent does this effect the efficency of running queries against the
primary?
Any query will need to check data...more >>
Logreader access violation Posted by sqlnewbie at 4/12/2007 10:56:01 PM Hi everyone,
I am setting up Transaction Replication on a MSSQL 2000 8.0.194. Everything
was going fine until the log reader stopped with a "An access violation
occurred" error.
I tried setting up a publication on another test database on the same server
to make sure the problem was not...more >>
accumulating shapshot folder in repldata Posted by stephanie at 4/12/2007 9:08:03 PM Hi all,
I found that my testing server is accumulating shapshot folder in repldata.
Everytime, we refresh the tables (snapshot publication), a new folder created
without the old folders. And I found that there is at most 1 snapshot
folder remain in production server. Any parameter to adju...more >>
push subscription error Xprepl.dll Posted by mj at 4/12/2007 4:32:19 PM
I used a working publication as a template to create a publication.
Everything was good
I then opened the propeties and added a push subscribtion and
selected execute snapshot immediately.
The merge snapshot agent errored out.
A review of the session shows the following:
connection to p...more >>
Merge snapshot frequency Posted by Ravi Lobo at 4/12/2007 1:22:04 PM I have the following scenario,
1.merge replication with 3000 subscribers
2.I have dynamic publication (NOT dynamic snapshot)
3.we observed that synchronization is slow whenever we do a data import at
the publisher
4.because of this we ran the snapshot agent immediately after the data impor...more >>
Filter records during Transactional Replication. Posted by Query Builder at 4/12/2007 11:09:06 AM Hi All,
I have a table with a column DeletedDate which stores a logical delete
of a record.
I need to set up transactional replication for reporting purposes that
this deleted records should not be replicated to the subscriber. That
is, if i see a value on the DeletedDate, I don't want that...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
merge repl error invalid parameter Posted by jaylou at 4/12/2007 6:54:05 AM I have been having a weird situation with this branches replication lately.
For some reason it was failing due to an invalid object on the Branches
database. I added the objects to the data base and the sync worked fine, but
the step still failed due to "Message The parameter is incorrect. ...more >>
Deadlock Issues When performing reports on subscriber Posted by Larry Herbinaux at 4/11/2007 6:28:01 PM We have transactional replication being performed from our TX Database Server
to our Reporting Database Server. All of our reports are run off of our
Reporting Database Server. We have no queries that are performing Update or
Exclusive locks except for the sp_MS stored procedures being used ...more >>
Merge Replication Status Posted by Brian Bunin at 4/11/2007 4:45:36 PM I'm using sp_replmonitorhelpmergesession to determine the status of
multiple push subscriptions.
When I set the Merge Agent to Slow Link, I get a status of 4 and the
message "No Data needed to be Merged" when there are no changes.
I'd like to get it to return the Status 4 when it's idle...more >>
data update suggestions Posted by Sas at 4/11/2007 8:40:04 AM We have production database (1TB, sql server 2005) and we will receive daily
updates from a vendor. All the updates will be imported in another database
first (source db). What would be the best way to apply the updated
information to the from the source DB to the production DB (example of
u...more >>
merge replication picking up tables not in the articles Posted by jaylou at 4/11/2007 7:18:04 AM I am having a strange issue with my merge repl. I have set my verbose level
to 2 which is the highest, and I see an error on a table that is not in my
articles being published but the repl is failing for it. the table exists in
my centralized database but not in my branch's. I can't find an...more >>
Merge replication over web - compressed snapshot - unable to retreive file Posted by narasimha.gm NO[at]SPAM gmail.com at 4/11/2007 1:31:26 AM
Hi,
I have the following setup Merge replication with Web Synchronization:
Server: SQL Server 2005
Subscriber: SQL Server Express edition
The system uses parametrized filters based on HOST_NAME and I have
selected 'Automatically define a partition and generate a snapshot
when a new subsc...more >>
After restore db, transactional replication can't delete. Posted by Chen at 4/10/2007 2:54:00 PM Hi,
Can someone help me with the following situation?
1) I did dump for database test with transactional replication set up on it,
push data from test to test1 db on the same server.
2) Drop the transactional replication of publication for test database.
3) Drop the subscriber db test1.
4)...more >>
Can I use Merge Replication via Developer Edition to Cluster? Posted by Robert Reist at 4/10/2007 10:20:02 AM I am a DBA in one IT group and we do our development work on the developer
edition of SQL Server 2005 and migrate everything to our SQL Server 2005
cluster for production.
We want to use merge replication between the Developer Edition and the
Cluster but I am being told by the DBA on the cl...more >>
Non-Standard Port Problems Posted by Greg Larsen at 4/9/2007 9:58:00 PM We are moving to SQL Server 2005 and have decided to use a non-standard port
number (port number other than 1433). We also decided to turn off the SQL
Browser Services as well. This was done to enhance security, so now
application need to provide <servername>,<port> number when connecting to...more >>
Backup to Network Posted by John Wright at 4/9/2007 11:30:34 AM We just recently experiences a catastrophic hard drive failure. It is off
right now to the data recovery folks and I hope we get something back. In
the mean time I have been asked to come up with some backup plan. Because
the backups were on the same drive as the database, this is not a goo...more >>
A useable but non-updating subscriber? Posted by Nancy Lytle at 4/9/2007 11:23:18 AM Is there a way in SQL 2005 to be able to use a subscriber to test run data
and not have the updated data sent back to the publisher using any method of
replication? We will have 1 publisher and 2 subscribers (all 2005), and we
would like to use one of the subscribers for running test jobs, wi...more >>
Regarding reinitialize the replication Posted by Iter at 4/9/2007 9:20:02 AM Hi Guys,
I have issue in my replication that there is a duplicate data caused the
primary key confict in the subscribtion, which somebody inserted a row in the
subscription in stead of in the publication. When I tried to fix it and got
message that ask me to reinitialize the replication. Then...more >>
Data Transfer via Email Posted by casy at 4/9/2007 1:04:43 AM Hi,
I have a client that needs to transfer data changes from remote SQL
sites to their HQ central DB. I would prefer to use replication but
unfortunately this is not an option as they only want to use email.
We did a home rolled system about 10 years ago using Access with
custom flags for e...more >>
creating new table in MERGE PUBLICATION Posted by SANJAY PAWAR at 4/9/2007 12:00:00 AM I'm using merge replication with one publisher and 7-8 subscribers @ various
locations.
Everything is running very smoothly using identity seeds.
Now the situation needs to create new table at publisher side.
If i create new table @ publisher side and add it into the subscription,
will it...more >>
Data aggregation, syhcronization, and search Posted by crbd98 NO[at]SPAM yahoo.com at 4/8/2007 9:49:24 PM Hello All,
I know that this problem is not SQL Server specific but I decided to
post it here because it is a problem that I am certain many of you
expericenced (or at least thought about).
In my system, I have a central SQL Server Database and number of
remote "data providers". Some of thes...more >>
When adding encryption Posted by mj at 4/8/2007 6:48:02 AM
I have been asked to encrypt SSN's to a published table.
How do I proceed?...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |