HELP! Deleted a sharepoint site. Anyway to recover?

[Jim]

I meant to change the link of a sharepoint site and accidentally deleted it
instead. Anybody know how to recover? We have daily backups.

 

[Earl Lewis]

If you restore from a backup from the day before the mis-deed you should recover it. However, you'll lose whatever other updates occured from the backup date/time to present.

Unfortunately, it's very difficult to recover to a past point in time AND keep your updates since then. You want your cake and eat it too, right?

You can do it by incrementally (and tediously) reviewing and applying logs from SQL server but you need to make sure you don't reapply the log that deleted the site to begin with.

Hope that helps.

Earl
I meant to change the link of a sharepoint site and accidentally deleted it
instead. Anybody know how to recover? We have daily backups.

 

[Jim]

I actually received the process from Microsoft on how to recover a single
site. Recovering the entire database was not an option. I was not worried
about any changes since the last backup because this site was attached to a
closed project. The process is as follows:

1. Restore from backup to your development/staging server (assuming that
you have one). We restored the Project Server DB, the Sharepoint DB and the
Sharepoint config DB.
2. Go into the Sharepoint admin and add an additional content server that
is pointed to your restored backup database.
3. Use the stsadm.exe tool to backup the deleted site from backup, which
stores it as a file.
4. Transfer the file over to the production box.
5. Use the stsadm.exe tool to restore the deleted site to production.

Worked great. We restored a single site. On the Microsoft site, there is
an article that helps explain the issue. Here is the link:

http://support.microsoft.com/default.aspx?scid=kb;en-us;889236

Thanks,

Jim

 

[Mike]

Here is the issue:
The OLAP cube was not building prior to today, so we
removed the OLAPAdmin domain account from the local administrators group on
the database server & the Project Server.
We were then able to build an OLAP cube
but now we are unable to view data in the Portfolio Analyzer in PWA. The
message states Unable to access the Microsoft Office project Portfolio
Analyzer OLAP.

 

[Earl Lewis]

Very nice Jim! Gotta put this one in my notebook.

Earl
I actually received the process from Microsoft on how to recover a single
site. Recovering the entire database was not an option. I was not worried
about any changes since the last backup because this site was attached to a
closed project. The process is as follows:

1. Restore from backup to your development/staging server (assuming that
you have one). We restored the Project Server DB, the Sharepoint DB and the
Sharepoint config DB.
2. Go into the Sharepoint admin and add an additional content server that
is pointed to your restored backup database.
3. Use the stsadm.exe tool to backup the deleted site from backup, which
stores it as a file.
4. Transfer the file over to the production box.
5. Use the stsadm.exe tool to restore the deleted site to production.

Worked great. We restored a single site. On the Microsoft site, there is
an article that helps explain the issue. Here is the link:

http://support.microsoft.com/default.aspx?scid=kb;en-us;889236

Thanks,

Jim