NO - please don't :-)
1) - nothing wrong with a Pub (normally - for the most part) - the
problem with many SQL Pub/Sub models (not only when used with UCM but
plenty of other times) - is that sometimes to many bulk updates too
quickly can cause the subscription DB to fall 'out-of-sync' with the
publication - and sometimes must be recreated. There are other ways
other than completely deleting and re-adding the subscription - but in
the case that both DB servers are on the same Local LAN, are NOT in
production, this method becomes a far simpler approach to fixing the
subscription DB.
2) - the Publication has certain tables that are NOT published to the
Sub DB - and therefore don't have a required Column called "ms-trans-
repl" that store the latest value of the replication (to inform SQL
Sub which tables/records need to be pulled from the Pub DB) - and
deleting and recreating the Pub - without knowing which specific
tables need to have those columns - would force you to add those
columns and publish tables not intended to be.
HTH,
Mark Snow
CCIE #14073 (Voice, Security)
CCSI #31583
Senior Technical Instructor - IPexpert, Inc.
A Cisco Learning Partner - We Accept Learning Credits!
Telephone: +1.810.326.1444
Fax: +1.309.413.4097
Mailto: [EMAIL PROTECTED]
IPexpert - The Global Leader in Self-Study, Classroom-Based, Video On
Demand and Audio Certification Training Tools for the Cisco CCIE R&S
Lab, CCIE Security Lab, CCIE Service Provider Lab , CCIE Voice Lab and
CCIE Storage Lab Certifications.
On Feb 22, 2008, at 1:24 PM, Moore, Neil wrote:
Thanks for the quick response Mark. I’ll use local auth from now on
then. It does seem that sometimes you have to shoe-horn in it by
recreating the subscription a couple of times before it takes.
Would we be expected to recreate the publication aswell?
Cheers,
Neil.
From: Mark Snow [mailto:[EMAIL PROTECTED]
Sent: 22 February 2008 18:19
To: Moore, Neil
Cc: [email protected]
Subject: Re: [OSL | CCIE_Voice] SQL replication check\fix Q.
SA user (even though mentioned in that article) is not ever to be
used.
Use local authentication instead - will work every time - even
between boxes.
And yes - SQL replication is broken on all of our Subscribers in
every pod - and that is no accident! :)
It is there as an "inherent troubleshooting" task - which is a
testable 'topic' in the lab - so beware - things may not always be
as they seem on the surface!
HTH,
Mark Snow
CCIE #14073 (Voice, Security)
CCSI #31583
Senior Technical Instructor - IPexpert, Inc.
A Cisco Learning Partner - We Accept Learning Credits!
Telephone: +1.810.326.1444
Fax: +1.309.413.4097
Mailto: [EMAIL PROTECTED]
IPexpert - The Global Leader in Self-Study, Classroom-Based, Video
On Demand and Audio Certification Training Tools for the Cisco CCIE
R&S Lab, CCIE Security Lab, CCIE Service Provider Lab , CCIE Voice
Lab and CCIE Storage Lab Certifications.
On Feb 22, 2008, at 12:38 PM, Moore, Neil wrote:
Hi there folks!
I’m after any thoughts\tips on checking the sql replication’s all
good before you start you lab configs (virtual and real).
My last couple of vrack sessions I’ve had lots of probs with this.
The replication is never setup and running at the start of the vrack
sessions so I update lmhosts (checked the cache is good), check
connectivity etc, and then tried the following procedure:
http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a00801d11a6.shtml
for the sa account pwrd I’m trying cisco and blank, I’ve reset these
on both boxes aswell, same. Seems to me like some sort of
authentication issue.
I’ve even put dblhelper on the box & that can’t sort it & this
always works a treat in the field!!
So I guess my questions are:
What check do you folks do to check the replication (add a dev &
check the device table?)
What procedure do you follow to get the replication up and running
at the start of your vrack sessions (proctorlabs.com)?
Is this a ‘task’ for all proctorlab vrack sessions only? (is this
just a vmare ‘feature’?)
In the real lab would we be expected to do this kind of sql
troubleshooting, reseting sa pwrds, assigning roles etc in SQL?
What am I missing!!?
Any help’d be appreciated.
Cheers,
Neil (UK)
consulting | technology | outsourcing
BT Lynx is a Cisco Systems Gold Certified Partner, Microsoft Gold
Certified Partner and HP Business Partner Select / Authorised
Services Delivery Partner.
Sales Offices: Sheffield, London City
DISCLAIMER:
This message is intended only for the use of the person(s)
('Intended Recipient') to whom it is addressed. It may contain
information, which is privileged and confidential. Accordingly any
dissemination, distribution, copying or other use of this message or
any of its content by any person other than the Intended Recipient
may constitute a breach of civil or criminal law and is strictly
prohibited. If you are not the Intended Recipient, please contact
the sender as soon as possible. Neither BT Lynx or the sender accept
any responsibility for viruses and it is your responsibility to scan
the email and attachments. Any liability arising from any third
party acting on any information contained in this email is hereby
excluded. BT Lynx will hold data provided by you for marketing and
promotional purposes unless otherwise advised.
Please see our Statement of Privacy at http://www.btlynx.com/privacy.asp
BT Lynx Ltd Registered No.2277581 - Registered Office: 3 Midland
Way, Barlborough, Chesterfield, S43 4XA - A BT Group plc company
consulting | technology | outsourcing
BT Lynx is a Cisco Systems Gold Certified Partner, Microsoft Gold
Certified Partner and HP Business Partner Select / Authorised
Services Delivery Partner.
Sales Offices: Sheffield, London City
DISCLAIMER:
This message is intended only for the use of the person(s)
('Intended Recipient') to whom it is addressed. It may contain
information, which is privileged and confidential. Accordingly any
dissemination, distribution, copying or other use of this message or
any of its content by any person other than the Intended Recipient
may constitute a breach of civil or criminal law and is strictly
prohibited. If you are not the Intended Recipient, please contact
the sender as soon as possible. Neither BT Lynx or the sender accept
any responsibility for viruses and it is your responsibility to scan
the email and attachments. Any liability arising from any third
party acting on any information contained in this email is hereby
excluded. BT Lynx will hold data provided by you for marketing and
promotional purposes unless otherwise advised.
Please see our Statement of Privacy at http://www.btlynx.com/privacy.asp
BT Lynx Ltd Registered No.2277581 - Registered Office: 3 Midland
Way, Barlborough, Chesterfield, S43 4XA - A BT Group plc company
