Run SQL Server on SUBST drive

[Johnny]

My current test server only has one hard disk with a
single partition (C:), however, I want to run SQL Server
on another drive letter (W:).

To establish the additional drive letter is easy, you
simply use the SUBST command to map W: to an existing
folder from a batch file. (I managed to install SQL Server
just fine on this virtual drive.) The problem is when you
reboot your machine and want the batch file to execute
before SQLAgent gets a chance to load.

How do I instruct Windows (2000 / NT / XP) to run the
MapDrive.BAT file before starting SQLAgent?
(Or better yet, how do I add this dependancy to SQLAgent?)

[Jasper Smith]

Can you not just set your SQL and Agent services startup type to manual and
then in your bat file call NET START to start those services after you've
done the rest ?
--
HTH

Jasper Smith (SQL Server MVP)

I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

"Johnny" <***@ford.com> wrote in message news:063d01c36d6f$0d093310$***@phx.gbl...
My current test server only has one hard disk with a
single partition (C:), however, I want to run SQL Server
on another drive letter (W:).

To establish the additional drive letter is easy, you
simply use the SUBST command to map W: to an existing
folder from a batch file. (I managed to install SQL Server
just fine on this virtual drive.) The problem is when you
reboot your machine and want the batch file to execute
before SQLAgent gets a chance to load.

How do I instruct Windows (2000 / NT / XP) to run the
MapDrive.BAT file before starting SQLAgent?
(Or better yet, how do I add this dependancy to SQLAgent?)