I need to sync to Databases
I want to create an environment where I have a database on one server and replicate (backup) db on another. The two need to synchronize data, i.e. if I add data to one database it's added to the other. If my main db falls I would like to fall back to the backup, however, and this is important, I don't want to lose the data that I entered into the backup db when I revert to the main once it's fixed. For example let's say I am adding users and my main db falls. I revert to the backup db while I fix the problem. I fix the problem and revert back to the main db. i don't want to lose the users I've added to the backup DB. However 99% of the time my main db is up and replicating to the backup db.

**I am using SQL Server 2008**
I need to sync to Databases
===

I want to create an environment where I have a database on one server and replicate (backup) db on another. The two need to synchronize data, i.e. if I add data to one database it's added to the other. If my main db falls I would like to fall back to the backup, however, and this is important, I don't want to lose the data that I entered into the backup db when I revert to the main once it's fixed. For example let's say I am adding users and my main db falls. I revert to the backup db while I fix the problem. I fix the problem and revert back to the main db. i don't want to lose the users I've added to the backup DB. However 99% of the time my main db is up and replicating to the backup db.

**I am using SQL Server 2008**