Share via

SQL Server 2000 Databases Used by MIIS 2003

  • Article
  • 10/08/2009

Applies To: Windows Server 2003, Windows Server 2003 R2, Windows Server 2003 with SP1, Windows Server 2003 with SP2

The implementation of SQL Server 2000 that is used by MIIS 2003 contains both an MIIS database for use by MIIS 2003 and several SQL Server system databases for use by SQL Server 2000. In addition, a SQL Server 2000 implementation can include several sample databases.

To view the SQL Server system databases and the MIIS database

  1. In Microsoft SQL Server, click Enterprise Manager.

  2. Expand Microsoft SQL Servers, expand SQL Server Group, expand servername (where servername represents the computer on which SQL Server 2000 is running), and then expand Databases.

  3. Click a database to view.

    To view more information about a database, right-click the database, and then click Properties.

MicrosoftIdentityIntegrationServer Database in SQL Server 2000

When MIIS 2003 is installed, a SQL Server 2000 database that is named MicrosoftIdentityIntegrationServer is created within SQL Server 2000. The MicrosoftIdentityIntegrationServer database contains all the metadirectory data used by MIIS 2003, including the following:

  • Metaverse data

  • Management agent data

  • Connector space data

  • Rules extension data

  • Object link data

  • Management agent run profiles

  • Management agent run history

  • Joiner log

The MicrosoftIdentityIntegrationServer database does not contain any of the following:

  • Event log files

  • Contents of the directory at C:\ProgramFiles\Microsoft Identity Integration Server\MaData

  • Administrative scripts

SQL Server 2000 System Databases

In addition to the MIIS database, SQL Server 2000 contains several system databases, which are created when you install SQL Server 2000.

Master   The database that controls the operation of each instance of SQL Server. It is installed automatically with each instance of SQL Server and keeps track of user accounts, remote user accounts, and remote servers with which each instance can interact. It also tracks ongoing processes, configurable environment variables, system error messages, tapes and disks available on the system, and active locks.

Msdb   The database used to store scheduling information, and backup and restore history information.

Distribution   A database on the Distributor that stores data for replication, including transactions, snapshot jobs, synchronization status, and replication history information.

Model   A database installed with SQL Server that provides the template for new user databases. SQL Server 2000 creates a new database by copying the contents of the model database and then expanding it to the size requested.

Warning

Do not delete the SQL Server 2000 system databases. These databases are critical to the core functionality of SQL Server 2000.

Sample Databases

In addition to the MIIS database and SQL Server system databases, your implementation of SQL Server 2000 might include two sample databases: Northwind and pubs. To save disk space in your production environment, you can delete these two databases from SQL Server 2000.

To delete the Northwind and pubs sample databases

  1. In Microsoft SQL Server, click Enterprise Manager.

  2. Expand Microsoft SQL Servers, expand SQL Server Group, expand servername (where servername represents the computer on which SQL Server 2000 is running), and then expand Databases.

  3. Right-click the sample database that you want to delete, click Delete, and then click Yes to confirm the deletion.