SQL Server 2008 R2 Service Pack 1 download

Zeljko Matic 1

I need to instal SQL 2008 R2 SP1 64-bit version but can't fin it. On microsoft file is not available on links.
I need it because of restore. Where I can find download file.
Thanks in advance

YufeiShao-msft 7,056 Reputation points

2021-11-01T08:02:31.947+00:00

Hi, In addition to MSDN, as they say, you can no longer download sp1 from other official channels

1 answer

Erland Sommarskog 101.4K Reputation points MVP

2021-10-30T09:03:41.893+00:00

It is available on MSDN Subscriber Downloads. That's a paid service, but many companies have this for their developers.

Else, it is not clear why you want that specific service pack. Even if the backup was taken with that version originally, you can restore it on SQL 2008 R2 SP3. (And for that matter any later version of SQL Server.)
Please sign in to rate this answer.

1 person found this answer helpful.
Zeljko Matic 1 Reputation point

2021-10-30T09:14:40.643+00:00

Because I need to restore merge publisher and for that i need to restore master which require same bilt to be on server. After restoring publisher i can upgrade it to sp3.

Publisher shoud be restore to server with same name and instanc name and same built because of master. On this way subscription continue to work normaly afer restoring publisher without creating subscriptions from begining.

Ronen Ariely 15,096 Reputation points

2021-10-30T15:26:54.263+00:00

hi,

everything you said regarding restoring the master is true, but I am not sure what you expect to get more in the forum.

Erland gave you the solution basically. As you can see in the image below you can download it from paid Visual Studio Subscriptions (formally named MSDN Subscriptions). This is the legit way to go. I might be mistaken but I think that there is no other legit way since this version is not supported any more.

Zeljko Matic 1 Reputation point

2021-10-30T17:46:01.923+00:00

Yes I can download in forum for service pack 2 but I need service pack 1 which now is not available

Andreas Baumgarten 97,396 Reputation points MVP

2021-10-30T18:14:51.627+00:00

Hi @ ZeljkoMatic-9614 ,

at https://my.visualstudio.com/ the SQL Server 2008 R2 Service Pack 1 is still available for download: https://my.visualstudio.com/

And as @Ronen Ariely mentioned: It might be the only "official" and legit way to get the file. I didn't know any other option for download.

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Ronen Ariely 15,096 Reputation points

2021-10-30T18:25:47.427+00:00

I searched for Pack 2 instead Pack 1, but the answer is the same.

Yes I can download in forum for service pack 2

I don' understand what you mean "download in forum". Any download which is not directly from Microsoft or directly approved by Microsoft is not legit, and you do not want to lose the license of the product by doing something which is not allowed. The supported of SQL Server 2008R2 is over, but the license still not free :-)
Sign in to comment