January 30, 2013 at 5:22 am
I am not understanding this behaviour of SQL Server 2008 (ent ed, sp3cu2). I configured my model database with adequate space so that any new database have default configuration of model.
Now the problem is,
When I am creating it via ssms qizrd, its creating the data and log files as exact of model.
But,
If I run simple tsql as "create database test", it still not creating the data and log file as per model. And also its not consistent of default things which is 3 mb for data and 1 mb for log (initial size). In some environment, this value also changing.
Can someone point me right direction to understand this?
I am not sure about other edition or version but my build level is 10.0.5768.0(sql 2008, sp3cu2) , 64 bit server and 64 bit sql where I am having this issue.
----------
Ashish
January 30, 2013 at 7:58 am
Please ignore this duplicate thread as i moved it here http://www.sqlservercentral.com/Forums/Topic1413640-391-1.aspx
thanks for looking
----------
Ashish
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply