I have a VB application that writes to an SQL database. The customer wants the application to write to a second database on a different server as a backup that can be used immediatly if server 1 is down. Before I start modifying my application to save to both databases instead of one, I was wondering if there might be a better way.
Is there some functionnality in SQL Server to keep an up to date copy of my database easily ? Any suggestions ?