Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aladinsk1
Starting Member
4 Posts |
 Posted - 2007-02-06 : 07:12:10
|
| 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) |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-02-06 : 07:15:11
|
| It's failed becausethe resulting cumulative database size would exceed your licensed limit of 4096MB per database You can't do it with the evaluation edition. You can maybe move data into other databases but that edition isn't meant for what you are doing.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
aladinsk1
Starting Member
4 Posts |
Posted - 2007-02-06 : 07:22:17
|
| thanks for your reply,But its an evaluation edition which will get expired in 165 days. Its not the express edition. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-06 : 07:51:00
|
| As the error message says, you are not permitted to have databases with sizes greater than 4 gig even in evaluation versions.Peter LarssonHelsingborg, Sweden |
|
|
|
aladinsk1
Starting Member
4 Posts |
|
|
|
|
|
SqlServer 2005