database size to 30 GB

Can we create the database with 30 GB OR MORE as per our wish?

can we add/modify the database size to 30 GB as already existing Database in server?

more ▼

asked Oct 15, 2012 at 01:59 PM in Default

avatar image

2.5k 72 76 83

Remember, if you got the answer to your question, make sure you mark it by clicking on the check box next to it.

Oct 16, 2012 at 09:33 AM Grant Fritchey ♦♦

Not only can you... it's a Best Practice to pre-allocate the space.

Oct 16, 2012 at 12:43 PM Blackhawk-17
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Yes, when you create the database put the default size as 30720, this creates the database with size of 30 GB but they are unused reserved space that can will be used later when database grows with user objects, but make sure you have enabled "instant file initialization" for the SQL Server account to boost up the performance of creating database to 30 GB.

Use alter database modify file for altering existing db size.


more ▼

answered Oct 15, 2012 at 02:05 PM

avatar image

10.8k 37 57 51

Also assuming you have the space ;-)

Oct 15, 2012 at 02:14 PM sp_lock

Great thanks

Oct 15, 2012 at 02:46 PM askmlx121

be sure to size the data file and not the log file...

Oct 15, 2012 at 06:58 PM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 15, 2012 at 01:59 PM

Seen: 2474 times

Last Updated: Oct 16, 2012 at 12:43 PM

Copyright 2018 Redgate Software. Privacy Policy