Tuesday 29 March 2016

Create Database manually in SQL SERVER

As salamo alaikum wa rahmatullah


Create database Food
ON
(
 Name=FoodData1,
 Filename='C:\ManualDB\SQLSERVER12.0\DATA\FoodData1.mdf',
 Size=10MB,
 MaxSize=unlimited,
 filegrowth=1GB
)
Log ON
(
 Name=FoodLog1,
 Filename='C:\ManualDB\SQLSERVER12.0\DATA\FoodData1_log.ldf',
 Size=10MB,
 MaxSize=unlimited,
 filegrowth=1024MB
)


--
Ma Asalaam
Passion 4 Oracle

No comments:

Post a Comment