MS SQL Basics Tutorial: Instance database

SQL Server 2000 has two instance databases (Sample Databases pubs): and Northwind. As with system databases, the files for the instance database are also stored in the Data folder of the MSSQL subdirectories of Microsoft SQL Server (the default installation directory). The instance database contains files as shown in table 6-2:

The pubs and Northwind databases can serve as a learning tool for SQL Server, and the examples in SQL Server Books Online are largely based on these two databases. The pubs instance database stores the basics of a fictional book publishing company. The Northwind instance database contains sales data for a company. This company, known as the Northwind Merchant (Northwind Traders), is a fictitious company engaged in the import and export business of foodstuffs.

If you change the contents of the instance database or accidentally delete the instance database, and want to revert it to its original state, you can run the Instpubs.sql or Instnwnd.sql in the installation directory mssqlinstall with SQL Server Analyzer Program to rebuild the pubs or Northwind database.

Summary of this chapter

This chapter describes the database creation and management knowledge, as well as the basic situation of system database and instance database. Powerful database management features are features of SQL Server, and mastering this chapter is a basic requirement for database administrators.

See the full set of "MS SQL Basics Tutorials"