RAID - Failure -- SQL Server Won't Start

Running a Dell 2400 dual CPU - 4 drive in a RAID-5
configuration. System was telling me I lost 2 drives
of the four - Forced restore (twice) after changing
different pices of hardware and everything seems to be
fine except SQL Server WON'T start --
reloaded - on top - SQL Developer Edition and SP 3a --
still no help --
1. If I remove SQL - what happens to my DBs?
2. Any other ideas would be great?
jed@.experiencedtechnology.comYour databses are unaffected by uninstalling and relaoding SQL Server - =the files will still be there but you will need to re-attach them.
More intersting is why will SQl Server not start - can you post the =contents of the error log file. There should be no need to re-install - =but any messages in the SQL Server error log will give us a clue.
Mike John
"Jim D" <anonymous@.discussions.microsoft.com> wrote in message =news:06ec01c3d78f$8e85bb90$a501280a@.phx.gbl...
> Running a Dell 2400 dual CPU - 4 drive in a RAID-5 > configuration. System was telling me I lost 2 drives > of the four - Forced restore (twice) after changing > different pices of hardware and everything seems to be > fine except SQL Server WON'T start --
> > reloaded - on top - SQL Developer Edition and SP 3a -- > still no help -- > > 1. If I remove SQL - what happens to my DBs?
> 2. Any other ideas would be great?
> > jed@.experiencedtechnology.com

RAID - Failure -- SQL Server Won't Start

Running a Dell 2400 dual CPU - 4 drive in a RAID-5
configuration. System was telling me I lost 2 drives
of the four - Forced restore (twice) after changing
different pices of hardware and everything seems to be
fine except SQL Server WON'T start --
reloaded - on top - SQL Developer Edition and SP 3a --
still no help --
1. If I remove SQL - what happens to my DBs?
2. Any other ideas would be great?
jed@.experiencedtechnology.comYour databses are unaffected by uninstalling and relaoding SQL Server - =
the files will still be there but you will need to re-attach them.=20
More intersting is why will SQl Server not start - can you post the =
contents of the error log file. There should be no need to re-install - =
but any messages in the SQL Server error log will give us a clue.
Mike John
"Jim D" <anonymous@.discussions.microsoft.com> wrote in message =
news:06ec01c3d78f$8e85bb90$a501280a@.phx.gbl...

quote:

---

> Running a Dell 2400 dual CPU - 4 drive in a RAID-5=20
> configuration. System was telling me I lost 2 drives=20
> of the four - Forced restore (twice) after changing=20
> different pices of hardware and everything seems to be=20
> fine except SQL Server WON'T start --
>=20
> reloaded - on top - SQL Developer Edition and SP 3a -- =20
> still no help --=20
>=20
> 1. If I remove SQL - what happens to my DBs?
> 2. Any other ideas would be great?
>=20
> jed@.experiencedtechnology.com

---

R

Our SQL Server 2005 - clustered - 64 bit - 4 CPU - 8 GB Memory - PerfMon counters:

Paging File:% usage peak (for the _Total instance) = 100%

Process:Page File Bytes Peak (for the sqlservr.exe process) = 8673640448

SQLServer:Buffer Manager:Total Pages = 617171

SQLServer:Memory Manager:Maximum Workspace Memory = 5780079

SQLServer:Memory Manager:Total Server Memory = 4954511

In the Windows Task Manager, the mem usage for sqlservr.exe goes up as high as 6 GB and then it drops down to 0. This process of going up and down repeats itself every 10 minutes or so. Appreciate any advice. Thanks.

Hi,

I see that the sql server process can consume as much memory as it requires. So the RAM or memory configurations seems to be done.

Can a query loads a huge data to memory. A full table scan with millions of records with GB's?

Eralper