Multiple Caching db? How to proceed?

Apr 8, 2009 at 8:46 PM
I've come across the need to have two Sharepoint Farms on a SQL 2005.  I have the MOSS Faceted Search install on the first farm already.  It is version 2.0 and currently in production.  I'm in the need of installing Facets 2.5 on the same SQL server on a different Farm which will be the future search center.  Any suggestions on how to proceed as far as the 'Caching" db?

Can I rename the db to Caching2?  If so, where would I need to update the information to point to the correct db in the 2nd farm?

Can I just use the Current Caching db in both farms with version 2.0 and 2.5?

Can I drop the first Caching db and recreate with 2.5 and have both farms work?

Other suggestions?

Thanks in advance for any help you may provide.

Paul
Coordinator
Apr 8, 2009 at 11:11 PM
You can have as many databases as you need (with different names). Each DB will require a connection string defined in web.config, and that's it. Just to understand, do you have 2.0 with caching?
Apr 9, 2009 at 5:08 AM
Thanks for the response.  I renamed the db and all appears to be working fine!  I also was mistaken.  I had upgraded the first server farm from 2.0 to 2.5 quite some time and had forgotten.

Paul