How to move a Published Table to a new File Group

How to move a Published Table to a new File Group Chris Skorlinski Microsoft SQL Server Escalation Services I recently needed to move a Transactional Replicated table to a new File Group.  There are a couple of documented Schema changes that can break Replication. http://msdn.microsoft.com/en-us/library/ms151870(SQL.90).aspx However, I found most problems are solved if I first…


Update Statistics fails with Error Number:–1073548784 "Could not allocate space for object ‘dbo.SORT”

Update Statistics fails with Error Number: –1073548784 “Could not allocate space for object ‘dbo.SORT” Chris Skorlinski Microsoft SQL Server Escalation Services · ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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…


Using Power Shell to script out Replication

Using Power Shell to script out Replication Chris Skorlinski Microsoft SQL Server Escalation Services While troubleshooting customer’s Replication scenarios we often ask for the “script” used to recreate their replication environment.  The BLOG posting below by Chad Miller provides a great example of using Power Shell and Replication Management Objects (RMO) to script out Replication….


Business Scenarios for the Cloud

Note: This article is updated at Benefits of the Cloud for Business Leaders. While putting together lessons learned from our Enterprise Strategy cloud engagements, we consolidated a set of recurring business scenarios and themes.  You may find these useful if you are thinking about cloud opportunities from a business perspective, and are looking for some…


Stop and checked your Virtual Log Files (VLFs)

Stop and checked your Virtual Log Files (VLFs) Chris Skorlinski Microsoft SQL Server Escalation Services 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…


SQLSaturday, Toronto, Sept 17, 2011, check it out!

SQLSaturday, Toronto, Sept 17, 2011, check it out! Chris Skorlinski Microsoft SQL Server Escalation Services If you are in the Toronto area, or can be, on Saturday, Sept 17th, 2011, check out SQLSaturday workshop.  Great opportunity to meet with other SQL professionals and learn from great speakers on a wide variety of topics.  I’ll be…


How to reference a Folder as a Drive Letter

How to reference a Folder as a Drive Letter Chris Skorlinski Microsoft SQL Server Escalation Services 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…


How to run sp_browsereplcmds on a Distribution db backup

How to run sp_browsereplcmds on a Distribution db backup Chris Skorlinski Microsoft SQL Server Escalation Services From time to time we need to restore a customer’s Distribution database to a secondary server or to a lab server for testing.  When you restore a distribution database it will not be configured to execute Replication commands such…


REPLICATION: My distribution agent generates a dump when replicating with my Oracle Subscriber

REPLICATION: My distribution agent generates a dump when replicating with my Oracle Subscriber 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…


Replication: Unable to Synchronize subscribers via Web Synchronization

Replication: Unable to Synchronize subscribers via Web Synchronization 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…