Search Results | SQL Server Performance Forums

Transaction replication with immediate update

Thread by: magictech, Mar 24, 2005, 1 replies, in forum: Performance Tuning for SQL Server Replication

I'm getting the following error message when trying to update the subscriber in a transaction replication with immediate update "Updatable...

MSDTC on server 'servername' is unavailable.

Thread by: magictech, Mar 21, 2005, 2 replies, in forum: Performance Tuning for SQL Server Replication

I'm getting the following error message when testing Transaction replication with immediate update "MSDTC on server 'servername' is unavailable."...

Distributor Agent Stop with this Error Message

Thread by: magictech, Mar 9, 2005, 6 replies, in forum: Performance Tuning for SQL Server Replication

The distributor Agent in one of my replication setup has stop with the following error message "Cannot insert a non-null value into a timestamp...

Using Replication as disaster recovery solution

Thread by: magictech, Mar 1, 2005, 3 replies, in forum: Performance Tuning for SQL Server Replication

We#%92ve been using SQL Server log shipping as part of my disaster recovery strategy for over a year now. A couple of weeks ago we decided to move...

Error while using xp_sendmail and @query

Thread by: magictech, Feb 24, 2005, 3 replies, in forum: General DBA Questions

I'm getting the following error message execute the following sql statement. SQL Statement ---- EXEC xp_sendmail 'rsmith', @query = 'sp_configure'...

Manually synchronize Replication subscriptions

Thread by: magictech, Feb 11, 2005, 5 replies, in forum: Performance Tuning for SQL Server Replication

I've been trying to manually synchronize Replication subscriptions using Backups and restore for a while now and I can't seems to get it right. I...

Log shipping - shrinking log and data file

Thread by: magictech, Dec 21, 2004, 1 replies, in forum: SQL Server Log Shipping

I'm having problem managing log and data file sizes while log shipping is configured and running properly. I have a re-indexing job that runs weekly...

Replication -- Invalid column name 'msrepl_tran_ve

Thread by: magictech, Nov 23, 2004, 1 replies, in forum: Performance Tuning for SQL Server Replication

I'm getting a error message that says "Invalid column name 'msrepl_tran_version'. (Source: bbeddd (Data source); Error number: 207)" when a user...