Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Question 5

Answer C is correct. Single-user startup uses the –m switch. The minimal configuration startup (-f) starts an instance of SQL Server with minimal configuration. The option is useful if the setting of a configuration value (for example, overcommitting memory) has prevented the server from starting. The option enables the sp_configure allow updates option. By default, allow updates is disabled.

For more information, see the following sources:


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint