SQL Server Performance Forum – Threads Archive

Device Activation error

two node cluster, database is live and operational no issues.
alter database add file fails with device activation error.
any ideas?

Check that the drive you are adding the file to is a cluster resource and that the SQL server service is dependant on it.

Checked, everything fine there.

]]>