Sharepoint 2007 site collection

Question

Hi i have a serious problem, just set up a sharepoint group and this is now causing problems. In 7months it has grown to over 200gig and bricks back up are impossible.

Serious information store legal stuff

1. one single site collection how do we split and not effect live
2. how do i remove the documents and .jpg out of the db - replace with hyperlinks

Thanks Already

MJ

Answer 1

We had a 3rd party into to develop the share-point service, This is really a very difficult situation not the solution but the documents that are stored and the way it was retrieved.

The real thing is that we receive an item it is booked into SAP and then we send an automated xml to set up a local site this site will then have details from the SAP system fed by ABAP. After the site is created, and then we add documents files and .jpg. These documents must show a detailed audit trail so that if challenged in a court of law can show who had access and who updated documents.

SO the problem is

1 Site Collection that is 170gig and the design means that we have 1600 sites and these contain images that are stored in the single site collection. How do we remove the full documents and images and replace with links rather than the doc, img.

1. We have around 8 business units the problem is that they can share information across the units. If we add this like task manager these cannot be shared across site collections.

2. We have purchased K2 Blackpearl and K2 Connect any ideas on the performance and abilities of these.

Thanks

MDJ