This is a mirror of official site: http://jasper-net.blogspot.com/

How to: Install SQL Server 2008 from the Command Prompt

| Sunday, March 21, 2010
Installing a new instance of SQL Server at the command prompt enables you to specify the features to install and how they should be configured. You can also specify silent, basic, or full interaction with the Setup user interface.

 When installing through the command prompt, SQL Server supports full quiet mode by using the /Q parameter or Quiet Simple mode by using the /QS parameter. The /QS switch only shows progress, does not accept any input, and displays no error messages if encountered. The /QS parameter is only supported when /Action=install is specified.

Command prompt installation is supported in the following scenarios:

   * Installing, upgrading, or removing an instance and shared components of SQL Server 2008 on a local computer by using syntax and parameters specified at the command prompt.
   * Installing, upgrading, or removing a failover cluster instance.
   * Upgrading from one SQL Server 2008 edition to another edition of SQL Server 2008.
   * Installing an instance of SQL Server 2008 on a local computer by using syntax and parameters specified in a configuration file. You can use this method to copy an installation configuration to multiple computers, or to install multiple nodes of a failover cluster installation.

When you install SQL Server at the command prompt, specify Setup parameters for your installation at the command prompt as part of your installation syntax.

 For local installations, you must run Setup as an administrator. If you install SQL Server from a remote share, you must use a domain account that has read and execute permissions on the remote share. For failover cluster installations, you must be a local administrator with permissions to login as a service, and to act as part of the operating system on all failover cluster nodes.

Read more: MSDN

Posted via email from jasper22's posterous

0 comments: