Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    2

    Red face Unanswered: Physical Drive on a clustered server...

    This is the error message that I receive from Query Analyzer when I try to run a sp_attach_db tsarch, 'E:\tsarch_log\tsarch_Log.ldf'

    Cannot use file 'E:\tsarch_log\tsarch_Log.ldf' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used.

    Any help would be greatly appreciated.

    Thanks,

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    The file you are attaching has to be on one of the shared disks of the cluster. Is your E:\ drive local to one of the nodes, or is it a resource for another virtual server?

  3. #3
    Join Date
    Sep 2003
    Posts
    2
    Originally posted by MCrowley
    The file you are attaching has to be on one of the shared disks of the cluster. Is your E:\ drive local to one of the nodes, or is it a resource for another virtual server?

    My E:\ drive is a mirrored drive in which two physical disks are combined into one. I'm trying to move my log file for my database from D:\Program Files\Microsoft SQL Server\MSSQL\Data\tsarch_Log.ldf to E:\tsarch_log, but I am having this problem. My E:\ drive is local.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •