troubleshooting Question

Upgrade SQL Express database to SQL Standard

Avatar of ajdratch
ajdratch asked on
Microsoft SQL Server
19 Comments1 Solution1307 ViewsLast Modified:
I had a SQL 2005 Express database that was reaching the 4 gig limit. I upgraded to SQL 2005 Standard and choose the default instance name. I was under the impression that this would upgrade the databases to SQL 2005. The database just hit 4 gig and we can not add to it. I ran the query SELECT SERVERPROPERTY('edition')  and it reports Express Edition. How can I upgrade this database to SQL 2005 standard?


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 19 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 19 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros