Home arrow Library Utilities arrow SQL Server & Library Tools
SQL Server & Library Tools

To open the SQL Server & Library Tools dialog window, choose Library | Library Tools from the main menu tool bar. The SQL Server & Library Tools dialog window contains three tabs:

  • Spectral Libraries

  • Fragmentation Libraries

  • SQL Server

 

Spectral Libraries

 

The Info grid lists all the attached spectral and chromatographic libraries to the SQL Server. Libraries incompatible with the current version of Mass Frontier can be detached or removed from your system via the context menu (right mouse click).

 

In the Update group, you can Compress or Reindex selected libraries to shrink their sizes, or defragment indexes if the performance decreases. Please be aware that these actions may require some time to perform, depending on the amount of stored data.

 

Note:

We strongly recommended you make back-up copies of your libraries before reindexing and compressing fragmentation libraries.

 

 

 

 

Fragmentation Libraries

 

The Info grid lists all the attached spectral and chromatographic libraries to the SQL Server. Libraries incompatible with the current version of Mass Frontier can be detached or removed from your system via the context menu (right mouse click).

 

In the Update group, you can Compress or Reindex selected fragmentation libraries to shrink their sizes, or defragment indexes if the performance decreases. Please be aware that these actions may require some time to perform, depending on the amount of stored data. If you build large fragmentation libraries, these actions should be performed regularly.

 

Note:

We strongly recommended you make back-up copies of your libraries before reindexing and compressing fragmentation libraries.

 

 

 

 

SQL Server

 

Note:

Only use this tab if you are familiar with SQL Server database technology!

 

 

The Monitor group box displays information about the SQL Server status and contains buttons for starting, running and stopping the SQL Server service.

 

The Extended Stored Procedures check box in the Reload group box allows you to redefine the extended stored procedures used by the SQL Server. These procedures are essential for spectra search functionality. Use this action if a library search does not work properly.

 

The Default Library check box in the Reload group box will recreate damaged internal database files. Use this action if the message ”Cannot open library DefMSMSLibrary!” appears.

 

The Connected Libraries check box in the Reload group box will reconnect all the spectral libraries. Use this action if the SQL Server was stopped and restarted outside of Mass Frontier, for example, in the task bar notification area (SQL Server Service Manager).

 

 
 
[ Back ]