LUN attachment and moving temp db

F:\ is a RAID 0 LUN attached to the server (it's on a SAN)
After running
ALTER DATABASE tempdb
MODIFY FILE (name=tempprod, filename='f:\tempdb\tempdb_data.mdf')
I get the error
Server: Msg 5184, Level 16, State 1, Line 1
Cannot use file 'f:\tempdb\tempdb_data.mdf' for clustered server. Only
formatted files on which the cluster resource of the server has a
dependency can be used.
What do i need to change in my configuration? Seems I can only see a
g:\ drive who is also on the san.Apparently, the F drive is from your locally attach
drives, not those shared by the cluster nodes. You cannot
create a database file on a non-shared drive if your SQL
instance runs in a cluster.
Create the tempdb file on the G drive.
Linchi
>--Original Message--
>F:\ is a RAID 0 LUN attached to the server (it's on a
SAN)
>After running
>ALTER DATABASE tempdb
> MODIFY FILE (name=tempprod,
filename='f:\tempdb\tempdb_data.mdf')
>I get the error
>
>Server: Msg 5184, Level 16, State 1, Line 1
>Cannot use file 'f:\tempdb\tempdb_data.mdf' for clustered
server. Only
>formatted files on which the cluster resource of the
server has a
>dependency can be used.
>What do i need to change in my configuration? Seems I
can only see a
>g:\ drive who is also on the san.
>.
>|||Ahh the F:\ drive needed to be a dependancy of the sql cluster service.
I was able to create temp on that drive after it was added.
Linchi Shea wrote:
> Apparently, the F drive is from your locally attach
> drives, not those shared by the cluster nodes. You cannot
> create a database file on a non-shared drive if your SQL
> instance runs in a cluster.
> Create the tempdb file on the G drive.
> Linchi
>
>>--Original Message--
>>F:\ is a RAID 0 LUN attached to the server (it's on a
> SAN)
>>After running
>>ALTER DATABASE tempdb
>> MODIFY FILE (name=tempprod,
> filename='f:\tempdb\tempdb_data.mdf')
>>I get the error
>>
>>Server: Msg 5184, Level 16, State 1, Line 1
>>Cannot use file 'f:\tempdb\tempdb_data.mdf' for clustered
> server. Only
>>formatted files on which the cluster resource of the
> server has a
>>dependency can be used.
>>What do i need to change in my configuration? Seems I
> can only see a
>>g:\ drive who is also on the san.
>>.