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