I have an application server running ms windows 2003 standard edition and ms sql server 2005 standard edition. I have one database which is being used by a .NET based application.
I would like to develop a windows servers or any other solution which could duplicate my database on th server to another mirror server. The data update etc should be real time meaning if a record is changed in one server, it should be automatically changed on the other server as well.
The tool i am looking for should be something generic which could watch the sql server database and any changes made to it should be made in the sql server database on the backup server as well.
I need this to be done by someone professional in developing windows services, sql server and .net.
Message me with your proposal for this.