Properties
Reading time ~2 minutes
In the "Properties" window, a detailed information on a current database is displayed:
Cinegy Archive
-
Database Alias – a user-defined name of the current Cinegy Archive database;
-
Database Build – the current Cinegy Archive database build;
-
Database Name – the current Cinegy Archive database name;
-
Database Version – the current Cinegy Archive database version;
-
SQL Server Instance – a name of the SQL server hosting the current Cinegy Archive database;
-
User logged On – the name of the user logged on to the current Cinegy Archive database.
Common
-
Compatibility level – a compatibility level of the current Cinegy Archive database;
-
Database collation – a collation of the current Cinegy Archive database;
-
Database creation date – the date and time of the current Cinegy Archive database creation;
-
Database State – the current state of the Cinegy Archive database;
-
Full-Text enabled – a state of the full-text search in the current Cinegy Archive database;
-
Recovery model – the model of the current Cinegy Archive database recovery;
-
SQL Broker enabled – a state of the service broker in the current Cinegy Archive database;
-
Status – the status of the current Cinegy Archive database;
-
User access mode – the mode of user access defined for the current Cinegy Archive database.
Important
|
Please refer to the Microsoft SQL Server documentation for more guidelines and best practices on these parameters management. |