MS SQL Server - Changing location of log files in a Clustered Virtual Server

Author

Changing location of log files in a Clustered Virtual Server

Carlos

2006-03-05, 8:23 pm

I set up a Clustered Virtual Server using Windows 2003 Enterprise SP! and
SQL2000 Enterprise SP2. When setting SQL it gave me the option to choose the
location of the data, now that the virtual server is functional I want to
change the location of the log files to a different resource of the cluster
(different drive) but it is not letting me do so. Hoe do you change locations
of your drives in a clustered environment?

Any ideas?

John Bell

2006-03-05, 8:24 pm

Hi

It is probably because the drive in question has not been added as a
resource to the sql server cluster in cluster manager.

John

"Carlos" < carlosarango@SQLserv
er.com> wrote in message
news:626F2CB6-A2E1-4CFB-A49F- E6413133BF78@microso
ft.com...
>I set up a Clustered Virtual Server using Windows 2003 Enterprise SP! and
> SQL2000 Enterprise SP2. When setting SQL it gave me the option to choose
> the
> location of the data, now that the virtual server is functional I want to
> change the location of the log files to a different resource of the
> cluster
> (different drive) but it is not letting me do so. Hoe do you change
> locations
> of your drives in a clustered environment?
>
> Any ideas?
>

Sponsored Links