Help-Recovering SQL 2000 Database.

Hi Vyas,
Sorry for the late reply,
The error log just says the below and halts at the last step.
2004-09-13 17:09:54.39 spid11 Starting up database 'jennifertest'.
2004-09-13 17:10:02.75 spid3 Recovery complete.
2004-09-13 17:10:02.75 spid3 SQL global counter collection task is
created.
Do you want any other file like SQLDump?
TIA
--
Santosh
Can you check the SQL Server error log and post the error messages here? You
will find the log in MSSQL\Log folder under the installation path.
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Santosh" <santoshNoSpam@.NoSpam.net> wrote in message
news:eHXmsUcmEHA.3352@.TK2MSFTNGP10.phx.gbl...
> Friends,
>
> The SQL server 2000 was running fine until all of a Sudden I got this
> message,
>
> SQL Server is aborting. Fatal exception c0000005 caught.
>
> The Service would not start, and I need help in Recovering it.
>
> Any help is greatly Appreciated.
>
> --
>
> Santosh
>
>The messages you posted indicate that the SQL Server is probably running
fine. Is that the case, or are you still not able to start your SQL Server?
What happens when you try to start your MSSQLServer service from the
services applet?
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Santosh" <santoshNoSpam@.NoSpam.net> wrote in message
news:%23cqNlEnmEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Hi Vyas,
> Sorry for the late reply,
> The error log just says the below and halts at the last step.
> 2004-09-13 17:09:54.39 spid11 Starting up database 'jennifertest'.
> 2004-09-13 17:10:02.75 spid3 Recovery complete.
> 2004-09-13 17:10:02.75 spid3 SQL global counter collection task is
> created.
> Do you want any other file like SQLDump?
> TIA
> --
> Santosh
> Can you check the SQL Server error log and post the error messages here?
You
> will find the log in MSSQL\Log folder under the installation path.
> --
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "Santosh" <santoshNoSpam@.NoSpam.net> wrote in message
> news:eHXmsUcmEHA.3352@.TK2MSFTNGP10.phx.gbl...
> > Friends,
> >
> > The SQL server 2000 was running fine until all of a Sudden I got this
> > message,
> >
> > SQL Server is aborting. Fatal exception c0000005 caught.
> >
> > The Service would not start, and I need help in Recovering it.
> >
> > Any help is greatly Appreciated.
> >
> > --
> >
> > Santosh
> >
> >
>
>|||When I try from the Services I get an error saying the Services Could not be
started, and the SQL server does not start at all.
Also I am not able to connect to the Database via Enterprise Manager.
Currently I have shut down the server, but I remember getting a message
something like "c000005 Dump".
--
Santosh
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:OwbAc3nmEHA.1136@.TK2MSFTNGP10.phx.gbl...
> The messages you posted indicate that the SQL Server is probably running
> fine. Is that the case, or are you still not able to start your SQL
> Server?
> What happens when you try to start your MSSQLServer service from the
> services applet?
> --
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "Santosh" <santoshNoSpam@.NoSpam.net> wrote in message
> news:%23cqNlEnmEHA.1656@.TK2MSFTNGP09.phx.gbl...
>> Hi Vyas,
>> Sorry for the late reply,
>> The error log just says the below and halts at the last step.
>> 2004-09-13 17:09:54.39 spid11 Starting up database 'jennifertest'.
>> 2004-09-13 17:10:02.75 spid3 Recovery complete.
>> 2004-09-13 17:10:02.75 spid3 SQL global counter collection task is
>> created.
>> Do you want any other file like SQLDump?
>> TIA
>> --
>> Santosh
>> Can you check the SQL Server error log and post the error messages here?
> You
>> will find the log in MSSQL\Log folder under the installation path.
>> --
>> Vyas, MVP (SQL Server)
>> http://vyaskn.tripod.com/
>>
>> "Santosh" <santoshNoSpam@.NoSpam.net> wrote in message
>> news:eHXmsUcmEHA.3352@.TK2MSFTNGP10.phx.gbl...
>> > Friends,
>> >
>> > The SQL server 2000 was running fine until all of a Sudden I got this
>> > message,
>> >
>> > SQL Server is aborting. Fatal exception c0000005 caught.
>> >
>> > The Service would not start, and I need help in Recovering it.
>> >
>> > Any help is greatly Appreciated.
>> >
>> > --
>> >
>> > Santosh
>> >
>> >
>>
>>
>|||>> something like "c000005 Dump".
That indicates an Access Violation, and all AVs are bugs. So I suggest you
open a case with Microsoft. They will refund your money, if it turns out to
be a bug.
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Santosh" <santoshNoSpam@.NoSpam.net> wrote in message
news:u20RwAomEHA.3756@.TK2MSFTNGP09.phx.gbl...
> When I try from the Services I get an error saying the Services Could not
be
> started, and the SQL server does not start at all.
> Also I am not able to connect to the Database via Enterprise Manager.
> Currently I have shut down the server, but I remember getting a message
> something like "c000005 Dump".
> --
> Santosh
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:OwbAc3nmEHA.1136@.TK2MSFTNGP10.phx.gbl...
> > The messages you posted indicate that the SQL Server is probably running
> > fine. Is that the case, or are you still not able to start your SQL
> > Server?
> > What happens when you try to start your MSSQLServer service from the
> > services applet?
> > --
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> >
> >
> > "Santosh" <santoshNoSpam@.NoSpam.net> wrote in message
> > news:%23cqNlEnmEHA.1656@.TK2MSFTNGP09.phx.gbl...
> >> Hi Vyas,
> >>
> >> Sorry for the late reply,
> >> The error log just says the below and halts at the last step.
> >>
> >> 2004-09-13 17:09:54.39 spid11 Starting up database 'jennifertest'.
> >> 2004-09-13 17:10:02.75 spid3 Recovery complete.
> >> 2004-09-13 17:10:02.75 spid3 SQL global counter collection task is
> >> created.
> >>
> >> Do you want any other file like SQLDump?
> >>
> >> TIA
> >>
> >> --
> >>
> >> Santosh
> >>
> >> Can you check the SQL Server error log and post the error messages
here?
> > You
> >> will find the log in MSSQL\Log folder under the installation path.
> >> --
> >> Vyas, MVP (SQL Server)
> >> http://vyaskn.tripod.com/
> >>
> >>
> >> "Santosh" <santoshNoSpam@.NoSpam.net> wrote in message
> >> news:eHXmsUcmEHA.3352@.TK2MSFTNGP10.phx.gbl...
> >> > Friends,
> >> >
> >> > The SQL server 2000 was running fine until all of a Sudden I got this
> >> > message,
> >> >
> >> > SQL Server is aborting. Fatal exception c0000005 caught.
> >> >
> >> > The Service would not start, and I need help in Recovering it.
> >> >
> >> > Any help is greatly Appreciated.
> >> >
> >> > --
> >> >
> >> > Santosh
> >> >
> >> >
> >>
> >>
> >>
> >>
> >
> >
>