Changing Drive Letters

I am new to SQL server so any guidance is much appreciated.
We have two logical drives for our SQL server.We are upgrading from a
smaller driver to a bigger one. We have copied everything from one drive to
the other after doing so we decided the easiest thing to do would be to
change the drive letter to what the old drive used to be. We went into disk
management and tried to do it from there but had no luck with getting the
cluster or the services restarted and back up. This seems like such an easy
thing to do but I can not seem to get it right! Again, if anyone has any
advice it would be greatly appreciated.
Changing a drive letter "under the covers" works, but you have to do a few
tweaks to make it work on a cluster. Make sure you have created the new
disk as a cluster resource. Put it in the SQL server group and make the SQL
service dependant on the new disk. If that doesn't fix it, check the
application and system logs to see what SQL and/or the cluster service is
complaining about.
Geoff N. Hiten
"Mel" <Mel@.discussions.microsoft.com> wrote in message
news:8B9A7516-D136-4044-9284-3F5E4590D197@.microsoft.com...
>I am new to SQL server so any guidance is much appreciated.
> We have two logical drives for our SQL server.We are upgrading from a
> smaller driver to a bigger one. We have copied everything from one drive
> to
> the other after doing so we decided the easiest thing to do would be to
> change the drive letter to what the old drive used to be. We went into
> disk
> management and tried to do it from there but had no luck with getting the
> cluster or the services restarted and back up. This seems like such an
> easy
> thing to do but I can not seem to get it right! Again, if anyone has any
> advice it would be greatly appreciated.
|||Mel
Check out the ClusterRecovery.exe from
http://www.microsoft.com/downloads/d...displaylang=en
If your new to clustering and want to swap disks, this might be a little
more user friendly for you. This will take care of the dependancy issue as
well.
Good Luck
Regards
CT
"Mel" wrote:

> I am new to SQL server so any guidance is much appreciated.
> We have two logical drives for our SQL server.We are upgrading from a
> smaller driver to a bigger one. We have copied everything from one drive to
> the other after doing so we decided the easiest thing to do would be to
> change the drive letter to what the old drive used to be. We went into disk
> management and tried to do it from there but had no luck with getting the
> cluster or the services restarted and back up. This seems like such an easy
> thing to do but I can not seem to get it right! Again, if anyone has any
> advice it would be greatly appreciated.

changing default drives for data and logs

We have attached a SAN to one of our SQL Server 2000 boxes. I want the default drives for data and logs to change to the SAN. I tried to change the model database thru EM but that didn't work. I tried to detach model but that didn't work either.
Is it possible to change the default drives so that when a new database is created the data and log files will default to the SAN drives?
Thanks,
Dan D.
In Enterprise Manager, right click the server, choose properties, and you
can change the default locations for data and log files on the Database
Settings tab.
Jacco Schalkwijk
SQL Server MVP
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:7A59D230-D56F-4C14-B49B-BE3C6633C5F0@.microsoft.com...
> We have attached a SAN to one of our SQL Server 2000 boxes. I want the
default drives for data and logs to change to the SAN. I tried to change the
model database thru EM but that didn't work. I tried to detach model but
that didn't work either.
> Is it possible to change the default drives so that when a new database is
created the data and log files will default to the SAN drives?
> Thanks,
> --
> Dan D.
|||Wonderful. Thanks.
Dan D.
"Jacco Schalkwijk" wrote:

> In Enterprise Manager, right click the server, choose properties, and you
> can change the default locations for data and log files on the Database
> Settings tab.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:7A59D230-D56F-4C14-B49B-BE3C6633C5F0@.microsoft.com...
> default drives for data and logs to change to the SAN. I tried to change the
> model database thru EM but that didn't work. I tried to detach model but
> that didn't work either.
> created the data and log files will default to the SAN drives?
>
>

changing default drives for data and logs

We have attached a SAN to one of our SQL Server 2000 boxes. I want the default drives for data and logs to change to the SAN. I tried to change the model database thru EM but that didn't work. I tried to detach model but that didn't work either.
Is it possible to change the default drives so that when a new database is created the data and log files will default to the SAN drives?
Thanks,
--
Dan D.In Enterprise Manager, right click the server, choose properties, and you
can change the default locations for data and log files on the Database
Settings tab.
--
Jacco Schalkwijk
SQL Server MVP
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:7A59D230-D56F-4C14-B49B-BE3C6633C5F0@.microsoft.com...
> We have attached a SAN to one of our SQL Server 2000 boxes. I want the
default drives for data and logs to change to the SAN. I tried to change the
model database thru EM but that didn't work. I tried to detach model but
that didn't work either.
> Is it possible to change the default drives so that when a new database is
created the data and log files will default to the SAN drives?
> Thanks,
> --
> Dan D.|||Wonderful. Thanks.
--
Dan D.
"Jacco Schalkwijk" wrote:
> In Enterprise Manager, right click the server, choose properties, and you
> can change the default locations for data and log files on the Database
> Settings tab.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:7A59D230-D56F-4C14-B49B-BE3C6633C5F0@.microsoft.com...
> > We have attached a SAN to one of our SQL Server 2000 boxes. I want the
> default drives for data and logs to change to the SAN. I tried to change the
> model database thru EM but that didn't work. I tried to detach model but
> that didn't work either.
> >
> > Is it possible to change the default drives so that when a new database is
> created the data and log files will default to the SAN drives?
> >
> > Thanks,
> > --
> > Dan D.
>
>

changing default drives for data and logs

We have attached a SAN to one of our SQL Server 2000 boxes. I want the defau
lt drives for data and logs to change to the SAN. I tried to change the mode
l database thru EM but that didn't work. I tried to detach model but that di
dn't work either.
Is it possible to change the default drives so that when a new database is c
reated the data and log files will default to the SAN drives?
Thanks,
--
Dan D.In Enterprise Manager, right click the server, choose properties, and you
can change the default locations for data and log files on the Database
Settings tab.
Jacco Schalkwijk
SQL Server MVP
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:7A59D230-D56F-4C14-B49B-BE3C6633C5F0@.microsoft.com...
> We have attached a SAN to one of our SQL Server 2000 boxes. I want the
default drives for data and logs to change to the SAN. I tried to change the
model database thru EM but that didn't work. I tried to detach model but
that didn't work either.
> Is it possible to change the default drives so that when a new database is
created the data and log files will default to the SAN drives?
> Thanks,
> --
> Dan D.|||Wonderful. Thanks.
--
Dan D.
"Jacco Schalkwijk" wrote:

> In Enterprise Manager, right click the server, choose properties, and you
> can change the default locations for data and log files on the Database
> Settings tab.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:7A59D230-D56F-4C14-B49B-BE3C6633C5F0@.microsoft.com...
> default drives for data and logs to change to the SAN. I tried to change t
he
> model database thru EM but that didn't work. I tried to detach model but
> that didn't work either.
> created the data and log files will default to the SAN drives?
>
>