How to Create Database in SQL Server By using TSQL or GUI -SQL Server/ T-SQL Tutorial Part 24

How to Create Database in SQL Server By using TSQL or GUI -SQL Server/ T-SQL Tutorial

Scenario:

You are working as database developer and you have to prepare scripts for Create Database with below requirements so it can be run in QA, UAT and Production SQL Server Instances.

Database Name : TechBrothersIT
Primary File Name : TechBrothersIT
Index File Group : TechBrothersIT_Indexe
Log File Name : TechBrothersIT
and
Primary file should be on C:\PrimaryDBFiles
Index File should be on C:\IndexDBFiles
and Log file should be on C:\LogDBFiles

The Initial Size for each of the file should be 1GB and Max Size set to Unlimited and file growth should be set to 2 GB.


Solution:

You can create the database by using Graphical User interface in SSMS or you can use TSQL. Let's do this by using GUI first and then we will do the same by using TSQL.

Step 1:
Right Click on the Database Tab and then hit New Database so open Create database wizard.

Now make changes according to our requirement. 1 GB=1024 MB. Also we need to add a new File Group for Index File.

Now once you hit Ok, new database will be created.

How to Create Database by using TSQL Script:

If you don't like to create database by using GUI, you can hit Script Button and then Generate Script in new Windows.


TSQL script will be generated in new window and you can use this to create database. Also you can make changes as per your environment if paths are different.

Link for post for scripts
http://www.techbrothersit.com/2016/02/how-to-create-database-in-sql-server-by.html

Check out our website for Different SQL Server, MSBI tutorials and interview questions
such as SQL Server Reporting Services(SSRS) Tutorial
SQL Server Integration Services(SSIS) Tutorial
SQL Server DBA Tutorial
SQL Server / TSQL Tutorial ( Beginner to Advance)
http://www.techbrothersit.com/