The basic principle used in the mirrored database - this link between two instances of MSSQL server (as a rule, they are two physically server located in a local network or the Internet) and maintenance complete identity of the database on both servers. One of the servers acts as the master, to him connected database users. The second server is a mirror and not supported in this state connections to the database. The main server for changes to the database delivers a mirror with a transaction log by which second base, the mirror is always identical to the core, the main base...
Connection to SQL-server on the network. Using the Windows authentication and SQL Server authentication. In this part of a series of articles described the connection network clients TCU-3 to MS SQL Server 2005. Two options to connect to SQL Server - using Windows Authentication and SQL Server authentication. Attached is a video tutorial that shows the complete sequence of actions described in the article. In a previous article "Installing and Configuring SQL-server. Creating a database and connect to it TCU-3" was demonstrated in local connection TCU-3 to the database located on the MS SQL server...
Installing and Configuring SQL-server. Creating a database and connect to it TCU-3 In this part of a series of articles describes how to install and configure MS SQL Server 2005, and the creation of a database TCU-3 and connect to it. An alternative location TCU on the SQL server. Also attached is a video tutorial that shows the complete sequence of actions described in the article. In the editorial "Network" and "Ultra" TCU supports DBMS companies © Microsoft - Microsoft SQL Server, as well as its free edition - SQL Server Express Edition, which has some technical limitations, but quite suitable for conducting software systems across a small company...

Вверх