help!

We had hard disk failures and had to rebuild drive that
housed master database. Didn't have to reinstall SQL cause
that was on a seperate disk. But SQL won't start, says
message below:
17113 :
initconfig: Error 2(The system cannot find the file
specified.) opening 'f:\MSSQL\data\master.mdf' for
configuration information.
I tried to restore master to its original location but
each restore fails becuase SQL is not online.
I suspect that i'm going to have to reinstall SQL then
replace the master and other databases. Anyone have some
advise to offer?
Is it best to uninstall SQL completely, then reinstall and
overwrite the databases like master, etc?
thanks,You don't have to reinstall. Read about rebuildm.exe in books online. It will give you new system
databases.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"brian" <anonymous@.discussions.microsoft.com> wrote in message
news:056301c3b25b$cbe534b0$a101280a@.phx.gbl...
> We had hard disk failures and had to rebuild drive that
> housed master database. Didn't have to reinstall SQL cause
> that was on a seperate disk. But SQL won't start, says
> message below:
> 17113 :
> initconfig: Error 2(The system cannot find the file
> specified.) opening 'f:\MSSQL\data\master.mdf' for
> configuration information.
>
> I tried to restore master to its original location but
> each restore fails becuase SQL is not online.
> I suspect that i'm going to have to reinstall SQL then
> replace the master and other databases. Anyone have some
> advise to offer?
> Is it best to uninstall SQL completely, then reinstall and
> overwrite the databases like master, etc?
>
> thanks,
>|||thank you for the help. i'll give that a shot.
>--Original Message--
>You don't have to reinstall. Read about rebuildm.exe in
books online. It will give you new system
>databases.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at: http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"brian" <anonymous@.discussions.microsoft.com> wrote in
message
>news:056301c3b25b$cbe534b0$a101280a@.phx.gbl...
>> We had hard disk failures and had to rebuild drive that
>> housed master database. Didn't have to reinstall SQL
cause
>> that was on a seperate disk. But SQL won't start, says
>> message below:
>> 17113 :
>> initconfig: Error 2(The system cannot find the file
>> specified.) opening 'f:\MSSQL\data\master.mdf' for
>> configuration information.
>>
>> I tried to restore master to its original location but
>> each restore fails becuase SQL is not online.
>> I suspect that i'm going to have to reinstall SQL then
>> replace the master and other databases. Anyone have some
>> advise to offer?
>> Is it best to uninstall SQL completely, then reinstall
and
>> overwrite the databases like master, etc?
>>
>> thanks,
>>
>
>.
>