question

ZeljkoMatic-9614 avatar image
0 Votes"
ZeljkoMatic-9614 asked Yufeishao-msft commented

SQL Server 2008 R2 Service Pack 1 download

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

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

1 Answer

ErlandSommarskog avatar image
1 Vote"
ErlandSommarskog answered pituach edited

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.)

· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·

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.

145211-image.png


0 Votes 0 ·
image.png (81.6 KiB)

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

0 Votes 0 ·
Show more comments