Post reply

Enterprise Manager Does Not Recognize New Disk

  • September 16, 2004 at 7:37 am

    #162212

    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

    #523346

    Make sure the new disk resource is in SQL Server group.

  • September 16, 2004 at 9:32 am

    #523364

    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

    #523368

    You also have to configure SQL Server resource to depend on this new disk resource.

  • September 16, 2004 at 9:47 am

    #523370

    Please explain.

  • September 16, 2004 at 12:03 pm

    #523401

    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