Database backups and recovery methods

[marcopolo]

#154206

We have SharePoint 2007 and SQL 2008

Currently we have maintenance plans setup to backup all databases

For the two main databases ‘SharepointIntranet’ and ‘SharepointConfig’ we have set to Full recovery but we are finding the transaction logs are filling up rather quickly.

Originally we had the log configured to the default (2.1tb if I recall) and as such they continued to grow, we ran out of space and realised this was not ideal.

We’ve since cleared down the logs, set them to 1gb, but are again seeing them grow and reacting to this as and when, again this is not the ideal situation.

So here’s my question.

Since we perform full backups of the DB’s which performed every night, is there really a need for full recovery?

Can we somehow force the transaction logs to stop growing (recycle)

I’m thinking maybe this timetime

(full backup) –> (transaction log purged) -> (transaction log required for next period covering working day before the next full backup is performed)

Hope that makes sense if achievable

[Author]

Posts