September 16, 2004 at 7:37 am
We have a cluster server. O/S is Win2K SP4 and DBMS is SQL Server 2000 SP3. We added disk to the storage array. I changed the SQL Server BackupDirectory registry key to use the new disk drive. The backup jobs that us the relative path are working just fine, meaning they write to the new disk. However, when using Enterprise Manager's Backup utility, the drive is not recognized. Can anyone explain this?
September 16, 2004 at 8:23 am
Make sure the new disk resource is in SQL Server group.
September 16, 2004 at 9:32 am
Excellent point, Allen. I failed to mention that the new disk group is in the SQL Server group. I validated this via the Cluster Administrator.
September 16, 2004 at 9:45 am
You also have to configure SQL Server resource to depend on this new disk resource.
September 16, 2004 at 9:47 am
Please explain.
September 16, 2004 at 12:03 pm
When you open the properties for SQL resource, the second tab is for Dependencies. Make sure that the new disk is included under resource dependencies.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply