529
Chapter 19: Confi guring SQL Server
19
If you insist on changing the recovery interval option, you can either use Management
Studio or T-SQL-code. In Management Studio, you can set the recovery interval
server confi guration option by entering the maximum number of minutes per database to
recover databases in the Recovery Interval (Minutes) box on the Server Properties Database
Settings tab (refer to Figure 19-12).Using T-SQL-code, the following command sets the recovery interval server confi gura-
tion option to 5 minutes:EXEC sp_configure 'show advanced options', '1';
RECONFIGURE;
EXEC sp_configure 'recovery interval', 5;
RECONFIGURE;Summary
Confi guration options are important for compatibility, performance tuning, and controlling
the connection. The confi guration options are set at the server, database, and connection
level. Most of the options can be set from Management Studio and all can be confi gured
with code.Continuing with SQL Server administration tasks, the next chapter focuses on managing
policies.c19.indd 529c19.indd 529 7/30/2012 5:43:15 PM7/30/2012 5:43:15 PM
http://www.it-ebooks.info