Monday, March 12, 2012

multiple database files per database on a cluster

i have an issue where i am running out of drive space on a sql server cluste
r
one idea that was presente was to add another disk to the cluster then add
that disk to the list of database files for the db that is growing?
is this a good idea?Works for me. Make sure and put the new cluster disk in the SQL resource
group AND set the SQL Server to be dependent on the new disk resource.
Otherwise, you cannot write SQL data files to the new clustered disk. You
will have to take the SQL service offline briefly to set the dependencies.
Also, disable auto-grow for the data files on the original disk.
Geoff N. Hiten
Microsoft SQL Server MVP
"jason" <jason@.discussions.microsoft.com> wrote in message
news:39E62F12-F816-4A1D-A036-D59B41C07FB9@.microsoft.com...
>i have an issue where i am running out of drive space on a sql server
>cluster
> one idea that was presente was to add another disk to the cluster then add
> that disk to the list of database files for the db that is growing?
> is this a good idea?

No comments:

Post a Comment