Post reply

Licensed Limit

  • May 30, 2010 at 10:08 pm

    #233153

    Hi there,

    Im a bit playing with some stuff and encountered an error.

    Here's my Code:

    CREATE DATABASE mytest

    ON

    (NAME = 'mytest',

    FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL10.DEFAULTINSTANCE\MSSQL\DATA\mytest.mdf',

    SIZE = 5GB,

    MAXSIZE = 20GB,

    FILEGROWTH = 5)

    LOG ON

    (NAME = 'mytestlog',

    FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL10.DEFAULTINSTANCE\MSSQL\DATA\mtestlog.ldf',

    SIZE = 5MB,

    MAXSIZE = 20GB,

    FILEGROWTH = 5 MB)

    GO

    And here's the error:

    Msg 1827, Level 16, State 4, Line 1

    CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.

    Any ideas?

    Thanks in advance

    _____________________________________________
    [font="Comic Sans MS"]Quatrei Quorizawa[/font]
    :):D:P;):w00t::cool::hehe:
    MABUHAY PHILIPPINES!

    "Press any key...
    Where the heck is the any key?
    hmmm... Let's see... there's ESC, CTRL, Page Up...
    but no any key"
    - Homer Simpson

  • May 31, 2010 at 12:06 am

    #1174396

    Found out that this is a limitation of express edition... hmmm... but still, does anyone know any workaround to this

    _____________________________________________
    [font="Comic Sans MS"]Quatrei Quorizawa[/font]
    :):D:P;):w00t::cool::hehe:
    MABUHAY PHILIPPINES!

    "Press any key...
    Where the heck is the any key?
    hmmm... Let's see... there's ESC, CTRL, Page Up...
    but no any key"
    - Homer Simpson

  • May 31, 2010 at 1:28 am

    #1174408

    Quatrei.X (5/31/2010)

    but still, does anyone know any workaround to this

    Buy a license for a higher edition of SQL Server and upgrade. Express is free, hence it's reasonable that it's limited.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 31, 2010 at 1:46 am

    #1174416

    Im a cheapskate LOL :hehe:

    anyways, i don't really need it right now, just trying out things. might buy it if I already need it.

    Thanks anyway... ^__^

    _____________________________________________
    [font="Comic Sans MS"]Quatrei Quorizawa[/font]
    :):D:P;):w00t::cool::hehe:
    MABUHAY PHILIPPINES!

    "Press any key...
    Where the heck is the any key?
    hmmm... Let's see... there's ESC, CTRL, Page Up...
    but no any key"
    - Homer Simpson

  • May 31, 2010 at 1:53 am

    #1174421

    SQL 2008 Express is limited to 4 GB per database. I belive SQL 2008 R2 express has a higher limit, but it's still limited. You can create multiple databases, but no single database may exceed that limit.

    If this is for your personal development/experimental use, buy SQL developer edition. $50 (last I heard), all the features of Enterprise edition but licensed for development only.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 31, 2010 at 2:52 am

    #1174430

    Quatrei.X (5/31/2010)

    Found out that this is a limitation of express edition... hmmm... but still, does anyone know any workaround to this

    Upgrade to Express 2008 R2. The new limit is 10GB.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply