Create database using script at the default path?

Question

I've generated a script of a database in SQL Server 2008. The generated script has the hardcoded path of where the database would be created. I don't want this path to be hardcoded, I want this path to use the default of the database engine the script is running on.

Here is the small portion of the script:

CREATE DATABASE [POS] ON  PRIMARY 
( NAME = N'POS', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\POS.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'POS_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\POS_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO

The path C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\POS.mdf might not exist on all computers that's why I want it to be chosen by the database engine

Oleg Dok · Accepted Answer · 2012-01-12 15:11:08Z

37

Simply create the database and then adjust all the needed properties directly in files

CREATE DATABASE [POS] 
GO
ALTER DATABASE POS MODIFY FILE 
( NAME = N'POS' , SIZE = 3048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
GO
ALTER DATABASE POS MODIFY FILE 
( NAME = N'POS_log' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO

answered Jan 12, 2012 at 15:11

Oleg Dok

21.9k4 gold badges48 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Uzair Farooq Over a year ago

yeah, I was already trying to choose it as best but stackoverflow was not allowing me to choose that early

Mithrandir · Accepted Answer · 2012-01-12 15:11:00Z

16

Why don't use just:

CREATE DATABASE [POS];

This will create the database with all the default settings (including paths). You may alter any setting you like later on.

answered Jan 12, 2012 at 15:11

Mithrandir

25.5k6 gold badges53 silver badges67 bronze badges

1 Comment

kampsj Over a year ago

It will use POS and POS_log as defaults. In my case at least.

Collectives™ on Stack Overflow

Create database using script at the default path?

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related