Blending life, nature and technology.
Posts tagged replication
Problems removing a SQL2005 replication publication and subscription
Feb 11th
Issue:
use [MyDB]
exec sp_dropsubscription
@publication = N’pbMyDBSnapshotPull’,
@subscriber = N’YYY\MyDBX’,
@destination_db = N’MyDB’,
@article = N’all’
GO
Result
Msg 20032, Level 16, State 1, Procedure sp_MSdrop_subscription, Line 85
‘YYY\MyDBMOBILE’ is not defined as a Subscriber for ‘YYY\MYDBINSTANCE’.
Msg 14070, Level 16, State 1, Procedure sp_MSrepl_changesubstatus, Line 1210
Could not update the distribution database subscription table. The subscription status could not be changed.
Solution:
use [MyDB]
exec sp_dropsubscription
@publication = N’pbMyDBSnapshotPull’,
@subscriber = N’YYY\MyDBX’,
@destination_db = N’MyDB’,
@article = N’all’,
@ignore_distributor=1 –<<<<<<< *** Fix ************
GO
Result
The Subscriber was dropped.
Microsoft Certified Technology Specialist: Sql Server 2008…
Jun 5th
Passed my Microsoft Cerfification Exam on first attempt on Tuesday June 2nd! Score: 814
The certificate says l’m now recognized as a MCTS – Microsoft Certified Technology Specialist: SQL Server 2008, Implementation and Maintenance. The exam is the MCTS 70-432. Next goal is the 70-450 which has no study book in print, and the only material l can find so far is the CBT-NUGGETS training video on Exam 70-450 which is very good.
Materials l used to study other than multiple SQL Server instances on my laptop, Virtual PC Windows 2008 Machines with SQL Server 2008 installed – for database replication, mirroring and failover clustering practise!!!
- MCTS Self-Paced Training Kit (Exam 70-432): Microsoft® SQL Server® 2008 – Implementation and Maintenance by Mike Hotek (Very good, in-depth all round material, lab oriented book with real life stories). This seems to be the only main book out there.
- Self Test Software for MCTS 70-432, bought the download version of this excellent practise test program.
- Microsoft Sql Server 2008 Books on line (download the latest update from Microsoft)
- Took the official Microsoft 6231 course at SQLSoft (Beaverton)
- Books on Microsoft SQL Server 2005 exam 70-431