sqlsql-servert-sql

Create Database :: ERROR


Trying to create Database as follows:

    USE Master
    GO

    IF NOT EXISTS(SELECT [Name] FROM sys.databases WHERE [name] = 'QAudit')
CREATE DATABASE [QAudit] ON  PRIMARY 
( NAME = N'QAuditData', FILENAME = N'<filePath,nvarchar(300),C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\>QAuditData.mdf' , SIZE = 921600KB , FILEGROWTH = 10%)
 LOG ON 
( NAME = N'QAuditLog', FILENAME = N'<filePath,nvarchar(300),C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\>QAuditLog.ldf' , SIZE = 512000KB , FILEGROWTH = 10%)

    GO

Getting following error:

Msg 5105, Level 16, State 2, Line 3 A file activation error occurred. The physical file name 'QmastorAuditData.mdf' may be incorrect. Diagnose and correct additional errors, and retry the operation. Msg 1802, Level 16, State 1, Line 3 CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

Any clues please.


Solution

  • Should FILENAME be the fully qualified path.. I know I use the full folder path when creating databases.

    USE [master]
    GO
    
    CREATE DATABASE [HereTis] ON  PRIMARY 
    ( 
        NAME = N'HereTis', 
        FILENAME = N'C:\DATA\HereTis.mdf' ,         --local data path
        SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB 
    )
    LOG ON 
    ( 
        NAME = N'HereTis_log', 
        FILENAME = N'C:\DATA\HereTis.ldf' ,         --local data path
        SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%
    )
    GO