Description:
Microsoft SQL Server newsgroup.
|
|
|
Need to relocate Merge Publication DB to a new server.
|
| |
I have a number of merge publications on my 2005 DB with SP2. The server is currently located in our office and I am in the process of setting up servers in off-site facility. I cannot move the existing server to the new facility. Is there any way of doing a backup and then restore to the new servers and... more »
|
|
|
Howto find the Name of Logreader and Distribution Task
|
| |
Hi NG, MSSQL2k8 Transactional Replication How can I find with T-SQL for a known publication the name or ID of the related task for logreader-task, snapshot-task and distribution task, if the task was manually renamed. Thanks in advanced. Thomas
|
|
|
replication from backup file
|
| |
hi, how do this, i have server a and server b, a is publication adn b is subscription, i only select some tables to sync, but other no-selected tables may have some updates in server a. what is the good way to have complete server b sync with server a? backup data in server a every week and reintial server b... more »
|
|
|
A workaround for SS 2005 Replication with Partition Switch feature
|
| |
Hello there, Actually, subject tells almost everything. We have a database which is > 1TB in size and we use Partition Switch feature for some tables for archiving purposes. Now we would like to use a TDM application which is called (Oracle) Golden Gate with this prod system so that we would use another server as a reporting... more »
|
|
|
a table trigger and merge replication and nullable columns
|
| |
We're using merge replication, and there are triggers on tables in other databases that update a replicated table. There is an after insert trigger on 1 table, which updates values of several columns in a replicated table. It seems that when the trigger fires and updates columns to the replicated table, the columns that are updated to NULL... more »
|
|
|
euro symbol not replicating properly from oracle to sqlserver
|
| |
Hi, I have a problem regarding euro symbol (?) replication from Oracle to SQLserver2005. At oracle side we have a column containing ? (euro symbol). which is being replicated to sql server. The select statment for that column displays that symbol as (?) question mark. The column at oracle is varchar(512) and at sqlserver side is nvarchar(512)... more »
|
|
|
update-update conflict on same node
|
| |
Dear all I have spent quite a day or so dealing with an issue that I can make little sense of, I hope that someone has had a similar experience and can share some knowledge? I have peer-peer replication with 2 nodes. Updates are done on node 1 only. I have a conflict that appears when I update a value in a column for a... more »
|
|
|
can delete publication
|
| |
Hi, when trying to delete a publication, error: could not delete publication '\publicationname' Addition information: An exception occurred while executing a Transact-SQL statement or batch. cannot execute as the database pricipal becausae the pricipal 'dbo' does not exist, this type of changed database content to 'publicationname'.... more »
|
|
|
Transactional Replication Never Clearing Distribution Database
|
| |
We have multiple instances of transactional replication. (All using the same publisher/distributor, with various subscribers.) There are three versions, one goes to two subscribers, the other two each go to one subscriber. There are also three snapshot replications configured, although they haven't been... more »
|
|
|
|
