October 19, 2004 at 3:13 pm
Hoping the someone can help!!! I have a SQL 2000 server that is attached to a SAN. There are two "dynamic" drives which attach to the SAN that host my production database and log files. I need to build another test database, so my Network engineer allocated another 25 gbs on a seperate LUN and configured from the server. When I click on "My computer", I can see the added logical drive, however when I try to create the database, I receive the following error:
5101 "Device Activation Error" - I verified that I can write to the SAN from the OS, but when I go into EM, select the Db and select properties > Database Settings and look at the default directories, the new logical drive does not show up. I tried stopping and restarting the SQL service with no luck.
Hoping someone can help. Thanks so much. ~Kris
October 20, 2004 at 12:36 am
The (domain)account which is used for running SQL Server 2000, must have at least List permissions on the root of the new disk, and have Full access permissions on the directory where the files will be placed.
October 20, 2004 at 11:08 am
The fact that you are using a SAN makes me think that you are using Clustering Services.
If that is the case, then you must make the device a cluster resource before SQL will recognize it.
GL
Pete
October 20, 2004 at 1:23 pm
First off, for clustering support and expansion of volumes, all disks should be basic. That said, you'll need to create a cluster resource for the new volume, take the SQL Server resource off-line, add the dependency for the new disk resource, bring the disk resource online, and then bring the SQL Server resource online.
Cluster administrator can be somewhat flakly recognizing new volumes, I find that usually need to reboot the system before the disk volume is accessible from Cluster administrator.
Cheers,
Dave
October 21, 2004 at 10:05 am
As noted above for SQL server in a clustered environment you must add the disk to the dependent resources for SQL Server. You should not have to fail over the cluster and I'm not certain you will have to take the sql server resource group offline either. Just remeber you have to do everything in cluster administrator - other than that it's quite easy .
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply