Updating SQL Server 2008 R2 using slipstreamed source

Question

I have a requirement to create a SQL Server 2008 R2 SP1 setup media. I have done this using slipstream method as recommended by Microsoft. I can only use this to create new installation. But is there a way I can use this media to update an existing SQL Server 2008 R2 instance?

Answer 1

For an existing instance just apply the service pack, if you want to do this without user interaction, do the following:

unpack the downloaded package:

SQLServer2008R2SP1-KB2528583-x64-ENU.exe -x

then start the service pack installation with parameters like:

setup.exe /quiet /allinstances /IAcceptSQLServerLicenseTerms /indicateprogress