Rebuilding the master Database

I have a copy of SQL Server Express on a clients computer.

When i try & restart the services it fails with the following error:-

Error: 9003, Severity: 20, State1.

It looks like the master database has become corrupt & needs rebuilding.

I have found a utility rebuildm.exe that repairs the master db but unfortunately it is not supported in sql 2005.

Does anyone have any other suggestions on how to repair the master db.

Thanks.

i think this will help u

http://geekswithblogs.net/mskoolaid/archive/2005/12/17/63413.aspx

Madhu

|||

Rebuildm.exe is used in sql 2000 .....i think you can rebuild as below,

copy the sql server express exe file to your local hard disk and then in cmd go to relevant path where the setup file resides and run the below code in command prompt.........

start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword>

This works with sql 2005 and i think it will work with sql express also.........pls correct me if am wrong

Thanxx

Deepak

|||

Thanks for that.

Silly question but will the instance name be master & will the SAPWD be sa also do you think i need to use < > between instancename & sa

Does this look good to you guys.

setup.exe /qn INSTANCENAME=<master> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<sa>

|||

Go to the appropriate path where your sql server setup.exe exist in the command prompt........I assume its in C:\test folder .......then command will be like this,

C:\Test> start /wait \setup.exe /qn INSTANCENAME="SQLEXPRESS" REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD="XXXXX"

SQL Server Express always installs a named instance (SQLExpress) unless you select a default instance.

http://technet.microsoft.com/en-us/library/ms143744.aspx

I am not sure if this is correct just try|||

Thanks guys.

Got it to work.

Respect.

Rebuilding the master Database

I have a copy of SQL Server Express on a clients computer.

When i try & restart the services it fails with the following error:-

Error: 9003, Severity: 20, State1.

It looks like the master database has become corrupt & needs rebuilding.

I have found a utility rebuildm.exe that repairs the master db but unfortunately it is not supported in sql 2005.

Does anyone have any other suggestions on how to repair the master db.

Thanks.

i think this will help u

http://geekswithblogs.net/mskoolaid/archive/2005/12/17/63413.aspx

Madhu

|||

Rebuildm.exe is used in sql 2000 .....i think you can rebuild as below,

copy the sql server express exe file to your local hard disk and then in cmd go to relevant path where the setup file resides and run the below code in command prompt.........

start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword>

This works with sql 2005 and i think it will work with sql express also.........pls correct me if am wrong

Thanxx

Deepak

|||

Thanks for that.

Silly question but will the instance name be master & will the SAPWD be sa also do you think i need to use < > between instancename & sa

Does this look good to you guys.

setup.exe /qn INSTANCENAME=<master> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<sa>

|||

Go to the appropriate path where your sql server setup.exe exist in the command prompt........I assume its in C:\test folder .......then command will be like this,

C:\Test> start /wait \setup.exe /qn INSTANCENAME="SQLEXPRESS" REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD="XXXXX"

SQL Server Express always installs a named instance (SQLExpress) unless you select a default instance.

http://technet.microsoft.com/en-us/library/ms143744.aspx

I am not sure if this is correct just try|||

Thanks guys.

Got it to work.

Respect.

Rebuild Master fails

Hi,
I am trying to test disaster recovery on a test server. I am trying to
create the master as though it has been corrupted. When I run the
Rebuildm.exe, it creates the master.mdf and mastlog.ldf files in the
C:\Program Files\MS SQL SERVER\DATA\MSSQL\Data directory from the
installation CD but it fails with an error -" Rebuild Master failed with
error -1:" and in the windows application event error log it says 17204
:FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL
Server\DATA\MSSQL\data\master.mdf for virtual device number (VDN) 1.
I am not able to start the MSSQLSERVR service. I have tried three times
rebuilding the master but it has failed with the same error. Any help will be
greatly appreciated. Thanks.
Hi,
I looked at the file attributes and unchecked the READ ONLY for the data and
log files for master, model and msdb databases. Now when I start the
MSSQLSERVR service it runs for just 1 - 2 seconds and then it stops. What
might be causing this? Thanks.
"sharman" wrote:

> Hi,
> I am trying to test disaster recovery on a test server. I am trying to
> create the master as though it has been corrupted. When I run the
> Rebuildm.exe, it creates the master.mdf and mastlog.ldf files in the
> C:\Program Files\MS SQL SERVER\DATA\MSSQL\Data directory from the
> installation CD but it fails with an error -" Rebuild Master failed with
> error -1:" and in the windows application event error log it says 17204
> :FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL
> Server\DATA\MSSQL\data\master.mdf for virtual device number (VDN) 1.
> I am not able to start the MSSQLSERVR service. I have tried three times
> rebuilding the master but it has failed with the same error. Any help will be
> greatly appreciated. Thanks.
|||> Now when I start the
> MSSQLSERVR service it runs for just 1 - 2 seconds and then it stops. What
> might be causing this?
Just about anything. Check the errorlog file for error messages.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:1F7F6AB4-A231-4AA3-B4B4-E4807F0E4B7F@.microsoft.com...[vbcol=seagreen]
> Hi,
> I looked at the file attributes and unchecked the READ ONLY for the data and
> log files for master, model and msdb databases. Now when I start the
> MSSQLSERVR service it runs for just 1 - 2 seconds and then it stops. What
> might be causing this? Thanks.
> "sharman" wrote:
|||Hi,
I was able to figure out the reason. The source file location for the mdf
and ldf files was on a CD with the Read Only attribute checked. I copied all
the files to a local disk, unchecked the Read Only attribute and rerun the
rebuildm.exe and it worked this time. This is in Microsoft KB 273572.
"Tibor Karaszi" wrote:

> Just about anything. Check the errorlog file for error messages.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:1F7F6AB4-A231-4AA3-B4B4-E4807F0E4B7F@.microsoft.com...
>

Rebuild Master fails

Hi,
I am trying to test disaster recovery on a test server. I am trying to
create the master as though it has been corrupted. When I run the
Rebuildm.exe, it creates the master.mdf and mastlog.ldf files in the
C:\Program Files\MS SQL SERVER\DATA\MSSQL\Data directory from the
installation CD but it fails with an error -" Rebuild Master failed with
error -1:" and in the windows application event error log it says 17204
:FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL
Server\DATA\MSSQL\data\master.mdf for virtual device number (VDN) 1.
I am not able to start the MSSQLSERVR service. I have tried three times
rebuilding the master but it has failed with the same error. Any help will be
greatly appreciated. Thanks.Hi,
I looked at the file attributes and unchecked the READ ONLY for the data and
log files for master, model and msdb databases. Now when I start the
MSSQLSERVR service it runs for just 1 - 2 seconds and then it stops. What
might be causing this? Thanks.
"sharman" wrote:
> Hi,
> I am trying to test disaster recovery on a test server. I am trying to
> create the master as though it has been corrupted. When I run the
> Rebuildm.exe, it creates the master.mdf and mastlog.ldf files in the
> C:\Program Files\MS SQL SERVER\DATA\MSSQL\Data directory from the
> installation CD but it fails with an error -" Rebuild Master failed with
> error -1:" and in the windows application event error log it says 17204
> :FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL
> Server\DATA\MSSQL\data\master.mdf for virtual device number (VDN) 1.
> I am not able to start the MSSQLSERVR service. I have tried three times
> rebuilding the master but it has failed with the same error. Any help will be
> greatly appreciated. Thanks.|||> Now when I start the
> MSSQLSERVR service it runs for just 1 - 2 seconds and then it stops. What
> might be causing this?
Just about anything. Check the errorlog file for error messages.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:1F7F6AB4-A231-4AA3-B4B4-E4807F0E4B7F@.microsoft.com...
> Hi,
> I looked at the file attributes and unchecked the READ ONLY for the data and
> log files for master, model and msdb databases. Now when I start the
> MSSQLSERVR service it runs for just 1 - 2 seconds and then it stops. What
> might be causing this? Thanks.
> "sharman" wrote:
>> Hi,
>> I am trying to test disaster recovery on a test server. I am trying to
>> create the master as though it has been corrupted. When I run the
>> Rebuildm.exe, it creates the master.mdf and mastlog.ldf files in the
>> C:\Program Files\MS SQL SERVER\DATA\MSSQL\Data directory from the
>> installation CD but it fails with an error -" Rebuild Master failed with
>> error -1:" and in the windows application event error log it says 17204
>> :FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL
>> Server\DATA\MSSQL\data\master.mdf for virtual device number (VDN) 1.
>> I am not able to start the MSSQLSERVR service. I have tried three times
>> rebuilding the master but it has failed with the same error. Any help will be
>> greatly appreciated. Thanks.|||Hi,
I was able to figure out the reason. The source file location for the mdf
and ldf files was on a CD with the Read Only attribute checked. I copied all
the files to a local disk, unchecked the Read Only attribute and rerun the
rebuildm.exe and it worked this time. This is in Microsoft KB 273572.
"Tibor Karaszi" wrote:
> > Now when I start the
> > MSSQLSERVR service it runs for just 1 - 2 seconds and then it stops. What
> > might be causing this?
> Just about anything. Check the errorlog file for error messages.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:1F7F6AB4-A231-4AA3-B4B4-E4807F0E4B7F@.microsoft.com...
> > Hi,
> >
> > I looked at the file attributes and unchecked the READ ONLY for the data and
> > log files for master, model and msdb databases. Now when I start the
> > MSSQLSERVR service it runs for just 1 - 2 seconds and then it stops. What
> > might be causing this? Thanks.
> >
> > "sharman" wrote:
> >
> >> Hi,
> >>
> >> I am trying to test disaster recovery on a test server. I am trying to
> >> create the master as though it has been corrupted. When I run the
> >> Rebuildm.exe, it creates the master.mdf and mastlog.ldf files in the
> >> C:\Program Files\MS SQL SERVER\DATA\MSSQL\Data directory from the
> >> installation CD but it fails with an error -" Rebuild Master failed with
> >> error -1:" and in the windows application event error log it says 17204
> >> :FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL
> >> Server\DATA\MSSQL\data\master.mdf for virtual device number (VDN) 1.
> >>
> >> I am not able to start the MSSQLSERVR service. I have tried three times
> >> rebuilding the master but it has failed with the same error. Any help will be
> >> greatly appreciated. Thanks.
>

Rebuild Master fails

Hi,
I am trying to test disaster recovery on a test server. I am trying to
create the master as though it has been corrupted. When I run the
Rebuildm.exe, it creates the master.mdf and mastlog.ldf files in the
C:\Program Files\MS SQL SERVER\DATA\MSSQL\Data directory from the
installation CD but it fails with an error -" Rebuild Master failed with
error -1:" and in the windows application event error log it says 17204
:FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL
Server\DATA\MSSQL\data\master.mdf for virtual device number (VDN) 1.
I am not able to start the MSSQLSERVR service. I have tried three times
rebuilding the master but it has failed with the same error. Any help will b
e
greatly appreciated. Thanks.Hi,
I looked at the file attributes and unchecked the READ ONLY for the data and
log files for master, model and msdb databases. Now when I start the
MSSQLSERVR service it runs for just 1 - 2 seconds and then it stops. What
might be causing this? Thanks.
"sharman" wrote:

> Hi,
> I am trying to test disaster recovery on a test server. I am trying to
> create the master as though it has been corrupted. When I run the
> Rebuildm.exe, it creates the master.mdf and mastlog.ldf files in the
> C:\Program Files\MS SQL SERVER\DATA\MSSQL\Data directory from the
> installation CD but it fails with an error -" Rebuild Master failed with
> error -1:" and in the windows application event error log it says 17204
> :FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL
> Server\DATA\MSSQL\data\master.mdf for virtual device number (VDN) 1.
> I am not able to start the MSSQLSERVR service. I have tried three times
> rebuilding the master but it has failed with the same error. Any help will
be
> greatly appreciated. Thanks.|||> Now when I start the
> MSSQLSERVR service it runs for just 1 - 2 seconds and then it stops. What
> might be causing this?
Just about anything. Check the errorlog file for error messages.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:1F7F6AB4-A231-4AA3-B4B4-E4807F0E4B7F@.microsoft.com...[vbcol=seagreen]
> Hi,
> I looked at the file attributes and unchecked the READ ONLY for the data a
nd
> log files for master, model and msdb databases. Now when I start the
> MSSQLSERVR service it runs for just 1 - 2 seconds and then it stops. What
> might be causing this? Thanks.
> "sharman" wrote:
>|||Hi,
I was able to figure out the reason. The source file location for the mdf
and ldf files was on a CD with the Read Only attribute checked. I copied all
the files to a local disk, unchecked the Read Only attribute and rerun the
rebuildm.exe and it worked this time. This is in Microsoft KB 273572.
"Tibor Karaszi" wrote:

> Just about anything. Check the errorlog file for error messages.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:1F7F6AB4-A231-4AA3-B4B4-E4807F0E4B7F@.microsoft.com...
>sql

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
> > >
> > >
> >
> >
> >