I want to know something, i got a server with sql server 2005 on it. Yesterday i had a power supply problem. So i had to wait one day to get the new power supply. So i dont want this to append again. There is a way to work with two server with the same database on it. Ex: my server A is my main server. each time that they have a transaction on it ( insert,update,delete ), it do the replication on the server B. So if something break i just have to change my connection to the server B. Also i was wondering if its possible to work with the two server at the sime time and if i do a transaction on the B, it will do on the A, or if i do transaction on the A it will do on the B

Thanks !