SQL Server Performance

Microsoft SQL Server, Error:1827

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by aladinsk1, Feb 6, 2007.

  1. aladinsk1 New Member

    I have installed SqlServer 2005 evalution version. The file size is now 4035. When I tried to add new data file name,I am getting the below error.
    Pls can any one help me.

    Alter failed for database 'test'. (Microsoft.SqlServer.Smo)

    An exception occured while executing a Transact-SQL statement or batch(Microsoft.SqlServer.ConnectionInfo)

    Create DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096MB per database (Microsoft SQL Server, Error:1827)
  2. Luis Martin Moderator

    Kindly don't duplicate posts.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



Share This Page