SQL Server β a unique product that can work with a huge number of information bases, performs the functions of programming and administration.
Administration of the sql server provides for the development of an information base system, the creation of a security system, the compilation of a database, objects, makes it possible for users to access the information available in the database.
The administrator periodically creates backup copies, checks the integrity of the information system, controls the allowable size of information files and the transaction log.
DB is a named set of interrelated components
This database is managed by a special system, which is a complex of language and software tools that keep it up to date and organize a quick search for the necessary information.
Structuring the database
To organize a high-quality information base, the administrator must approach responsibly, thoroughly study the many options for using the available information, provide for possible integration with other systems and access, as well as using modern technologies, making the required changes to the system.
SQL server administration is carried out in two versions
The first is a file server, in which the database is located on a file server, it provides storage of the infobase and access to it by clients working on different computers. Processing is performed at workstations where database files are transferred. Clients' personal computers have a control system that processes the transmitted information.
The client-server version, in addition to safety, processes the entire amount of data. The request sent for execution, issued by the client, provokes the search and extraction of the necessary information. This information is transported over the network from the server to the client.
The client-server consists of two parts: client and server.
The client is located on a personal computer, it performs the functions of providing a graphical interface.
The server part is located on dedicated server and contributes to the provision of information sharing, information base management, administration services and security measures.
The client-server system is characterized by the use of a special language technique that structures queries and also provides effective tools for accessing the database.