source server
Titbits of Sql Server Db Mirroring Using Asp.Net
Your Web Or Windows Apps required many sorts of protections for maltreatments of Data in Database.
For that SQL Server provides you multiple ways to recover your data from loss or tampering. In a recent project my Apps are required to communicate with both Databases that are hosted in a Web Server and a Local Server. This really hampers the speed of the execution. At that time I need to implement a system that will connect the Web DB first then the Local DB if the first attempt fails.
So, browsing the Internet I came to know about Database mirroring. This is actually a technology that ships the data from one server to another.
What I did first was to assume my Web Database Server the primary one (let’s say Server A) and assume the local one as Server B.
Now for the coding part the simple task is to define the connectionstring i.e.
Data Source=Server A; Failover Partner=Server B; Initial Catalog=testDB; Integrated Security=True;
But the database configuration is bit complicated. The requirements are given below:
Server A is in full recovery mode
Server B is created with the full backup of Server A.
Server B is restored in "Restore with Norecovery" model to ensure the synchronous log sequences of both Database Servers.
Both Db in Server A and Server B should have the same name.
Direct access of Server B should be restricted.
The servers or instances occupied in DB mirroring must authenticate each other. Each instance login must have permissions to communicate to the other mirroring server and to its end points.
About the Author
Abhijit is a Software Professional working in India for last 4 years and his expertise is on .Net technologies and Sql Server.
[phpbay]source server, 30, "11211"[/phpbay]
[phpzon]source server, 5, "server"[/phpzon]
CSS counter strike source non steam server tutorial