Viewing 15 posts - 1 through 15 (of 20 total)
More a warning, or cautionary tale, than a question...
Using it on a solution would be fine I guess. As part of a product however I couldn't recommend it. In all...
May 14, 2014 at 6:44 pm
I know you mean well. At one stage I was really excited about SMO, and RMO (the replication management objects library). However, we got so bitten by it.
For starters, the...
May 14, 2014 at 5:24 pm
Heh heh.
So is the SQL 2014 official release an April Fools as well? 🙂
April 1, 2014 at 5:28 pm
Firstly, make sure the snapshot is up to date on the Publisher. You can right click the publication, view snapshot agent status, and run it from there.
As far as the...
January 19, 2014 at 10:43 pm
I'd suggest looking at the replication metadata retention period on the publisher. It defaults to 14 days, but if for some reason you have it as unlimited, the metadata tables...
January 8, 2014 at 7:08 pm
I believe that transactional replication is the only mode that allows peer to peer replication for chaining, but I'm not sure that would give what you are wanting. I don't...
January 8, 2014 at 6:56 pm
Depending on the subscription type, it is likely you will need to execute a stored proc on the subscriber to clean up the metadata there. Eg for merge:
NOTE: These are...
January 8, 2014 at 6:47 pm
Yes, you can replication from a 2012 publication to a 2005 subscriber, so long as the publication is set to have compatibility to 2005 (it will default in the setup...
January 8, 2014 at 6:25 pm
Hmm, I thought (and from experience) that non-clustered indexes are copied by default, but only on setting up subscription. Just now looking at the article options it is showing "copy...
January 8, 2014 at 6:22 pm
mister.magoo (1/8/2014)
Did you notice any difference in the connection settings (e.g. SET ANSI_NULLS etc.?) when you traced the problem?
Good idea. I'll check once I can get access to the client...
January 8, 2014 at 6:16 pm
Another option is if you can use pull replication (the subscriber has to be full SQL, or MSDE 2000, not SQL express).
Basically you create the snapshot, zip the files, and...
January 8, 2014 at 6:14 pm
I am not quite sure, but it sounds like you would want to use Merge replication with possible filters on the articles by "location" or location id. Without seeing the...
January 8, 2014 at 5:59 pm
I've done this a large number of times. There is no "easy way" of doing it with replication in place. Basically the process is:
- Prep the new server for replication...
January 8, 2014 at 5:51 pm
You can manually run and monitor the validation using the replication monitor.
Open the replication monitor
Open the subscription you wish to validate
Chose the menu option "Validate Subscription"
You should probably select...
January 8, 2014 at 5:38 pm
For 2005, with recovery mode in simple, you should be able to just run
BACKUP LOG db_name WITH TRUNCATE_ONLY
DBCC SHRINKFILE (LogicalFileName, Size)
January 8, 2014 at 5:34 pm
Viewing 15 posts - 1 through 15 (of 20 total)