CODEWITHSUNDEEP
sqlsql-serversql-server-2005
Crouch
Crouch

Reputation: 896

Will autogrowth overcome SQL Server Express database size limit?

I've hit the 4gb limit in my database and I need a bit of breathing space before upgrading it to a SQL Server 2008 database and I just wondered if increasing auto growth would give me more space inside the database beyond the 4GB limit that SQL Server 2005 Express imposes.

I know the pitfalls of Auto Growth with regards to performance as data will be fragmented across the disk and thus make querying it slower but is there an advantage in granting it say 50/100mb of room for auto growth? Whilst the migration process is planned out or an alternative is sought.

Disk space is not an issue and it would only be a temporary measure anyway.

Upvotes: 0

Views: 1604

Answers (3)

Stefan Steiger
Stefan Steiger

Reputation: 82156

No, once you've reached 10'240 MB (10*1024MB) , you're out of luck
(technically not exactly 10GiB).

Upvotes: 0

athar13
athar13

Reputation: 382

No it won't. The SQL Server Express edition is for creating Database-oriented applications without the need to purchase an official SQL Server licenses. However, you cannot use it in an production environment for more reasons other than just file size limit.

Upvotes: 1

Remus Rusanu
Remus Rusanu

Reputation: 294217

No. Express Edition will not grow, nor attach or restore, a database over its size limit, no matter what the errorlog viewer tells you. Not even temporarily.

But you have an easy solution: SQL Server 2008R2 Express Edition has raised the limit to 10GB.

Upvotes: 2

Related Questions