I would look at implementing asynchronous mirroring between your site and your DR site.

The data will be sent to your dr site, but your primary system won't wait...

Thanks for sharing the link and information. Very helpful to have a 1 stop shop for documentation.

If it says failed to update shared features, this is more like BIDS and Management studio right? Should not be as much of a problem?

What is the version number...

Thanks for your feedback! I did have success changing clr_enabled from 1 to 0 and then back 0 to 1. After turning it off, it unloaded the assemblies...

Is it a clustered server? Is it possible the instance was on a different node?

sorry, had some personal things come up and was out for awhile. Will try and look at this later this evening

Can you post the table scripts from publisher and subscriber? Also if you can script out the publication and post that or send it to me that would help...

Sorry, for the delay...

How are you trying to filter out the columns you don't want? Did you uncheck from the article, did you apply a filter and leave all...

Sorry, not sure I understand your question...Are you just wanting to keep from replicating 2 of the columns, or are you trying to implement partitioning on the table as well?

Also,...

Hi

I think you should find out what port your named instance of sql server is running on. If you look in the TCP/IP Properties on configuration manager you should...

Thanks for your help! So you just move the data from the first system table created with the first capture instance into the new 2nd table?