Browse by Tags

Replication Error "memory mapped file read failed"

I was fighting an error that was very rare to appear. I originally put a post on a MS forum http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.replication&tid=57229124-0a5a-4ec3-9055-a06b7869b872&cat=&lang=&cr=&sloc=&p=1 The issue...

Posted to DBA Philosophy (Weblog) by jeffrey yao on 07-02-2008
Table, Column, Replication Dependencies

I was asked yesterday by a co-worker how we can pull dependency information from the database for a given table / column. Having not really looked into this in great detail it took me a few minutes but I found the sys.sys_dependencies catalog view. (The many views that are provided in 2005 have been...

Posted to Theophilus (Weblog) by dbenoit on 06-12-2008
Replication Error "field size too large"

Yesterday, I was fighting with an error I have never seen in the replication and not much info can be obtained via google either. My replication environment is pretty much complex, with multiple pulishers to one single subscriber, and also one publisher to multiple subscribers. But they are all transactional...

Posted to DBA Philosophy (Weblog) by jeffrey yao on 06-03-2008
Snapshots Part 1 Published on SSC

Snapshots Part 1 covers the basics of doing a snapshot regardless of what type of replication is being used. In Part 2 coming up in the next couple weeks I dig a little more into the underlying process - not critical to know but helps dispel the black box syndrome.

Posted to It Depends (Weblog) by Andy Warren on 02-26-2008
Init from Backup Published on SSC

This article shows how to initialize a subscriber from a backup in SQL 2005. It's a niche technique, but it can be a very handy technique for all that. Strangely it's not supported via the UI, you have to add the subscription manually and then everything works normally from there. Heres the link...

Posted to It Depends (Weblog) by Andy Warren on 02-11-2008
SQL Server 2005 Replication bug?

Last week, in our production, we noticed some records are missing in the subscriber side while existing on the publisher side. The detailed issue description can be found at: http://www.mydatabasesupport.com/forums/ms-sqlserver/362107-replicated-commands-not-executed-subscriber-side.html MS online support...

Posted to DBA Philosophy (Weblog) by jeffrey yao on 01-15-2008
Replicate Stored Procedure Execution Published on SSC

Most people 'set it and forget it' when it comes to replication, not realizing that changes to rows on the publisher are applied one row at a time on the subscriber using the system generated procs created on the subscriber. I actually tend to agree with the concept, opting for a vanilla implementation...

Posted to It Depends (Weblog) by Andy Warren on 11-05-2007
Replication Book Review/Intereview Posted on SSC

Book reviews aren't easy and it's always hard to tell if you're telling the reader anything they can't learn from Amazon. The comments on Amazon have to be taken with a grain of salt, as should my review of course. We're in the age of multi author books where multi-author used to...

Posted to It Depends (Weblog) by Andy Warren on 08-17-2007

Page 1 of 1 (8 items)