Registering a database attaches a separate MDF and LDF file to SQL Server Express. The MDF file is the database file in SQL Server format. The LDF file is a transactional record of actions performed on the database. Attaching the files makes the database available to SQL Server Express. Then, Metrics Management creates a database reference to make the database available to Metrics Management.
The system specialist can use register database to move a Standard database from one server to another. To move a database, first use Copy and backup to create a copy of the MDF and LDF database files. Copy both files to the second server, and use register database to make the database available in Metrics Management.
The SQLServerMSSQLUser group has full permission to the default folder in which the database is originally created. To register the database in another folder, first assign full permissions for the groups to the new folder.
How to register a database
1 Choose File➛Open Servers and Databases.
2 In the main window, select the server on which to register the databases.
3 In the Navigation Pane, choose Setup Tools➛Register Database.
4 In Register Database, shown in Figure 10‑48, choose Browse to specify the destination to save the backup database. Provide a new database name if necessary. Choose Apply.
Figure 10‑48 Providing the path to backup the database
5 In the confirmation message, choose OK. The database appears in the list of databases.
