we have a database which is about 2Gb in size. Alot of the space is taken up with attachments. This database is replicated to various servers every night.
Does anyone have any ideas for reducing the size of the database to make it more manageable? We had an occassion when it would have been useful to copy the database, but didn't bother since it was so big.
We thought about putting all the attachments in a database of their own, but I'm not sure how to do it - How would a user insert the attachments? How would the first database link to them?
If anyone has had a similar problem, I would be interested in hearing any possible solutions.