Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

"kind of bug" with sql server 2008 Expand / Collapse
Author
Message
Posted Wednesday, January 30, 2013 5:22 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 10:49 PM
Points: 882, Visits: 4,105
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
Post #1413575
Posted Wednesday, January 30, 2013 7:58 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 10:49 PM
Points: 882, Visits: 4,105
Please ignore this duplicate thread as i moved it here http://www.sqlservercentral.com/Forums/Topic1413640-391-1.aspx
thanks for looking


----------
Ashish
Post #1413642
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse