SQL Server Standard database hitting 10GB limit

Question

Hi

We attached a SQL Server Express created database to SQL Server Standard 2019 but the database is still hitting 10GB limit. What can we do to update schema so 10GB limit is gone?

Thanks

Regards

Answer 1

Hi @-- --

Use below code to check current database file size:

USE YourDatabaseName
EXEC sp_helpfile;

Try expanding the file size as follow:

ALTER DATABASE YourDatabaseName
MODIFY FILE ( NAME = 'DataFileName', SIZE = 50GB );

Review this tech doc for more details and examples.

Best regards,

Cosmog

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".