.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Upgrade from SQL 2005 EXPRESS to SQL 2008 EXPRESS

Posted By:      Posted Date: September 04, 2010    Points: 0   Category :Sql Server
Hello friends, I restored My database in SQL 2005 of size more than 4 GB but it creates problem when i save picture (image data) in database.i.e i can't save it.So i searched for that problem and came to know that SQL Express 2005 has database size limit of 4 GB. i upgraded it to SQL EXPRESS 2008 and restored it to there.Still it has the same prblem means i can't able to save data.. So what may be the problem. Thanks in advance. RAHUL PATEL. rahulpatel112@live.in

View Complete Post

More Related Resource Links

How do I upgrade and overlay SQL Server 2005 Express with SQL Server 2008 R2


We are upgrading SQL server2005 Express to SQL Server 2008 R2.  We want to replace 2005 Express with 2008 R2 on existing system.  We have lots of questions about how to perform the upgrade safely and pull in our existing databases.  The existing database files are in C:\Program Files\Microsoft SQL Server\MSSQL.1.  Also, we'll want to use the existing instance name to avoid having to reconfigure all of the installed clients at our user's workstations.

Should we uninstall the 2005 Express version first?  Will that keep the existing databases on the system?

Or can we install 2008 R2 while the databases are live under the 2005 Express, or should we shut down 2005 Express first?

Will  2008 R2 use the same data folder or create a new one?  If it uses the same folder will it automatically recognize our existing databases?  If it creates a new one, I suppose we can use the migration Wizard.


Thanks for any help....


Upgrade SQL Server 2005 Express 32-bit SP1 to SQL Server 2008 Standard on a 64-bit Server for use wi


When installing & configuring MOSS 2007 the default settings were choosen. So now when we try to access the SSMS I get a message "The evaluation period has expired. Please buy the product at the following url.". I do have a product key for SQL Server 2008 standard but when I am trying to perform a edition upgrade it doesn't detect the SQL Server Instance "OFFICESERVERS" so I am unable to upgrade the server. Because of the limitation in size we are unable to create new doc libraries or pages on the SP site.

Here are the details of the environment:

OS : Windows Server 2008 Standard SP1 64-bit

MOSS 2007 version :, Current License : Office SharePoint Server with Enterprise Client Access License

Database : SQL Server 2005 Express SP1 32-bit

Error with Visual Web Developer 2008 Express and MS SQL 2005 Express in Vista

I have created a database in SQL 2005 Express and am trying to connect to it in  Visual Web Developer 2008 Express. When I try to connect to a database and click on the Test Connection button, I get that the test connection succeded. However, when I click on OK, I get the following message:     Unable to add data connection.     Could not load file or assembly     Microsoft.SqlServer.Management.Sdk.Sfc, Version=,     Culture=Neutral, PublicKeyToken='89845dcd8080cc91', or one of its     dependencies. The system cannot find the file specified. I have turned on the IIS 7.0 functionality and am still recieving this error message. Please help. Thanks.

Management Studio sql 2005 Express on Windows Server 2008 r2

Hi , i have install a application that use sql server express 2005 on a server with OS windows server 2008 r2. My question is how to make automatic backup of my database , because i cant install SQL Server 2005 Management Console on my server .   Please help me Thanks

from SQL Server 2005 to SQL Server express 2008

I am trying to transfer some tables and stored procedures from SQL Server 2005 to Express 2008. Any ideas. I have tried using Management studio, but it isn't working....Thanks

Problem with upgrade from SQL 2008 Express to SQL Server 2008 Enterprise

I use the wizard "Maintenance > Edition Upgrade". When I choose the instance of SQL Express 2008 and click Next I get the error "Rule SQL 2008 edition upgrade failed. The selected SQL Server instance does not meet upgrade matrix requirements."What can I do to ugrade ?

SQL 2005 Express Edition with Advanced Services - Upgrade SP3

Hi On my Windows 2003 server, I have SQL 2005 Express Edition with Advanced Services -  2005.90.3042.0 I need to upgrade to SP3. I downloaded the  SQL 2005 Express Edition with Advanced Services with SP3 and ran it. It has an error: UpgradeAdvisor returned -1 Please help

Upgrade from SQL Server 9.0.2047 (Express 2005 SP1 I believe) to SP3


I am running the version of SQL I listed in the title and like I said, I believe it is SQL Express 2005 SP1 and I just want to upgrade to SP3.  I tried installing it via Microsoft Update, but that failed without giving me any detail as to why.  When I try to run the SQL Exp 2005 SP3 installer (SQLEXPR.EXE) it just acts like it is going to install a new instance of it.

I saw a post about an unattended upgrade, but frankly I'm not very familiar with that and not really comfortable with doing it.  Is there not an installer I can run that will just upgrade to SP3?

Thanks to anyone who can provide some assistance for me, I appreciate it.

MS-SQL 2005 Express In-Place Upgrade


Good morning,


Got a customer that is running MS-SQL 2005 Express (32 bits) on a Win 2K3 R2 32 Bit enterprise Server.  What are my options to do an in-place upgrade?

Can I upgrade to SQL 2008 Standard?




Luis M Astudillo Solution Architect

Need the help while installing the MS SQL 2005 Express edition on windows 2008 server.



I want to install MS SQL 2005 Exp. edition in windows server. For that I had already downloaded the SP2 MS SQL 2005 exp. edition from Microsoft web site. I am geeting error while trying to install SQL: "The SQL service failed to strat . For more information see the SQL server books online topics, "How to view SQL server 2005 setup log files and starting SQL server manually." Our Server configuration is windows 2008 R2 with 32 bit prcessor.

Before that i had install the same but SQL Server Management Studio icon is not showing, so I unstalled SQL and then trying to fresh installation.

Please help me to resolve this issues.

Thanks in advance.


How to Upgrade SQL Server Express 2008 SP1 to SP2


I have downloaded SQL Server Express 2008 SP2 installation and want to upgrade an existing SQL Server Express 2008 SP1 to SP2.

However I cannot seem to find out to do this. I have tried using the /ACTION=UPGRADE, at some point in the installation there comes a choice of which SQL instance to upgrade but the SQL Server Express (SP1) does not show up in the list.

Does anyone know how to run this upgrade to get SP1 to SP2?

Note this is being run and Windows XP SP3.

Thanks in advance for any help.

is it possible to upgrade a license of sqlserver 2008 express that has expired that was a temporary

I installed a copy of sqlserver express 2008 sp2 that was an evaluation copy that its lic has expired...is there a way to put in a new lic key from a new msdn license without having to re-install a fresh copy of 2008 from my new MSDN downloads? or am I stuck in installing a new copy?

SQL 2008 Express upgrade to SQL 2008 R2 Trial



I have SQL 2008 Express and plan to try 2008 R2. I have 3 questions:

1. I have Vista Business 32 bit. Will 2008 R2 install ti my computer? (In the software requirements I read that windows Server is needed.) 

2. Can I upgrade from 2008 express to 2008 R2 whithout trouble?

3. If later I by a developer licence can I "activate" my instance to developer version?


Thanks a lot, mnb

Instructions to install 2008 Express side by side with Express 2005



Does anyone know of any links on how to side by side install SQL 2008 Express edition on XP SP3 machine where there are instances of SQL 2005 Express edition already installed.

These 2005 Express instances are development databases and I must reduce any risks of screwing them up when I install 2008.


Setup SQL Server 2005/2008 express


Hi people, I'm trying to install SQL Server 2005 or 2008 express, but I'm getting an error:

Error inesperado en el programa de instalacion de SQL Server. Para obtener mas informacion, revise el archivo de registro de resumen de la instalacion ... Summary.txt. (This is in spanish).

When I check the summary.txt file, it doesn't have any help, the content is:

Microsoft SQL Server 2005 9.00.4035.00
OS Version      : Microsoft Windows XP Professional Service Pack 3 (Build 2600)
Time            : Tue Apr 05 15:08:07 2011

What could the problem be?



sql 2005 or sql 2008 express


Hello, I bet someone else already asked this but i couldnt find it. I have sql server 2005 installed which allows me to see sql agent task and so on but does not allow me to see compact 3.5 sql database files. I learned i need to install 2008 to open these files. also i know i cant have sql 2008 and sql 2005 ssms installed at the same time. I am stuck between 2 things i need. Do i go 2008 express lose my ability to see sql agent or do I stay at sql 2005 and do not open compact 3.5 databases.

Is there an alternative to my dilemma?

sql server 2005 express and c# 2008 express connection problem



I can't get my C# app to connect to the DB.  I have tried numerous diff ways to connect.  The DB is there, I can get to it thru sql server, just not from C#.  I keep getting the following message -

Error accessing the database, a network-related or instance-specific error occurred while establishing a connection to sql server.  The sever was not found or was not accessible.  Verify that the instance name is correct and that sql server is configured to allow remote connections. Provider: sql network interfaces, error 26 - error locating server / instance specified.

All is on my home PC running XP Home Edition.


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend