Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

SQL Server 2012 - Minimum Database size increased to 3MB

Nov 22 2011 12:57PM by Ramireddy   

Careful! If you are using your old scripts to create database in SQL 2012, It might fail. In SQL Server 2012, Minimum database size is increased to 3MB. In before versions it is 2MB. So, if you run the same script with initial size specified as 2MB, it will throw an error.

Read More..   [42 clicks]

Published under: SQL Server Tips ·  ·  ·  · 


Ramireddy
2 · 41% · 12972
18
 
0
Knew
 
21
 
 
0
Interesting
 
0
Forgotten



Submit

5  Comments  

  • I've just created a DB in Denali setting the size to 2MB. It worked, no problem.

    commented on Nov 24 2011 1:26AM
    pl80
    414 · 0% · 95
  • Minimal database size depends from model database. If you need to change database minimal size you should change model database.

    commented on Nov 24 2011 2:03PM
    Dubelewskyj Oleksandr
    463 · 0% · 81
  • @Rami: Thank-you for sharing this information. It is good to see and work with the new features of SQL 2012, but at the same time one must have an idea of how the storage requirements change (while the change from 2MB to 3MB itself is not such a big deal in today's storage scenarios, knowing this is still important).

    @pl80: What release of Denali are you working with? My understanding is that this change is effective CTP03 onwards.

    @Dubelewskyj Oleksandr : That is correct. The minimum size of any database (including the tempdb) depends upon the size of the model database. You may refer to my post - SQL Server – TempDB – Is it a copy of the Model database? - for details.

    commented on Nov 24 2011 10:24PM
    Nakul Vachhrajani
    4 · 33% · 10564
  • CTP 3

    commented on Nov 25 2011 2:47AM
    pl80
    414 · 0% · 95
  • Yes, will agree, While creating new database, it will be replica of model database only.

    commented on Nov 25 2011 3:20AM
    Ramireddy
    2 · 41% · 12972

Your Comment


Sign Up or Login to post a comment.

"SQL Server 2012 - Minimum Database size increased to 3MB" rated 5 out of 5 by 18 readers
SQL Server 2012 - Minimum Database size increased to 3MB , 5.0 out of 5 based on 18 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]