Mapping Databases to Devices

When databases are created (using either SQL Enterprise Manager or the Transact-SQL CREATE DATABASE statement), they are mapped across one or more devices. This mapping can be changed using either SQL Enterprise Manager or the ALTER DATABASE statement. This section discusses how databases are mapped onto devices, and how this is represented in the system tables in the master database.