Abhijit is a Software Professional working in India for last 4 years and his expertise is on .Net technologies and Sql Server.
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.
- Related Videos
- Related Articles
- Ask / Related Q&A
- Dot Net Questions: System Tables and Sql Server 2000 Query
- New Features in Sql Server 2005
- Sql Server Integrated Services Package Deployment
- Fill Factor & Indexing in Sql Server
- Sql Server Integration Services: Calling Ssis Package in C#
- Sql Server Interview Questions: Store Procedures
- Sql Server Interview Questions on File Server and Client Server Database
- Titbits of Sql Server Db Mirroring Using Asp.Net
What To Get Someone Who’s Got Everything: Efficient Gift Giving 101
By: Oswald Melman | 05/12/2009With the holidays coming around faster and faster each year, or maybe just with a slew of birthdays, special occasions and milestones whizzing by, gift-giving opportunities may have become more than you can handle. Don’t worry; you’re not alone in the gift-giving-spirit slump. With troubling economic times coupled with trying to buy for people who really do have everything, we’re watching dollars flush down the toilet with things like gag gifts, flowers, or simple tokens of appreciation.
Wireless Internet Grows Up
By: Oswald Melman | 05/12/2009If you’re like most people, the internet, and by turns, our mobile devices—laptops, iPhones, netbooks, electronic organizers, PDAs, Blackberries, etc—have become indispensible. We cannot go without them for any extended stretch of time without feeling somehow lost, or deprived. Our modern society thrives on the internet. We shop online, we connect to our friends and family, we get things done via the internet; in fact, entire businesses are operated in virtual space.
What Are You Waiting for to Switch to 4G Wireless?
By: Oswald Melman | 05/12/2009There is nothing more liberating than having an internet connection that lives up to your modern lifestyle, allowing you to lead the kind of life that you know you should be able to lead. Many modern internet users are learning that that means switching on up to the latest in mobile internet access—aka, 4G mobile connections.
Safety First - The Importance of Having a Web Content Filter
By: Jhoana Cooper | 04/12/2009Having a web content filter to screen all the pages that go through your computer is a very important thing. Not everyone will take time to install and set up their own internet filter at home, but this is a very important task to do before you go online. More often than not, there are many problems that can be avoided when you have this in place – especially when there are children – young tots and teenagers alike – around the house who also use the internet.
Usefulness Of Audio Conference In Daily Life
By: Branden Makay | 04/12/2009Audio conference is very important in your daily life. You can control several work by just sitting at home without spending a dime in your conveyance.
Video Conferencing System – A Boon For The Modern World
By: Branden Makay | 04/12/2009Find how you will be benefited from video conferencing system. There are many advantages of installing web video conference set up to stay tuned to the modern world.
Video Conferencing System – A Boon For The Modern World
By: Branden Makay | 04/12/2009Find how you will be benefited from video conferencing system. There are many advantages of installing web video conference set up to stay tuned to the modern world.
Video Conferencing System – A Boon For The Modern World
By: Branden Makay | 04/12/2009Find how you will be benefited from video conferencing system. There are many advantages of installing web video conference set up to stay tuned to the modern world.