Hi,

We have blackpearl databases in SQL Server 2005. Could you please answer the below:

1. Best practices for K2 databases maintenance

2.Out of 14 K2 databases, which are static & which are highly transactional

3.Planning to configurre Log shipping. Does K2 databases support Log shipping? If yes, can we log log shipp all 14 databases? Is log shipping for 14 databases required?

4.Are there any restrictions in Index rebuild, reorganize?

5.Is changing the indexes, fill factor for K2 databases supported?

Basically I would like to have Best practices for blackpearl databases in SQL Server 2005.

Thanks
Ram