Unlock instant, AI-driven research and patent intelligence for your innovation.

SQL Server database high-availability technology building method and device, electronic equipment and storage medium

A database and technical technology, applied in the database field, can solve the problems of cumbersome SQL Server database, etc., and achieve the effects of reducing workload, improving work efficiency, and improving accuracy

Pending Publication Date: 2022-07-05
北京汇元网科技股份有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] In order to improve the cumbersome problem of users manually building SQL Server databases, this application provides a SQL Server database high-availability technology building method, device, electronic equipment and storage media

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • SQL Server database high-availability technology building method and device, electronic equipment and storage medium
  • SQL Server database high-availability technology building method and device, electronic equipment and storage medium
  • SQL Server database high-availability technology building method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0066] In order to make the objectives, technical solutions and advantages of the present application clearer, the embodiments of the present application will be further described in detail below with reference to the accompanying drawings.

[0067] The embodiment of the present application provides a method for building a high-availability technology for a SQL Server database, and the method can be applied to a device for building a high-availability technology for a SQL Server database. The frame structure of a SQL Server database high-availability technology building device can be as follows figure 1 As shown, it may include a SQL Server server and a plurality of user terminals, the subsequent SQL Server server is abbreviated as a server, and the user terminal may be a computer or a mobile terminal. Specifically, the execution body of the method can be a server, which is assisted by the terminal. When the server receives a construction request sent by the user terminal, the...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to an SQL Server database high-availability technology building method and device, electronic equipment and a storage medium, and belongs to the technical field of databases, the method comprises the following steps: receiving a building request sent by a first user, the building request carrying a first node address; determining a master node associated with the first node address; creating mirror image information corresponding to the main node based on a preset script file; according to the mirror image information and the first node address, establishing an auxiliary node according to a preset AlwaysOn configuration function, and generating establishment information; and feeding back the building information to the first user. And the SQL server automatically creates the auxiliary nodes for the database, so that the manual creation work of the user is reduced. The method has the effect of improving the working efficiency of the user.

Description

technical field [0001] The present application relates to the technical field of databases, and in particular, to a method, device, electronic device and storage medium for building a SQL Server database with high availability technology. Background technique [0002] At present, with the introduction of the SQL Server database, users can query any data in the SQL Server database through a retrieval method, so as to improve the efficiency of data acquisition by users. [0003] In the related art, when a user creates a new node (that is, a secondary node) in the SQL Server AlwaysOn availability group, the user obtains the file directory of a certain primary node through the operation interface of SQL Server, and then the user selects a certain node (that is, the first node). One node), and copy the obtained file directory to the first node, the user associates with the master node through the node address of the first node (ie the first node address), so that the first node a...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F16/21G06F16/23G06F16/27G06F16/28
CPCG06F16/211G06F16/23G06F16/27G06F16/284
Inventor 吕忠峰高会芳吴妍冰
Owner 北京汇元网科技股份有限公司