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 m
odel?
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 sa
me
> 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...
server:[vbcol=seagreen]
invalid.[vbcol=seagreen]
error:[vbcol=seagreen]
Some[vbcol=seagreen]
same[vbcol=seagreen]
>|||Then you most probably have to rebuild your system databases and then restor
e backup of the master
and msdb databases (as they will be scratched during the rebuild). You perfo
rm 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 o
f 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 ba
ckup 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 do
ing 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 i
n
> message news:e6rw3Yu0EHA.2156@.TK2MSFTNGP10.phx.gbl...
> model?
> news:OafO9Iu0EHA.1564@.TK2MSFTNGP09.phx.gbl...
> server:
> invalid.
> error:
> Some
> same
>|||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...
in[vbcol=seagreen]
backup of[vbcol=seagreen]
the[vbcol=seagreen]
the[vbcol=seagreen]
>|||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.g
bl...
> Donne, :-)
> all it's ok now
> thank you a lot Tibor
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:#7A4clu0EHA.3704@.tk2msftngp13.phx.gbl...
> restore backup of the master
> perform a rebuild using the
> that you read carefully about
> of your user databases,
> to be restored, either if
> backup of the master
> attaching databases is only
> doing above, I suggest you
> news:eQtz6hu0EHA.3616@.TK2MSFTNGP11.phx.gbl...
> in
> backup of
> the
> the
>|||Oh, those darned DBAless applications.
We don't need no stinking backups! What's a consistency check?
If you are going to be running a system, do some homework and read up on som
e best practices. For this case, for DBAs.
Proper planning can go a long way to save your butt in a pinch.
Sincerely,
Anthony Thomas
--
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message news:ul1jddv0EHA.1740@.TK2MSFTNGP15.phx.gbl...
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...
> restore backup of the master
> perform a rebuild using the
> that you read carefully about
> of your user databases,
> to be restored, either if
> backup of the master
> attaching databases is only
> doing above, I suggest you
> news:eQtz6hu0EHA.3616@.TK2MSFTNGP11.phx.gbl...
> in
> backup of
> the
> the
>
>