Re: SQL Server Service won't start after installing replacement hard d
- From: "Mike Walsh" <[mwalsh9815][at][gmail][dot][com]>
- Date: Mon, 4 Jun 2007 10:01:25 -0400
Without having more information it is hard to say. Did you restore to the
new drive or did you reinstall your OS? How did you get SQL installed to the
new drive?
I would look at your system event viewer. (Control Panel/Administrative
Tools/Event Viewer or easier you can go to start run and type eventvwr.msc
and hit enter) Look at the application errors from around the time you tried
starting the service, look at the system log as well.
There are also error log files from SQL Server. If the service started at
all there would be information written there as well that may help (unlikely
in this case but worth checking) The log is called ERRORLOG and each time
the server restarts it is recycled (and when manually recycled or recycled
through a job) and it is called ERRORLOG.n, you will have 7 logs by default
and after 7 recylces the oldest log is gone. These are normally in the
folder you installed SQL Server in in the MSSQL\LOG folder. You can serch
for a file called ERRORLOG with no extension and find them.
Look through the event viewer, the SQL error logs and reply with what you
see and how you actually have SQL setup on this machine with a new hard
drive.
"Kurt" <Kurt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1BA5F0F9-CDD5-42BE-A38F-E5F15CF9D020@xxxxxxxxxxxxxxxx
I have a computer running WinXP SP2, and I have installed SQL Server 2005
Express. The hard drive on that computer was dying, so I bought a Seagate
160 gig drive, and used the accompanying Disc Wizard utility program to
walk
through the process of preparing the drive and making it the boot drive to
replace the old drive. Once I was done, everything seems to be fine
EXCEPT
SQL Server service won't start. It is set as "automatic", but is shown in
SQL Server Config Man as "stopped". In Windows\Control
Panel\Adminstrative
tools\Services it shows as "automatic", has nothing in the column that
would
show Running or Stopped. If I try to Start the service, I get an error
report suggesting I check the Event log. Any clues as to what I'm looking
for (i.e., what is the Event Log and what kind of entry might I find), or
how
I can get the service to load? I am reluctant to uninstall and reinstall
because of the difficulty of getting my sql-based database to run
correctly;
and am similarly concerned about running the setup program to "repair" the
installation of sqlexpress.
.
- Prev by Date: sql server 2005 install question
- Next by Date: Re: sql server 2005 install question
- Previous by thread: sql server 2005 install question
- Next by thread: upgrading to sql 2005
- Index(es):
Relevant Pages
|
