SQL2K Installation: Multiple Drives Question

[Mr3Putt]

I am not a database administrator. I do not study the vaguaries of of SQL2K setup, care, or maintenance.

We are upgrading a SQL7.x installation to 2K.

Our current install of 7.x includes the SQL applications on the C:\ drive, but the actual database files, mdf, ldf, etc on the E:\ drive. The server itself is dual-processor, 2Ghz, with a couple pretty massive drives, but no RAID setup.

Is that good? Is it a problem? I'm being told that the upgrade will be more difficult in this situation, and that it would be simpler to store both the SQL2K application and the databases on a single drive.

I don't have immediate answers to these questions. Do you?

Thank you in advance for any time spent assisting my pinheadedness.

 

[donutman]

Microsoft SQL Server: Data Transformation Services Forum
(5049 members)
forum961
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[donutman]

Oops. Microsoft SQL Server: Setup and Administration Forum
(8984 members)
forum962
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]