i cannot start sqlserver's service

Hello,
As I wrote in the subject I can't STRAT the MSSQLSERVER.
In Event Viewer, of course there are a lot of errors regarding sql server:
so..:
1. Error: 9003, Severity: 20, State: 1
The LSN (5:321:1) passed to log scan in database 'model' is invalid.
2.19012 :
SuperSocket Info: Bind failed on TCP port 1380.
and when I want to start the service from "Services" I receive an error:
"The MSSQLSERVER service on Local Computer started and then stopped. Some
services stop automatically if they have no work to do, for example, the
Performance Logs and Alerts service"
Then I start the Performance Logs and Alerts service, but i receive the same
error.
Can somebody help me?
Thanks a lot...
AlexSeems you have a problem with your model database. Do you have a backup of model?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
".:alex:." <alex_77ro@.yahoo.com> wrote in message news:OafO9Iu0EHA.1564@.TK2MSFTNGP09.phx.gbl...
> Hello,
> As I wrote in the subject I can't STRAT the MSSQLSERVER.
> In Event Viewer, of course there are a lot of errors regarding sql server:
> so..:
> 1. Error: 9003, Severity: 20, State: 1
> The LSN (5:321:1) passed to log scan in database 'model' is invalid.
> 2.19012 :
> SuperSocket Info: Bind failed on TCP port 1380.
> and when I want to start the service from "Services" I receive an error:
> "The MSSQLSERVER service on Local Computer started and then stopped. Some
> services stop automatically if they have no work to do, for example, the
> Performance Logs and Alerts service"
> Then I start the Performance Logs and Alerts service, but i receive the same
> error.
> Can somebody help me?
> Thanks a lot...
> Alex
>|||No, I haven't a back-up!
What i have to do?
Alex
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e6rw3Yu0EHA.2156@.TK2MSFTNGP10.phx.gbl...
> Seems you have a problem with your model database. Do you have a backup of
model?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> ".:alex:." <alex_77ro@.yahoo.com> wrote in message
news:OafO9Iu0EHA.1564@.TK2MSFTNGP09.phx.gbl...
> > Hello,
> >
> > As I wrote in the subject I can't STRAT the MSSQLSERVER.
> > In Event Viewer, of course there are a lot of errors regarding sql
server:
> > so..:
> > 1. Error: 9003, Severity: 20, State: 1
> > The LSN (5:321:1) passed to log scan in database 'model' is
invalid.
> > 2.19012 :
> > SuperSocket Info: Bind failed on TCP port 1380.
> >
> > and when I want to start the service from "Services" I receive an
error:
> >
> > "The MSSQLSERVER service on Local Computer started and then stopped.
Some
> > services stop automatically if they have no work to do, for example, the
> > Performance Logs and Alerts service"
> >
> > Then I start the Performance Logs and Alerts service, but i receive the
same
> > error.
> >
> > Can somebody help me?
> >
> > Thanks a lot...
> >
> > Alex
> >
> >
>|||Then you most probably have to rebuild your system databases and then restore backup of the master
and msdb databases (as they will be scratched during the rebuild). You perform a rebuild using the
rebuildm.exe program. This is documented in Books Online, so make sure that you read carefully about
how the program work before using it. Also, I assume that you have backups of your user databases,
as these will need to be restored after the rebuild. They might not have to be restored, either if
you first restore a backup of your master database or if you don't have a backup of the master
database, you might be able to attach the user database files, but attaching databases is only
guaranteed to work if you first detached them. If you feel insecure about doing above, I suggest you
open a case with MS and let them help you through this process.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
".:alex:." <alex_77ro@.yahoo.com> wrote in message news:eQtz6hu0EHA.3616@.TK2MSFTNGP11.phx.gbl...
> No, I haven't a back-up!
> What i have to do?
> Alex
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:e6rw3Yu0EHA.2156@.TK2MSFTNGP10.phx.gbl...
> > Seems you have a problem with your model database. Do you have a backup of
> model?
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > ".:alex:." <alex_77ro@.yahoo.com> wrote in message
> news:OafO9Iu0EHA.1564@.TK2MSFTNGP09.phx.gbl...
> > > Hello,
> > >
> > > As I wrote in the subject I can't STRAT the MSSQLSERVER.
> > > In Event Viewer, of course there are a lot of errors regarding sql
> server:
> > > so..:
> > > 1. Error: 9003, Severity: 20, State: 1
> > > The LSN (5:321:1) passed to log scan in database 'model' is
> invalid.
> > > 2.19012 :
> > > SuperSocket Info: Bind failed on TCP port 1380.
> > >
> > > and when I want to start the service from "Services" I receive an
> error:
> > >
> > > "The MSSQLSERVER service on Local Computer started and then stopped.
> Some
> > > services stop automatically if they have no work to do, for example, the
> > > Performance Logs and Alerts service"
> > >
> > > Then I start the Performance Logs and Alerts service, but i receive the
> same
> > > error.
> > >
> > > Can somebody help me?
> > >
> > > Thanks a lot...
> > >
> > > Alex
> > >
> > >
> >
> >
>|||Donne, :-)
all it's ok now
thank you a lot Tibor
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:#7A4clu0EHA.3704@.tk2msftngp13.phx.gbl...
> Then you most probably have to rebuild your system databases and then
restore backup of the master
> and msdb databases (as they will be scratched during the rebuild). You
perform a rebuild using the
> rebuildm.exe program. This is documented in Books Online, so make sure
that you read carefully about
> how the program work before using it. Also, I assume that you have backups
of your user databases,
> as these will need to be restored after the rebuild. They might not have
to be restored, either if
> you first restore a backup of your master database or if you don't have a
backup of the master
> database, you might be able to attach the user database files, but
attaching databases is only
> guaranteed to work if you first detached them. If you feel insecure about
doing above, I suggest you
> open a case with MS and let them help you through this process.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> ".:alex:." <alex_77ro@.yahoo.com> wrote in message
news:eQtz6hu0EHA.3616@.TK2MSFTNGP11.phx.gbl...
> > No, I haven't a back-up!
> > What i have to do?
> >
> > Alex
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> > message news:e6rw3Yu0EHA.2156@.TK2MSFTNGP10.phx.gbl...
> > > Seems you have a problem with your model database. Do you have a
backup of
> > model?
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > http://www.karaszi.com/sqlserver/default.asp
> > > http://www.solidqualitylearning.com/
> > >
> > >
> > > ".:alex:." <alex_77ro@.yahoo.com> wrote in message
> > news:OafO9Iu0EHA.1564@.TK2MSFTNGP09.phx.gbl...
> > > > Hello,
> > > >
> > > > As I wrote in the subject I can't STRAT the MSSQLSERVER.
> > > > In Event Viewer, of course there are a lot of errors regarding sql
> > server:
> > > > so..:
> > > > 1. Error: 9003, Severity: 20, State: 1
> > > > The LSN (5:321:1) passed to log scan in database 'model' is
> > invalid.
> > > > 2.19012 :
> > > > SuperSocket Info: Bind failed on TCP port 1380.
> > > >
> > > > and when I want to start the service from "Services" I receive an
> > error:
> > > >
> > > > "The MSSQLSERVER service on Local Computer started and then stopped.
> > Some
> > > > services stop automatically if they have no work to do, for example,
the
> > > > Performance Logs and Alerts service"
> > > >
> > > > Then I start the Performance Logs and Alerts service, but i receive
the
> > same
> > > > error.
> > > >
> > > > Can somebody help me?
> > > >
> > > > Thanks a lot...
> > > >
> > > > Alex
> > > >
> > > >
> > >
> > >
> >
> >
>|||I'm glad to see it worked out for you. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
".:alex:." <alex_77ro@.yahoo.com> wrote in message news:%23NpiaPv0EHA.3336@.TK2MSFTNGP11.phx.gbl...
> Donne, :-)
> all it's ok now
> thank you a lot Tibor
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:#7A4clu0EHA.3704@.tk2msftngp13.phx.gbl...
> > Then you most probably have to rebuild your system databases and then
> restore backup of the master
> > and msdb databases (as they will be scratched during the rebuild). You
> perform a rebuild using the
> > rebuildm.exe program. This is documented in Books Online, so make sure
> that you read carefully about
> > how the program work before using it. Also, I assume that you have backups
> of your user databases,
> > as these will need to be restored after the rebuild. They might not have
> to be restored, either if
> > you first restore a backup of your master database or if you don't have a
> backup of the master
> > database, you might be able to attach the user database files, but
> attaching databases is only
> > guaranteed to work if you first detached them. If you feel insecure about
> doing above, I suggest you
> > open a case with MS and let them help you through this process.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > ".:alex:." <alex_77ro@.yahoo.com> wrote in message
> news:eQtz6hu0EHA.3616@.TK2MSFTNGP11.phx.gbl...
> > > No, I haven't a back-up!
> > > What i have to do?
> > >
> > > Alex
> > >
> > > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in
> > > message news:e6rw3Yu0EHA.2156@.TK2MSFTNGP10.phx.gbl...
> > > > Seems you have a problem with your model database. Do you have a
> backup of
> > > model?
> > > >
> > > > --
> > > > Tibor Karaszi, SQL Server MVP
> > > > http://www.karaszi.com/sqlserver/default.asp
> > > > http://www.solidqualitylearning.com/
> > > >
> > > >
> > > > ".:alex:." <alex_77ro@.yahoo.com> wrote in message
> > > news:OafO9Iu0EHA.1564@.TK2MSFTNGP09.phx.gbl...
> > > > > Hello,
> > > > >
> > > > > As I wrote in the subject I can't STRAT the MSSQLSERVER.
> > > > > In Event Viewer, of course there are a lot of errors regarding sql
> > > server:
> > > > > so..:
> > > > > 1. Error: 9003, Severity: 20, State: 1
> > > > > The LSN (5:321:1) passed to log scan in database 'model' is
> > > invalid.
> > > > > 2.19012 :
> > > > > SuperSocket Info: Bind failed on TCP port 1380.
> > > > >
> > > > > and when I want to start the service from "Services" I receive an
> > > error:
> > > > >
> > > > > "The MSSQLSERVER service on Local Computer started and then stopped.
> > > Some
> > > > > services stop automatically if they have no work to do, for example,
> the
> > > > > Performance Logs and Alerts service"
> > > > >
> > > > > Then I start the Performance Logs and Alerts service, but i receive
> the
> > > same
> > > > > error.
> > > > >
> > > > > Can somebody help me?
> > > > >
> > > > > Thanks a lot...
> > > > >
> > > > > Alex
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>sql