Wednesday, March 21, 2012

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:

No comments:

Post a Comment