reposting from Claudia Silva Microsoft SQL Escalation Services United Kingdom http://blogs.technet.com/b/claudia_silva/ Problem: The upload message to be sent to Publisher ‘XXX’ is being generated The merge process is using Exchange ID ‘XXXXX’ for this web synchronization session. No data needed to be merged. Request message generated, now making it ready for upload. Upload request size
Read More »
reposting from Claudia Silva Microsoft SQL Escalation Services United Kingdom http://blogs.technet.com/b/claudia_silva/ PROBLEM: I have a SQL Server 2005 replicating with an Oracle 11 subscriber. After installing the OLEDB driver for Oracle 11, a minidump is created every time the distributor tries to connect to Oracle: Distrib.exe crashes with STACK_OVERFLOW exception. The issue occurs while initializing
Read More »
While assisting a customer with a SQL 2000 Replication configuration on Windows 2003 we need to reference the \ReplData folder as a Driver Letter. With help of Rick Rieser and Ryan Mangipano from Microsoft Windows Support team we had a simple elegant solution; Windows subst command. — Example below creates an alias V: drive to
Read More »
Is your transaction log over 5gb? Have you checked to see how many Virtual Log Files (VLFs) exists in your transaction logs? If not, I would suggest you add to your many list of high priority tasks checks to see how many VLFs exists for your transaction logs. A large number of VLFs are result
Read More »
Error Number: -1073548784 Executing the query “UPDATE STATISTICS [dbo].[***********] WITH FULLSCAN ” failed with the following error: “Could not allocate space for object ‘dbo.SORT temporary run storage: 142101814116352’ in database ‘tempdb’ because the ‘PRIMARY’ filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup,
Read More »