Ian Massi (12/28/2012)
My goal is to get my coworker trained up to handle more of the admin stuff on SQL Server. He's already a great developer on the platform but having someone available to fill in for me when I'm on vacation or just otherwise occupied will make us a more productive team. We started on this back in November and since I'm taking vacation early in the new year, it should help show us where we need to concentrate.Heck, just this morning I was going to modify a replication process and then thought, "Hold on, I'll get him to do this when he's back from vacation next week."
While I totally understand your goal, modifying production replication is not what I would start a "trainee" out on, particularly if they have never admin'd SQL Server before. That's a good way to get your production replication screwed up. I know veteran DBA's that still don't know how to fix replication issues. 😀
"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"