CREATE DATABASE failed with clustered Microsoft SQL Server 2008 instance

Getting the following error message while trying to create a database on a clustered SQL 2008 instance

Cannot use file ‘D:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\myDatabase.mdf’ for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it.

CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

CREATE DATABASE failed with clustered Microsoft SQL Server 2008 instance
Description:
This error occurs when we forgot to configure the disk dependency in Failover Cluster Manager. SQL prevents you from creating databases on volumes which aren’t a dependency of the SQL Server resource. This is to prevent situations where SQL Server comes online before the disk containing the database.

To fix this issue, add the dependency by following the below steps.
1. Open Failover Cluster Manager

CREATE DATABASE failed with clustered Microsoft SQL Server 2008 instance
2. Select your clustered application

CREATE DATABASE failed with clustered Microsoft SQL Server 2008 instance
3. Right-click on your SQL Server resource then click Properties.

CREATE DATABASE failed with clustered Microsoft SQL Server 2008 instance
4. Click on the Dependencies tab.
5. Click the Insert button to add an additional row, then select the shared disk that contains your SQL databases.CREATE DATABASE failed with clustered Microsoft SQL Server 2008 instance
6. Ensure that all resources are required (there is an AND next to subsequent resources) then click OK.


<<Click here to see all posts>>

 

Leave a Reply

Your email address will not be published. Required fields are marked *

Prove You Are Human Time limit is exhausted. Please reload CAPTCHA.