SQL 2005 Express & SQL 2008 Express

Hi Experts,

We have an old Windows 2003 server with SQL 2005 Express we want to sunset. I installed SQL Express 2008 on a newer server. I created a full backup of the database to move and tried to restore to the SQL Express 2008 and received a size error.

I looked at the size of the backup of the database and it is 16mb. I read the SQL Express 2008 has a size limit of 10mb and SQL Express 2005 has a limit of 4mb, so I don't understand how the backed up database was able to reach the 16mb if the size limit is 4mb?

An ideas would be appreciated.
talltreeAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gautham JanardhanCommented:
size limit is 10gb for SQL Express 2008 R2 not 10mb and 4gb for SQL Express 2005 not 4mb
talltreeAuthor Commented:
Hi Gautham,

Ok, so i looked at the database properties and it is 16gb, not 16mb, so it would have went over the 2005 limit of 4gb, how could it do that? I relooked at the version to make sure it was not sql 2005 and it is sql 2005 express, so it is well  over the size limitation.

Thanks
Gautham JanardhanCommented:
Back up includes the transaction log and data files. Can you check you data file and see if its below 4?
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

talltreeAuthor Commented:
On the database proberties I see 32191.88mb
talltreeAuthor Commented:
Database file properties data only 16574mb
Gautham JanardhanCommented:
can you use this proc

sp_spaceused

and see how much is the un used space.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
talltreeAuthor Commented:
4880kb
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.