USE [master];
GO
CREATE DATABASE [dbaCentralLogging]
ON PRIMARY
(
NAME = N'dbaCentralLogging'
,FILENAME=N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\ MSSQL\DATA\dbaCentralLogging.mdf'
, SIZE=1024MB
, MAXSIZE=UNLIMITED , FILEGROWTH=1024MB
)
LOG ON (
NAME = N'dbaCentralLogging_log'
, FILENAME=N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\
MSSQL\DATA\dbaCentralLogging_log.ldf' , SIZE=256MB
, MAXSIZE=UNLIMITED
, FILEGROWTH=256MB );
GO
Example of T-SQL Code to Create a SQL Server Database
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.