Receiving 'PRIMARY KEY constraint 'PK__@snapshot_seqnos' error...

I'm adding a new subscriber to a transactional publication (no snapshot) and
I'm receiving a 'Violation of PRIMARY KEY constraint
'PK__@.snapshot_seqnos__543BF21A'. Cannot insert duplicate key in object
'#5253A9A8'.' error. The subscriber, remote distributor and publisher are all
running SP3.
I did some research and it appears this is fixed in MS03-031:
http://support.microsoft.com/default...b;en-us;813494
Can this be installed just on the distributor w/o affecting the other
systems? We actually have 5 other subscribers and some also publish to other
subscribers and also to other publishers so I don't want to affect any of the
other other servers.
TIA!!
Darin
While I can't comment about your individual case, I find that using
different service pack levels/hotfixes across the computers involved in a
replication topology can give unpredictable results. The recommended upgrade
path does start with the distributor, then publisher then subscriber, but in
your case I'd apply sp4 to all computers (in this order but in one shot)
rather than one by one and running replication inbetween.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Have a look at this post.
http://groups.google.com/group/micro...0?dmode=source
This will fix it. IIRC you will make this change on the distributor.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"DTully" <DTully@.discussions.microsoft.com> wrote in message
news:45B780CE-96CF-45AE-8716-BE22A062C5FE@.microsoft.com...
> I'm adding a new subscriber to a transactional publication (no snapshot)
> and
> I'm receiving a 'Violation of PRIMARY KEY constraint
> 'PK__@.snapshot_seqnos__543BF21A'. Cannot insert duplicate key in object
> '#5253A9A8'.' error. The subscriber, remote distributor and publisher are
> all
> running SP3.
> I did some research and it appears this is fixed in MS03-031:
> http://support.microsoft.com/default...b;en-us;813494
> Can this be installed just on the distributor w/o affecting the other
> systems? We actually have 5 other subscribers and some also publish to
> other
> subscribers and also to other publishers so I don't want to affect any of
> the
> other other servers.
> TIA!!
> Darin

Rebuild master db of SQL 2000 fails with sharing violation

Hi,
Can't see why there's a sharing violation.
MSSQLSERVER service is stopped, as is SQLSERVERAGENT
I've not got any open windows viewing this dir.
The data is on hard disk and not marked read only.
What else could it be?
Thanks
Martin
Hi,
Can you rebuild the master database based on the steps mentioned in the
below article.
http://www.dbarecovery.com/restoremasterdb.html
Thanks
Hari
MCDBA
"Martin" <x@.y.z> wrote in message
news:#SddJUZaEHA.384@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can't see why there's a sharing violation.
> MSSQLSERVER service is stopped, as is SQLSERVERAGENT
> I've not got any open windows viewing this dir.
> The data is on hard disk and not marked read only.
> What else could it be?
> Thanks
> Martin
>
|||Hello-
I'm experiencing a similar problem. "Cannot copy master. There has been a sharing violation. The source or destination file may be in use. Rebuild master failed with error 266: The copy functions cannot be used" ... when attempting to Rebuild with the
Rebuild Master Utility. The data files have been copied from CD-ROM and the Read-Only attribute has been removed. I still get the error. The work around posted as MS Knowledge Base Article 238678 RebuildM Cannot Find Original Master Database Files for
MSDE Installation does not work either. It suggests running msdex86 ... which isn't recognized. Any help would be much appreciated!
"Hari Prasad" wrote:

> Hi,
> Can you rebuild the master database based on the steps mentioned in the
> below article.
> http://www.dbarecovery.com/restoremasterdb.html
> --
> Thanks
> Hari
> MCDBA
> "Martin" <x@.y.z> wrote in message
> news:#SddJUZaEHA.384@.TK2MSFTNGP10.phx.gbl...
>
>
|||Moved the data files to a different directory and now the Rebuild works. Hmmmm...
"bulld0g77" wrote:

> Hello-
> I'm experiencing a similar problem. "Cannot copy master. There has been a sharing violation. The source or destination file may be in use. Rebuild master failed with error 266: The copy functions cannot be used" ... when attempting to Rebuild with t
he Rebuild Master Utility. The data files have been copied from CD-ROM and the Read-Only attribute has been removed. I still get the error. The work around posted as MS Knowledge Base Article 238678 RebuildM Cannot Find Original Master Database Files f
or MSDE Installation does not work either. It suggests running msdex86 ... which isn't recognized. Any help would be much appreciated![vbcol=seagreen]
> "Hari Prasad" wrote:

Rebuild master db of SQL 2000 fails with sharing violation

Hi,
Can't see why there's a sharing violation.
MSSQLSERVER service is stopped, as is SQLSERVERAGENT
I've not got any open windows viewing this dir.
The data is on hard disk and not marked read only.
What else could it be?
Thanks
MartinHi,
Can you rebuild the master database based on the steps mentioned in the
below article.
http://www.dbarecovery.com/restoremasterdb.html
Thanks
Hari
MCDBA
"Martin" <x@.y.z> wrote in message
news:#SddJUZaEHA.384@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can't see why there's a sharing violation.
> MSSQLSERVER service is stopped, as is SQLSERVERAGENT
> I've not got any open windows viewing this dir.
> The data is on hard disk and not marked read only.
> What else could it be?
> Thanks
> Martin
>|||Hello-
I'm experiencing a similar problem. "Cannot copy master. There has been a
sharing violation. The source or destination file may be in use. Rebuild m
aster failed with error 266: The copy functions cannot be used" ... when att
empting to Rebuild with the
Rebuild Master Utility. The data files have been copied from CD-ROM and the
Read-Only attribute has been removed. I still get the error. The work aro
und posted as MS Knowledge Base Article 238678 RebuildM Cannot Find Original
Master Database Files for
MSDE Installation does not work either. It suggests running msdex86 ... whi
ch isn't recognized. Any help would be much appreciated!
"Hari Prasad" wrote:

> Hi,
> Can you rebuild the master database based on the steps mentioned in the
> below article.
> http://www.dbarecovery.com/restoremasterdb.html
> --
> Thanks
> Hari
> MCDBA
> "Martin" <x@.y.z> wrote in message
> news:#SddJUZaEHA.384@.TK2MSFTNGP10.phx.gbl...
>
>|||Moved the data files to a different directory and now the Rebuild works. H
mmmm...
"bulld0g77" wrote:

> Hello-
> I'm experiencing a similar problem. "Cannot copy master. There has been a sharin
g violation. The source or destination file may be in use. Rebuild master failed w
ith error 266: The copy functions cannot be used" ... when attempting to Rebuild wit
h t
he Rebuild Master Utility. The data files have been copied from CD-ROM and
the Read-Only attribute has been removed. I still get the error. The work
around posted as MS Knowledge Base Article 238678 RebuildM Cannot Find Origi
nal Master Database Files f
or MSDE Installation does not work either. It suggests running msdex86 ... which isn't reco
gnized. Any help would be much appreciated![vbcol=seagreen]
> "Hari Prasad" wrote:
>

Rebuild master db of SQL 2000 fails with sharing violation

Hi,
Can't see why there's a sharing violation.
MSSQLSERVER service is stopped, as is SQLSERVERAGENT
I've not got any open windows viewing this dir.
The data is on hard disk and not marked read only.
What else could it be?
Thanks
MartinHi,
Can you rebuild the master database based on the steps mentioned in the
below article.
http://www.dbarecovery.com/restoremasterdb.html
--
Thanks
Hari
MCDBA
"Martin" <x@.y.z> wrote in message
news:#SddJUZaEHA.384@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can't see why there's a sharing violation.
> MSSQLSERVER service is stopped, as is SQLSERVERAGENT
> I've not got any open windows viewing this dir.
> The data is on hard disk and not marked read only.
> What else could it be?
> Thanks
> Martin
>|||Hello-
I'm experiencing a similar problem. "Cannot copy master. There has been a sharing violation. The source or destination file may be in use. Rebuild master failed with error 266: The copy functions cannot be used" ... when attempting to Rebuild with the Rebuild Master Utility. The data files have been copied from CD-ROM and the Read-Only attribute has been removed. I still get the error. The work around posted as MS Knowledge Base Article 238678 RebuildM Cannot Find Original Master Database Files for MSDE Installation does not work either. It suggests running msdex86 ... which isn't recognized. Any help would be much appreciated!
"Hari Prasad" wrote:
> Hi,
> Can you rebuild the master database based on the steps mentioned in the
> below article.
> http://www.dbarecovery.com/restoremasterdb.html
> --
> Thanks
> Hari
> MCDBA
> "Martin" <x@.y.z> wrote in message
> news:#SddJUZaEHA.384@.TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > Can't see why there's a sharing violation.
> >
> > MSSQLSERVER service is stopped, as is SQLSERVERAGENT
> >
> > I've not got any open windows viewing this dir.
> > The data is on hard disk and not marked read only.
> >
> > What else could it be?
> >
> > Thanks
> > Martin
> >
> >
>
>|||Moved the data files to a different directory and now the Rebuild works. Hmmmm...
"bulld0g77" wrote:
> Hello-
> I'm experiencing a similar problem. "Cannot copy master. There has been a sharing violation. The source or destination file may be in use. Rebuild master failed with error 266: The copy functions cannot be used" ... when attempting to Rebuild with the Rebuild Master Utility. The data files have been copied from CD-ROM and the Read-Only attribute has been removed. I still get the error. The work around posted as MS Knowledge Base Article 238678 RebuildM Cannot Find Original Master Database Files for MSDE Installation does not work either. It suggests running msdex86 ... which isn't recognized. Any help would be much appreciated!
> "Hari Prasad" wrote:
> > Hi,
> >
> > Can you rebuild the master database based on the steps mentioned in the
> > below article.
> >
> > http://www.dbarecovery.com/restoremasterdb.html
> >
> > --
> > Thanks
> > Hari
> > MCDBA
> >
> > "Martin" <x@.y.z> wrote in message
> > news:#SddJUZaEHA.384@.TK2MSFTNGP10.phx.gbl...
> > > Hi,
> > >
> > > Can't see why there's a sharing violation.
> > >
> > > MSSQLSERVER service is stopped, as is SQLSERVERAGENT
> > >
> > > I've not got any open windows viewing this dir.
> > > The data is on hard disk and not marked read only.
> > >
> > > What else could it be?
> > >
> > > Thanks
> > > Martin
> > >
> > >
> >
> >
> >