Chapter 5. Installing or Upgrading SQL Server

by Mark Spenik

IN THIS CHAPTER

  • Installing SQL Server

  • Starting and Stopping SQL Server

  • Installation Troubleshooting

  • Upgrading SQL Server

  • Removing SQL Server

  • Installing Client Tools

  • Configuring Clients

  • Installation FAQ

In this chapter, you walk through the actual installation and upgrade of SQL Server as well as the installation of software for the client PCs. Take a look at what the SQL Server installation program actually loads onto your computer. Following are the directories created from the SQL Server root directory (MSSQL) during installation:

  • BACKUP— Default backup directory

  • BINN— SQL Server, Dynamic Link Library files (DLLs), and client executable files as well as online help files

  • DATA— SQL Server system ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.