asked
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?
Not only can you... it's a Best Practice to pre-allocate the space.
Remember, if you got the answer to your question, make sure you mark it by clicking on the check box next to it.
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][1]" 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. ALTER DATABASE MyDB MODIFY FILE (NAME = MyFile, SIZE = 30720) [1]:
http://msdn.microsoft.com/en-us/library/ms175935.aspx
13 People are following this question.
