all groups > sql server replication > april 2007 > threads for april 22 - 28, 2007
Filter by week: 1 2 3 4 5
Monitor transactional replication.
Posted by Chen at 4/27/2007 11:58:00 AM
Hi,
I want via email to monitor transactional replication status such as still
running, have some problem during retry, or re-initialize, etc. instead of
login to Microsoft SQL Server Management Studio in SQL Server 2005 (SP1). I
think those information should get from msdb, does anyone done ... more >>
SQL 2000 Replication: Could not bulk copy out of table
Posted by Mark Alejandro at 4/26/2007 8:44:03 AM
we are running sql200 and i am trying to do a transactional replication, i
recieve the following error message during snapshot creattion
The process could not bulk copy out of table
'[dbo].[syncobj_0x4336423045343434]'.
The error detail follows:
I/O error (torn page) detected during rea... more >>
How to set up replication from SQL Server 2005 to MySQL through ODBC
Posted by ronald.debruin NO[at]SPAM ecorys.com at 4/26/2007 6:57:28 AM
Hi,
Can anyone please provide me with a step-by-step explanation on how to
replicate data (snapshot replication) from a table in a SQL Server
2005 database to a table in a MySQL database through an ODBC
connection?
I have already created a publication, but have not succeeded in
successfully ... more >>
RowGuid as primary key
Posted by Brian at 4/25/2007 6:52:00 PM
I'm developing on SQL Server 2005 and our application needs to be
'replicable'. I can see how this is done using a RowGuid and marking to be
used for replication, no problem.
My question, however, is if I should make this rowguid column the primary
key in the tables in our database. Will it... more >>
synchronization between latops and a central server
Posted by Pete at 4/25/2007 4:57:57 PM
Hi Guys,
Am very new to replication and would like to request some advice about solving
the following problem. I have a main database running on Sql Server 2005
Standard. A copy of this database is also running on Sql Server 2005 Express
on 3 laptops used by reps in the field. The reps make... more >>
Help please! Ran out of all options on this error
Posted by Tony at 4/25/2007 2:32:03 PM
Hi,
We are in the process of configuration replication for our 64-bit clustered
sql 2000 environment. We run into this very common error, in the first step
itself ('Cofnigure publisher, subscribers and distribution from EM'). At
this point we didn't even select any subscribers. Just conf... more >>
Can the distribution database be moved from once SQL server to another ?
Posted by Yoganarasimha Prasad at 4/25/2007 1:57:10 PM
Hello,
We are decommissioning a cluster and moving all the databases to a new
cluster. The issue is, the distribution database. Is it possible to move the
distribution database without dropping the publications and subscriptions ?
If it is possible, please let me know how to do it.
Thank... more >>
Replicating very large articles but need to avoid locks from snap-
Posted by Cqlboy at 4/25/2007 10:04:04 AM
I have a very large and very active table which I want to replicate to
another server. How can I set-up a Publication for this table and avoid the
locking during the initial snap-shot in SQL 2005? SQL 2000 allowed
configuring replication without generating a snap-shot - assumed data was
al... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Web Synchronization for Merge Replication: No Access to Snapshot Folder
Posted by Urs Laubli at 4/25/2007 12:00:00 AM
Hi
I get the error:
"A failure occurred when accessing 'tabelle1_2.sch' due to an operating
system error [53=''] during Web synchronization. Ensure that the
-InternetLogin user when using basic authentication and the user running
the merge when using Windows integrated authentication has... more >>
Replication Options
Posted by Mrpush at 4/24/2007 12:12:02 PM
Hello,
New to SQL Replication.
Have SQL 2000 and wanted to replicate my business & core databases to a
server at another site to increase availability.
Is SQL replication able to keep my business application running without end
users ever knowing that one of the serves went down or are ... more >>
performance for Replication and trigger
Posted by Iter at 4/24/2007 11:54:02 AM
Hi guys,
I have issue related transaction replication and trigger. In my company, we
have transaction replication and then there are some triggers in the tables
in subscriber server. When the data replicated into table, then fired the
trigger. Recently, it causes performance issue when data b... more >>
Agent is suspect
Posted by mj at 4/24/2007 5:40:00 AM
Any suggests on Agent is suspect error?
MJ... more >>
Cannot find the identity range allocation entry for the Subscriber
Posted by M. M. Ansari at 4/23/2007 11:38:01 PM
Dear All,
When I am synchronizing the merge push subscription, receiving following error
Cannot find the identity range allocation entry for the Subscriber in the
MSmerge_identity_range table. Reinitialize the subscription.
What could be the cause of message, and is there some way so I can ... more >>
merge replication generation problem
Posted by johng NO[at]SPAM garrisonenterprises.net at 4/23/2007 3:17:39 PM
Merge Replication Web Sync - Pull subscriptions
publisher and distributor: SQL Server 2005 X64 build 2221
clients are SQL Express builld 2047
We have 3 of our clients that received the following error at the end
of a merge.
SessionStatistics:
============================
UploadInserts:... more >>
Moving replicated databases
Posted by stevekelley4 NO[at]SPAM gmail.com at 4/23/2007 3:08:36 PM
I have to move a SQL Server 2000 database from drive to another on the
same server because we are running out of space. I know the easiest
way to accomplish this is to detach the database, move the .mdf & .ldf
files, and reattach the database. However, this database is being
replicated, which ... more >>
Replication over Dev Server
Posted by Franck at 4/23/2007 8:37:05 AM
I got 2 servers running, Dev and Production
The Production one is the one that the users run on and it's working
with a Access adp project
The Dev one is the migration project that evolve and use VB as
interface.
So my test are made on the Dev version but, the way it work now is i
copy m... more >>
Snapshot or Transaction which would be faster?
Posted by Greg Larsen at 4/22/2007 9:42:02 AM
I am wondering how to set up replication. Say you have a very slow
connection to a subscriber, so you want to minimize the amount of data piped
across the network. The subscribers only need the data updated once a day.
The publisher and distributor are on the same server, but the subscribe... more >>
|