restoring master database

Hi,
the problem I have is that my master database file is corrupted.
Therefore MSSQLSERVER service does not start.
I tried to start it in single user mode, but it still wants to start up the
master database.
I tried to substitute my master database with another one, just to start up
the service, but still have problems. It reads the master database and only
master not other databases.
What exactly to do, that I could restore my backup of master database?
regards,
AndrejDid you start SQL Server using the -m switch?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Andrej Hudoklin" <andrej.hudoklin@.add.si> wrote in message
news:uiWog0gmDHA.3732@.tk2msftngp13.phx.gbl...
> Hi,
> the problem I have is that my master database file is corrupted.
> Therefore MSSQLSERVER service does not start.
> I tried to start it in single user mode, but it still wants to start up the
> master database.
> I tried to substitute my master database with another one, just to start up
> the service, but still have problems. It reads the master database and only
> master not other databases.
> What exactly to do, that I could restore my backup of master database?
>
> regards,
> Andrej
>|||Yes.
I tried to start the service using sqlservr -c -m on the binn directory of
my instance.
But then, if I use osql to connect on, it says that server does not exist or
just to list all the running SQL servers, mine is not among them.
How can I start the service and then restore my backup of master database?
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:ujckL3gmDHA.1656@.tk2msftngp13.phx.gbl...
> Did you start SQL Server using the -m switch?
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Andrej Hudoklin" <andrej.hudoklin@.add.si> wrote in message
> news:uiWog0gmDHA.3732@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > the problem I have is that my master database file is corrupted.
> > Therefore MSSQLSERVER service does not start.
> >
> > I tried to start it in single user mode, but it still wants to start up
the
> > master database.
> > I tried to substitute my master database with another one, just to start
up
> > the service, but still have problems. It reads the master database and
only
> > master not other databases.
> >
> > What exactly to do, that I could restore my backup of master database?
> >
> >
> > regards,
> > Andrej
> >
> >
>|||I've solved my problem.
The thing is if you have corrupted file of master database, the MSSQLSERVER
service wont start.
Then you have a backup but you can not start the service.
Everyone says just start the service in single user mode in command prompt
by using sqlservr.exe and switch -m.
It would be great if that is true.
To start the service you need a good .mdf and .ldf file of master database,
my suggestion is to copy that 2 files from SQL server installation CD.
The try to start the service in single user mode. Still doesn't work. Why?
Becasue it still wants to raise all of your databases. That's why you have
to copy all the rest of files databases from the CD to the path c:\program
files\Microsoft SQL server\MSSQL\Data\
and then you can start the service using file sqlservr.exe in the binn
directory of you SQL servere instance.
use: sqlservr -m
the service will start
open another command prompt window and use osql utilltiy to restore your
backup of master database
then just restart you computer and it should work
Hope that this will help anyone.
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:ujckL3gmDHA.1656@.tk2msftngp13.phx.gbl...
> Did you start SQL Server using the -m switch?
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Andrej Hudoklin" <andrej.hudoklin@.add.si> wrote in message
> news:uiWog0gmDHA.3732@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > the problem I have is that my master database file is corrupted.
> > Therefore MSSQLSERVER service does not start.
> >
> > I tried to start it in single user mode, but it still wants to start up
the
> > master database.
> > I tried to substitute my master database with another one, just to start
up
> > the service, but still have problems. It reads the master database and
only
> > master not other databases.
> >
> > What exactly to do, that I could restore my backup of master database?
> >
> >
> > regards,
> > Andrej
> >
> >
>|||Andrej,
I think Tibor merely missed the part that the master db file is corrupt.
Good to see you post how you fixed the problem.
For anyone interested, there is a section in BOL about this situation.
Search for "Rebuilding the master Database" in BOL.
Quentin
"Andrej Hudoklin" <andrej.hudoklin@.add.si> wrote in message
news:uWURfWjmDHA.3316@.tk2msftngp13.phx.gbl...
> I've solved my problem.
> The thing is if you have corrupted file of master database, the
MSSQLSERVER
> service wont start.
> Then you have a backup but you can not start the service.
> Everyone says just start the service in single user mode in command prompt
> by using sqlservr.exe and switch -m.
> It would be great if that is true.
> To start the service you need a good .mdf and .ldf file of master
database,
> my suggestion is to copy that 2 files from SQL server installation CD.
> The try to start the service in single user mode. Still doesn't work. Why?
> Becasue it still wants to raise all of your databases. That's why you have
> to copy all the rest of files databases from the CD to the path c:\program
> files\Microsoft SQL server\MSSQL\Data\
> and then you can start the service using file sqlservr.exe in the binn
> directory of you SQL servere instance.
> use: sqlservr -m
> the service will start
> open another command prompt window and use osql utilltiy to restore your
> backup of master database
> then just restart you computer and it should work
> Hope that this will help anyone.
>
>
> "Tibor Karaszi"
<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
> wrote in message news:ujckL3gmDHA.1656@.tk2msftngp13.phx.gbl...
> > Did you start SQL Server using the -m switch?
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at:
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> > "Andrej Hudoklin" <andrej.hudoklin@.add.si> wrote in message
> > news:uiWog0gmDHA.3732@.tk2msftngp13.phx.gbl...
> > > Hi,
> > >
> > > the problem I have is that my master database file is corrupted.
> > > Therefore MSSQLSERVER service does not start.
> > >
> > > I tried to start it in single user mode, but it still wants to start
up
> the
> > > master database.
> > > I tried to substitute my master database with another one, just to
start
> up
> > > the service, but still have problems. It reads the master database and
> only
> > > master not other databases.
> > >
> > > What exactly to do, that I could restore my backup of master database?
> > >
> > >
> > > regards,
> > > Andrej
> > >
> > >
> >
> >
>