Below is a slight modification to the How to: Initialize a Transactional Subscription from a Backup steps to handle Publisher database backups to multiple BAK FILES. 1) Execute sp_addpublication (Transact-SQL) at the Publisher on the publication database. Specify a value of true for @allow_initialize_from_backup = N’true’ and @immediate_sync = N’true’ 2) Create a backup of
Read More »
Here is another customer question about Replication I thought worth sharing. I am using SQL Server 2008 64 bits. I have to change the location of the data file (i.e. MDF file). I was planning to detach and attach. DB is also using Transactional Replication so I can’t detach the DB. Is there any way
Read More »
We had this question about SQL 2008 virtual cluster. Question: Is it possible to add node in existing SQL Server 2008 or 2008 R2 Failover cluster instance without downtime (without stopping SQL Server or MSCS services)? Answer: Absolutely! SQL Server 2008 was designed with rolling installation and upgrades in mind. To confirm: I built a
Read More »
Just wanted to give a heads up about a SQL Replication Distribution Agent Latency problem we observed today. The Distribution Agent to 1 subscriber was only delivering about 500 cmds/sec while other subscribers were getting 4000 cmds/sec. We noticed the Distribution Agent was running under a different PacketSize, made that change, no noticeable improvement. While
Read More »
Microsoft SQL Server has the ability to REPLICATE data changes to Oracle. We see more and more customers migrating to SQL Server, then setting up SQL data Replication to move change SQL data back to a legacy Oracle system until the Oracle server is no longer needed. Our customer got this error after setting up
Read More »