Re: Problems with SQL 2000 with SP3

From: Allison (no_at_email.com)
Date: 04/12/04 

Date: Mon, 12 Apr 2004 10:19:58 -0500

>From the error messages that I listed and the problem I have described, what
do you think happened? Was it the master database? Can't figure out why
the service will not start. Looks like all the data is there.

Thanks

"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
news:%23qOL$oJIEHA.3144@TK2MSFTNGP10.phx.gbl...
> Have you considered uninstalling and reinstalling SQL Server completely?
> Then it should just be a matter of restoring your user databases, which is
> what you have backups for anyway...
>
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
>
>
>
>
> "Allison" <no@email.com> wrote in message
> news:uwW3RaJIEHA.3848@tk2msftngp13.phx.gbl...
> >I have a Windows 2000 Server with SQL 2000 SP3 installed. It is
> >partitioned
> > into to seperate logical drives. The first partition is the OS and the
> > second partition is SQL and its databases. Both partitions have
seperate
> > RAID controllers and drives associated with it. I recently had problems
> > my
> > RAID controller relating to the second partition. I was able to recover
> > the
> > hardware failure and can still read the SQL partition and its data.
> > Unfortunately, I cannot get the SQL service to start anymore. I get the
> > following errors in event viewer:
> >
> > Source: MSSQLSERVER
> > Category: (2)
> > Event ID: 17055
> > Description:
> > 17052 :
> > Cannot recover the master database. Exiting.
> >
> > Source: MSSQLSERVER
> > Category: (2)
> > Event ID: 17055
> > Description:
> > 18052 :
> > Error: 9003, Severity: 20, State: 1.
> >
> > Cannot anyone get me started on what I need to do? I have a backup of
> > everything but I didn't know if their was an easier way to get this
> > working.
> >
> > Thanks
> >
> >
>
>

Relevant Pages

  • Move Existing SQL Server to a New Server
    ... Everything SQL related is on the E partition. ... and SQL application, another RAID 1 for the logs, and a RAID 0/1 for the ... I attempted to RESTORE the master database first, ...
    (microsoft.public.sqlserver.setup)
  • Cannot recover the master database.
    ... In my computer when sql is starting occur the follow ... - Cannot recover the master database. ... Daniela ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2005 Express as a Data Mart environment
    ... I'm not sure if there are any limitations with SQL Express with respect to ... meter with 60-170k rows each with 3.5mil rows total. ... each partition. ... 15MinuteInterval TinyInt ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Merge join performs really slow
    ... You can remove the join from the SQL statement but do so at your own risk. ... or you could load the partition through a view (which is my ... > join hint - with a loop join strategy. ...
    (microsoft.public.sqlserver.olap)
  • Re: Getting Started - RAID, Multiple Instances, SQL 2000-2005 . . .
    ... SQL 2000 Std. ... Data and Logs on RAID 5 partition ... Planning to put OS on RAID 1 partition, logs on different RAID 1 partition, ...
    (microsoft.public.sqlserver.setup)
Loading