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.