can't start sql2000, Database 'model' cannot be opened. It is in the middle of a restor

I can't start Sql server 2000, in the event viewer is the folowing message.
Database 'model' cannot be opened. It is in the middle of a restore.
Anyone can help me ?
Pedro MetelloYou can possibly use traceflags 3607, 3608 or 3609 to start model without recovery. However, you
need to search the net for articles describing this. Seems like MS removed these from KB... :-(
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"FRISSUL" <frissul@.frissul.pt> wrote in message news:uw6AaiTnDHA.3504@.TK2MSFTNGP11.phx.gbl...
> I can't start Sql server 2000, in the event viewer is the folowing message.
> Database 'model' cannot be opened. It is in the middle of a restore.
>
> Anyone can help me ?
>
> Pedro Metello
>|||thanks, but when I start with
SQLSERVR -T3609
it says:
"BYPASSING RECOVERY FOR DATABASE 'MODEL' BECAUSE IT IS MARKED IN LOAD"
and then
"Database 'model' cannot be opened. It is in the middle of a restore."
Pedro Metello
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:uQ7fBuTnDHA.3504@.TK2MSFTNGP11.phx.gbl...
> You can possibly use traceflags 3607, 3608 or 3609 to start model without
recovery. However, you
> need to search the net for articles describing this. Seems like MS removed
these from KB... :-(
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "FRISSUL" <frissul@.frissul.pt> wrote in message
news:uw6AaiTnDHA.3504@.TK2MSFTNGP11.phx.gbl...
> > I can't start Sql server 2000, in the event viewer is the folowing
message.
> >
> > Database 'model' cannot be opened. It is in the middle of a restore.
> >
> >
> >
> > Anyone can help me ?
> >
> >
> >
> > Pedro Metello
> >
> >
>|||Too bad. There goes that option. I'm out of ideas. I assume you have searched KB and the archives.
So unless someone else comes up with any ideas, it might be worth opening a case with MS support.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"FRISSUL" <frissul@.frissul.pt> wrote in message news:eZHqd5UnDHA.1740@.TK2MSFTNGP12.phx.gbl...
> thanks, but when I start with
> SQLSERVR -T3609
> it says:
> "BYPASSING RECOVERY FOR DATABASE 'MODEL' BECAUSE IT IS MARKED IN LOAD"
> and then
> "Database 'model' cannot be opened. It is in the middle of a restore."
> Pedro Metello
>
> "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
> wrote in message news:uQ7fBuTnDHA.3504@.TK2MSFTNGP11.phx.gbl...
> > You can possibly use traceflags 3607, 3608 or 3609 to start model without
> recovery. However, you
> > need to search the net for articles describing this. Seems like MS removed
> these from KB... :-(
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at:
> http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> > "FRISSUL" <frissul@.frissul.pt> wrote in message
> news:uw6AaiTnDHA.3504@.TK2MSFTNGP11.phx.gbl...
> > > I can't start Sql server 2000, in the event viewer is the folowing
> message.
> > >
> > > Database 'model' cannot be opened. It is in the middle of a restore.
> > >
> > >
> > >
> > > Anyone can help me ?
> > >
> > >
> > >
> > > Pedro Metello
> > >
> > >
> >
> >
>