How do I install SQL Server 2008 Express R2 SP1 to an existing R2 Express instance?

This is the link for the standalone service pack: microsoft.com/download/en/details.aspx?d... (fixed) You have the full install package above.

The link seems to point to SQL Server 2008 SP1. I believe OP is looking for SQL Server 2008 R2 SP1. – Siva Aug 3 at 0:05 Here is the SQL Server 2008 R2 SP1 link microsoft.Com/download/en/… – Siva Aug 3 at 0:07 @Siva: thank you, fixed.

– gbn Aug 3 at 0:08 You are welcome. – Siva Aug 3 at 0:11 After some confusion on my part...finally did it right. The link above worked for me.

– awhig Aug 37 at 17:46.

Here is an MSDN link that might help you to install the specific instance of SQL Server 2008 R2. I think that the Select Features should list the instances available on the machine for a given SQL version. SQL Server 2008 R2 SP1 - scope I installed SQL 2008 R2 Developer edition and SP1 on my machine last week and this is how the Select Features screen looks like.

I am not sure if the same holds true for Express edition. SQL2008R2 is my SQL Server 2008 R2 instance name and it is selected by default.

Windows update on my Windows 7 64 bit system says I have an optional update available, Microsoft SQL Server 2008 R2 Service Pack 1 (KB2528583). When I try to install it through Windows update, it hangs. I try stopping the installation, and that hangs as well.

I have to do a full restart to clear this up. I download SQLEXPRADV_x64_ENU.exe. When I start it up, I'm not sure how I update my existing installation of R2?

It wants to do a new installation, which looks like I would have to migrate all my DBs into the new instance it creates. Does anyone know how I can get this installer to update my existing R2 to SP1 in place? Just update my existing instance.

Should I do a repair instead?

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions