We plan to run a web based application with a SQL 2008 R2 back end. We will set up identical configurations on two Servers to run with load balancing.
Sharepoint Foundation is already installed on one of these servers. However, I installed as stand alone and therefore it is using a separate SQL Express instance and I can not use a maintenance plan for backups. Apparently, you must install as a Farm to use the full SQL Server 2008 even if its already installed on your server. On the second server, I started installing as a Farm and said that its for two or more Servers. This set up is really two stand alone Servers, not really a Farm. For this case, would it work to install Sharepoint Foundation as a Farm install so I could use maintenance plan functionality for backups? Thanks,