Primary server-side services in SQL Server in SBS 2003 [Windows Small Business Server 2003 Best PRactices]

Hiya – I am the authot of the above title and I like to hold a daily virtual book reading! Today we look at the services running for SQL Server on the SBS 2003 box.

Primary SQL Services

MSSQLServer. This is the SQL Server engine as you know it, the piece that processes the SQL statements (officially known as Transact-SQL). This service also allocates server resources (such as memory), manages the tables (for example, prevents collisions between users), and ensures the integrity of the data (via various tests).

Microsoft Distributed Transaction Coordinator. This is a service which acts as a traffic cop, managing the sources of data that compose a transaction.

SQLServerAgent. This is a service that manages scheduling activities and sends alerts.

Microsoft Search. This is an indexing-related service used by SQL Server 2000 and other SBS 2003 components (such as the Find com­mand in Windows Server 2003.

MSSQLServerOLAPService. This service relates to the online analyti­cal processing capabilities of SQL Server 2000. This service auto-starts when the underlying Windows Server 2003 operating system starts.

The SQL Server 2000 Services are displayed and managed via the SQL Server Service Manager displayed in Figure 14-2.

Figure 14-2

SQL Server 2000 services can be stopped, started, and configured via the SQL Server Service Manager tool.

The following SQL Server system databases are automatically constructed when SBS 2003 installs SQL Server 2000:

Master. This is the mother of all tables in SQL Server. Lose it (with no back up) and you’ll die. Simply stated, it controls SQL Server opera­tions completely (including user databases, user accounts, environmental variables, system error message, and so on). It is critical that you back up this database on a regular basis.

Model. A template provides basic information used when you create new databases for your own use. This is akin to the metainformation you entered when you installed SBS 2003 (company name, address, fax, and telephone numbers) that reappears each time you add a user, via one of the SBS consoles, to your SBS network. You might recall that I defined metainformation early in this book in the middle of Chapter

3; it is information that is used globally by the computer system, not just in one place.

Msdb. The SQLServerAgent uses this for scheduling and job history.

Tempdb. This is another database that’s very important to the opera­tion of SQL Server. It’s a temporary storage area used by SQL Server for working storage. This is akin to the paging file used by Windows Server 2003 (the underlying operating system in SBS).

Northwind. Consider using this sample database as the prototype for developing your own company database. This is an addition in SQL Server 2000 that wasn’t present in prior versions of SQL Server. This was the sample database in Microsoft Access and is the “standard” sample company used in Microsoft Official Curriculum (MOC) train­ing courses for MCSEs.

Pubs. Yet another database used in most of Microsoft’s SQL Server manuals, including the wonderful online books!


Harry Brelsford, CEO at smb nation

Microsoft Small Business Specialist SBSC, MBA, MCSE, MCT, MCP, CNE, CLSE, CNP

PS – did u know I host a technology conference in the New York City area each spring? Save the date for March 6-8, 2009 and watch “voice meet data” in the SMB space!

PPS – my SBS 2008 book will be out in mid-November 2008!

PPPS – my Microsoft Response Point Primer book is here NOW!


Leave a comment

Filed under Book

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s