Make your sharepoint data loss proof - Backup Strategies

Sharepoint portal is Microsoft's business class portal framework which is also a lucative option as an intranet portal because it supports and is build around the Microsoft Office suite.

Sharepoint is a well Mircorsoft's portal development framework or package for portal development. All the entities of a sharepoint site like lists, documents, pages, links, themes and site information including their data almost everything is stored in a SQL Server 2005.

For managing content and having a solid plan to make your valueable data loss proof, it is important that you follow 3 way backup strategy.

1. SQL Server 2005 DB Level backups.
2. Sharepoint site backups from the Shgarepoint Central Admin.
3. Code level backups. (if you are using your custom user-controls
for highly customized experience in the Sharepoint)

Though there is popular tool called Aveo's to backup the deep level sharepoint entities like list columns, versions, document library and list or list items.

Again, I would like to empahises that the DB level backups should be based on the follwoing approach.
a) Weekly Full backups.
b) Differential backups alternate days.
c) Daily transaction log backups.

Sharepoint Server level backups can be planned as below:
a) Farm Level backups.
b) Site collection level backups.
c) Web application level backups
d) Site level backups

Code Level backups include backing up the Virtual Directories before each time you want to deploy the latest changes in the Server.

I am sure when you carry out this bakcup strategy you will be in a better state to secure your data and recover easily and effectively during the backups.