Monday, March 26, 2012

RebuildM: Cannot copy file error?

Hi All,
I tried to rebuild my Master data file unsuccessfully. After selecting the
directory where my Master.dbf and .ldf, I clicked on the Rebuild button, and
RebuildM gives me the following error message:
Cannot copy Master: There has been a sharing violation.
The source or destination file may be in use.
I am not so sure which one is source, which one is destination? I tried to
delete and restore the master.ldf and master.mdf files and they are deleted
and restored fine, which means that they are not in use.
What else do I have to do in order to rebuild the master file?Hi, David,
From you information, when you use the rebuildm.exe to rebuild the master
database, you encoutere error message of:
Cannot copy Master: There has been a sharing violation.
The source or destination file may be in use.
Based on my knowledge, The Rebuild Master utility reinstalls the master
database. Rebuilding the master database removes all database objects and
data. After rebuilding the master database, re-create the database objects
and reload the data, or reattach the data and log files using sp_attach_db.
Please refer to the following articles before you run it.
Rebuild master Utility
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp
_rebuildm_6dbt.asp
How to rebuild the master database (Rebuild Master utility)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht
_install_8w8p.asp
You should choose the resorce by click on the browse button and Select the
\Data folder on the SQL Server compact disc or in the shared network
directory from which SQL Server was installed, and then click OK.
Hope this helps.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||H
before use the rebuildm.exe, copy SQL Server install CD to hard disk, and remove Read Only flag from files
JBandi|||Hi, David,
I am reviewing you post. Since we have not heard from you in he newsgroup
for some days, I want to know if you have problem resolved or there is any
question that need our assistance. For any question, please feel free to
post here and we are glad to help. Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

No comments:

Post a Comment