Microsoft® SQL Server® 2012 Bible

481

Chapter 19: Confi guring SQL Server

19

FIGURE 19-5

Add startup parameters to the SQL Server service to change its behavior.

To add the startup parameters in SQL Server Confi guration Manager, follow these steps:

1. Open SQL Server Confi guration Manager from Start ➪ Programs ➪ Microsoft SQL
   Server 2012 ➪ Confi guration Tools ➪ SQL Server Confi guration Manager.


2. Under SQL Server Confi guration Manager, click SQL Server Services.


3. Right-click the SQL Server service (on the right side) on which you want to add
   startup parameters, and select the Startup Parameters tab.


4. Add parameters individually in the text box, and click the Add button (refer to Figure
   19-5).
   In addition to the standard master database-location parameters, two parameters are par-
   ticularly useful:

■ (^) -m: Starts SQL Server in single-user mode. This is required to restore the master
database.
■ -f: Starts up with a minimal confi guration.
Additional startup parameters are as follows:
■ (^) -d: Includes the full path of the master database fi le, with no spaces between the
d and the path.
■ -l: Includes the full path of the master database log fi le, with no spaces between
the l and the path.
■ (^) -e: Includes the full path of the SQL Server error log fi le, with no spaces between
the e and the path.
c19.indd 481c19.indd 481 7/30/2012 5:42:50 PM7/30/2012 5:42:50 PM
http://www.it-ebooks.info