I have a BE environment comprising of 1 server. It uses an external SQL database in a clustered environment. Even with a cluster setup, the environment is not bullet proof, that is it is prone to failure, thereby bringing down with it the BE server. I do have a server that I can build another BE environment on. Questions...
1. Can i use a built in database and link it anyhow to the one in the sql cluster? if so, how? if not, whats the best approach to this problem?
2. Can the storage be shared by both servers without any issues, that is, can i still use the storage with the clustered BE server?
3. Can the backup sets be shared by both servers; can i restore the backup from one server using the other server?