-- ============================================================
-- DBAOps Enterprise™ - Create Database
-- Generated: 2026-02-05 08:20:54
-- ============================================================
USE [master];
GO

IF NOT EXISTS (SELECT 1 FROM sys.databases WHERE name = 'DBAOpsRepository')
BEGIN
    CREATE DATABASE [DBAOpsRepository]
    ON PRIMARY (
        NAME = N'DBAOpsRepository',
        FILENAME = N'E:\ProdDB\DBAOps\DBAOpsRepository.mdf',
        SIZE = 1024MB, FILEGROWTH = 256MB
    )
    LOG ON (
        NAME = N'DBAOpsRepository_log',
        FILENAME = N'E:\ProdDB\DBAOps\DBAOpsRepository_log.ldf',
        SIZE = 512MB, FILEGROWTH = 128MB
    );
    PRINT 'Database DBAOpsRepository created';
END
ELSE PRINT 'Database DBAOpsRepository already exists';
GO

ALTER DATABASE [DBAOpsRepository] SET RECOVERY FULL;
GO