CODEWITHSUNDEEP
sql-server-2005
Umar Boobak
Umar Boobak

Reputation: 1

I want to create an mdf file of 2GB in SQL Server 2005.

I want to create a new .mdf file of 2GB in SQL Server 2005.

What can I do to create 2GB file?

Upvotes: 0

Views: 153

Answers (1)

marc_s
marc_s

Reputation: 754518

Basically, just fire up your SQL Server Management Studio, go to your Object Explorer, and on the Databases node right-click and pick New database....

In the dialog that comes up, give your new database a meaningful name, and set the initial size of the data file (the .mdf file) to 2048 MB (= 2 GB):

enter image description here

Click OK and you're done.

Upvotes: 2

Related Questions