Subscribe

SQLServer-DBA.com Links

Subscribe to newsletter

Dba_db2_button

Powered by TypePad
How to Install SQL Server service pack silently

12 July,2013 by Jack Vamvas

Installing a SQL Server service pack silently with a script based approach is the aim of all my SQL Server installs. Since SQL Server 2008 the unattended install process has excelled and with added flexibility of scripting frameworks such as  Powershell , there are extra options for customising an install.

Maintaining SQL Server installation scripts assists in Disaster Recovery preparation

Once the script is created , it is easy deploy a service pack or cumulative update upgrade to thousands of servers in a efficient manner.

With a silent install , you have an option of applying the service pack to all instances on the server or just a specific instance

 The /quiet switch runs the update in unattended mode.  

 

--This completes a silent install of a service pack to a specific instance
E:\SQL_2008_R1_SP3\SQLServer2008SP3-KB2546951-x64-ENU.exe  /instancename=MYINST1 /quiet

--This completes a silent install of a service pack to a specific instance
E:\SQL_2008_R1_SP3\SQLServer2008SP3-KB2546951-x64-ENU.exe  /allinstances /quiet

 For a full list of switches check the msdn site

Read More

Encrypting sa passwords during SQL Server Installation

Sql server installation is either corrupt or has been tampered with error getting instance id from name


Off the shelf software and installation prerequisites 


SQL Server – Check SQL Server 2008 Native Client is installed with Powershell get-wmiobject




Author: Jack Vamvas (http://www.sqlserver-dba.com)

******** *******

Subscribe to SQLServer-DBA.com

Latest posts delivered to you daily

Delivered by FeedBurner

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer