Home Forums SQL Server 2012 SQL 2012 - General Multiple instances tempDB on the same local disk in sql2012 cluster RE: Multiple instances tempDB on the same local disk in sql2012 cluster

  • Sorry, for tempDB it may be different. For user databases

    CREATE DATABASE [testDB]

    CONTAINMENT = NONE

    ON PRIMARY

    ( NAME = N'testDB', FILENAME = N'q:\testDB.mdf' , SIZE = 4096KB , FILEGROWTH = 1024KB )

    LOG ON

    ( NAME = N'testDB_log', FILENAME = N'q:\testDB.ldf' , SIZE = 9216KB , FILEGROWTH = 10%)

    Msg 5184, Level 16, State 2, Line 1

    Cannot use file 'q:\testDB.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.

    Msg 1802, Level 16, State 1, Line 1

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