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
Showing posts with label event. Show all posts
Showing posts with label event. Show all posts
Wednesday, March 21, 2012
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
>
>
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
>
>
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...
Alex
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
>
|||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...[vbcol=seagreen]
server:[vbcol=seagreen]
invalid.[vbcol=seagreen]
error:[vbcol=seagreen]
Some[vbcol=seagreen]
same
>
|||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...
> 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...[vbcol=seagreen]
in[vbcol=seagreen]
backup of[vbcol=seagreen]
the[vbcol=seagreen]
the
>
|||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
>
|||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 some 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 in 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
>
>
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
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
>
|||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...[vbcol=seagreen]
server:[vbcol=seagreen]
invalid.[vbcol=seagreen]
error:[vbcol=seagreen]
Some[vbcol=seagreen]
same
>
|||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...
> 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...[vbcol=seagreen]
in[vbcol=seagreen]
backup of[vbcol=seagreen]
the[vbcol=seagreen]
the
>
|||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
>
|||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 some 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 in 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
>
>
Monday, March 19, 2012
i can start my sql server!
i start server and the server down at once.
i don't know what the matter?
event id:17055
17310:
FRunCM: process 2784 happen seriously abnormal c0000005
EXCEPTION_ACCESS_VIOLATION¡£SQL Server termination process¡£Maybe this article can help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;814572.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"ivan À×ÃùÌÎ" <ivan.lei@.matetek.com> wrote in message
news:e1kvjQ%23tEHA.2316@.TK2MSFTNGP12.phx.gbl...
> i start server and the server down at once.
> i don't know what the matter?
> event id:17055
> 17310:
> FRunCM: process 2784 happen seriously abnormal c0000005
> EXCEPTION_ACCESS_VIOLATION¡£SQL Server termination process¡£
>|||i try it .but it also. has any matter?
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> дÈëÏûÏ¢ÐÂ
ÎÅ:ewZdJEAuEHA.3392@.TK2MSFTNGP10.phx.gbl...
> Maybe this article can help:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;814572.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "ivan À×ÃùÌÎ" <ivan.lei@.matetek.com> wrote in message
> news:e1kvjQ%23tEHA.2316@.TK2MSFTNGP12.phx.gbl...
> > i start server and the server down at once.
> >
> > i don't know what the matter?
> >
> > event id:17055
> >
> > 17310:
> > FRunCM: process 2784 happen seriously abnormal c0000005
> > EXCEPTION_ACCESS_VIOLATION¡£SQL Server termination process¡£
> >
> >
>|||The article I mentioned is just one of many articles on the EAV on MS site -
check
http://search.microsoft.com/search/results.aspx?st=b&na=88&View=en-us&qu=c0000005+EXCEPTION_ACCESS_VIOLATION.
Check which one ressembles your problem the most. You will have to check the
problem in some more details.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"ivan À×ÃùÌÎ" <ivan.lei@.matetek.com> wrote in message
news:%23NYTJVBuEHA.2808@.TK2MSFTNGP14.phx.gbl...
> i try it .but it also. has any matter?
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si>
дÈëÏûÏ¢ÐÂ
> ÎÅ:ewZdJEAuEHA.3392@.TK2MSFTNGP10.phx.gbl...
> > Maybe this article can help:
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;814572.
> >
> > --
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > www.SolidQualityLearning.com
> >
> > "ivan À×ÃùÌÎ" <ivan.lei@.matetek.com> wrote in message
> > news:e1kvjQ%23tEHA.2316@.TK2MSFTNGP12.phx.gbl...
> > > i start server and the server down at once.
> > >
> > > i don't know what the matter?
> > >
> > > event id:17055
> > >
> > > 17310:
> > > FRunCM: process 2784 happen seriously abnormal c0000005
> > > EXCEPTION_ACCESS_VIOLATION¡£SQL Server termination process¡£
> > >
> > >
> >
> >
>|||you can try starting from command line to see errors as they happen.
Go to command promt and CD to from drive where sql was installed)
issue the following, replacing appropriate drive/filepath as needed:
sqlservr -dc:\mssql\data\master.mdf -lc:\mssql\data\mastlog.ldf
-ec:\mssql\log\ERRORLOG (return)
If it starts successfully, you probably have an error in your startup
parameters and can use EM (don't close cmd window) to fix. Otherwise, you
may see errors you might not otherwise have.
Or you can look at the registry to determine if you have an error in your
startup parmeters
"ivan ���ù��" wrote:
> i start server and the server down at once.
> i don't know what the matter?
> event id:17055
> 17310:
> FRunCM: process 2784 happen seriously abnormal c0000005
> EXCEPTION_ACCESS_VIOLATION¡£SQL Server termination process¡£
>
>
i don't know what the matter?
event id:17055
17310:
FRunCM: process 2784 happen seriously abnormal c0000005
EXCEPTION_ACCESS_VIOLATION¡£SQL Server termination process¡£Maybe this article can help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;814572.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"ivan À×ÃùÌÎ" <ivan.lei@.matetek.com> wrote in message
news:e1kvjQ%23tEHA.2316@.TK2MSFTNGP12.phx.gbl...
> i start server and the server down at once.
> i don't know what the matter?
> event id:17055
> 17310:
> FRunCM: process 2784 happen seriously abnormal c0000005
> EXCEPTION_ACCESS_VIOLATION¡£SQL Server termination process¡£
>|||i try it .but it also. has any matter?
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> дÈëÏûÏ¢ÐÂ
ÎÅ:ewZdJEAuEHA.3392@.TK2MSFTNGP10.phx.gbl...
> Maybe this article can help:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;814572.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "ivan À×ÃùÌÎ" <ivan.lei@.matetek.com> wrote in message
> news:e1kvjQ%23tEHA.2316@.TK2MSFTNGP12.phx.gbl...
> > i start server and the server down at once.
> >
> > i don't know what the matter?
> >
> > event id:17055
> >
> > 17310:
> > FRunCM: process 2784 happen seriously abnormal c0000005
> > EXCEPTION_ACCESS_VIOLATION¡£SQL Server termination process¡£
> >
> >
>|||The article I mentioned is just one of many articles on the EAV on MS site -
check
http://search.microsoft.com/search/results.aspx?st=b&na=88&View=en-us&qu=c0000005+EXCEPTION_ACCESS_VIOLATION.
Check which one ressembles your problem the most. You will have to check the
problem in some more details.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"ivan À×ÃùÌÎ" <ivan.lei@.matetek.com> wrote in message
news:%23NYTJVBuEHA.2808@.TK2MSFTNGP14.phx.gbl...
> i try it .but it also. has any matter?
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si>
дÈëÏûÏ¢ÐÂ
> ÎÅ:ewZdJEAuEHA.3392@.TK2MSFTNGP10.phx.gbl...
> > Maybe this article can help:
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;814572.
> >
> > --
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > www.SolidQualityLearning.com
> >
> > "ivan À×ÃùÌÎ" <ivan.lei@.matetek.com> wrote in message
> > news:e1kvjQ%23tEHA.2316@.TK2MSFTNGP12.phx.gbl...
> > > i start server and the server down at once.
> > >
> > > i don't know what the matter?
> > >
> > > event id:17055
> > >
> > > 17310:
> > > FRunCM: process 2784 happen seriously abnormal c0000005
> > > EXCEPTION_ACCESS_VIOLATION¡£SQL Server termination process¡£
> > >
> > >
> >
> >
>|||you can try starting from command line to see errors as they happen.
Go to command promt and CD to from drive where sql was installed)
issue the following, replacing appropriate drive/filepath as needed:
sqlservr -dc:\mssql\data\master.mdf -lc:\mssql\data\mastlog.ldf
-ec:\mssql\log\ERRORLOG (return)
If it starts successfully, you probably have an error in your startup
parameters and can use EM (don't close cmd window) to fix. Otherwise, you
may see errors you might not otherwise have.
Or you can look at the registry to determine if you have an error in your
startup parmeters
"ivan ���ù��" wrote:
> i start server and the server down at once.
> i don't know what the matter?
> event id:17055
> 17310:
> FRunCM: process 2784 happen seriously abnormal c0000005
> EXCEPTION_ACCESS_VIOLATION¡£SQL Server termination process¡£
>
>
Subscribe to:
Posts (Atom)