Hello all expert, I am using sharepoint 2007 since one year, but last week my database get corrupted and i am not able to get my database on server. i am facing huge problem. I think my database get corrupted due to virus attack. Please suggest me what i should do to recover my database. Is any recovery method present in sharepoint or any other option ?Sharepoint recovery

Hi , Do you have any good backup, did you take farm / site backup when site was working fine. or do you have any SQL backupwhen site was working fine. Using SharePoint if you have a good backup then you can restore it using stsadm command and if you have a SQL backup then you can restore it in SQL after that attach it to site. Regards, Pratik Vyas | SharePoint Consultant |

Hi , Do you have any good backup, did you take farm / site backup when site was working fine. or do you have any SQL backupwhen site was working fine. Using SharePoint if you have a good backup then you can restore it using stsadm command and if you have a SQL backup then you can restore it in SQL after that attach it to site. Regards, Pratik Vyas | SharePoint Consultant |

Hi, You need a sharepoint db recovery tool for restoring data from the corrupted database. Hope this solves your problem Joe

hello that's why restore strategies should be explicitly defined and tested in the maintenance phase of the project. But now it is not very useful info for you as I assume. First of all make a full backup right now even if it is broken currently (in order to avoid make situation worse). Then check your sql server backups folder - even of you didn't configure backup scheduling by yourself, it may be configured with sql server installation. In this case you are lucky - as you can attach old database versions to Sharepoint. If there are no existing db backups - check whether you perform stsadm backup operation (if yes - use restore operation ). If there no any backups available (neither database nor Sharepoint) - I recommend to backup current content database and try to restore it using database attach method on another environment. May be something wrong with current environment and problem not in content database itself.Blog - http://sadomovalex.blogspot.com CAML via C# - http://camlex.codeplex.com Graphs visualization in Sharepoint - http://spgraphviz.codeplex.com