• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 615
  • Last Modified:

How do I restore a deleted sharepoint site? Root site is still active.

Running WSS 3.0

I accidentally deleted my sharepoint site. I belived I have a SQL backup of the Farm.

I deleted the site under  //server/sites/site
//server/Pages/Default.aspx is still active but is a totally different site.

I need to restore the //server/sites/site that was deleted.

Can I only restore the site from Share point Central Administration? or CLI
Can I just restore everything(farm) from SQL?  
When I created a new site does it auto backup with the farm in SQL?

Thank you.
0
zarroth
Asked:
zarroth
3 Solutions
 
KoenVostersCommented:
You will need to restore the entire content database to a new web application and then export/import it to the new site collection unless you are using third party backup solutions.
You can restore the entire farm if you want but that means that all the recent changes will be gone (as you are restoring the backup from before the site was deleted)
If you create a new site and you have a SQL maintenance plan, the new site will be in the backup the next time you backup.
0
 
zarrothAuthor Commented:
It looks like the data is there. I just did a backup of the Database to check the size. It's about 400MB smaller. Which seems about right for my site. Now the question is How?

The database is called WSS_Content_S2E and I have a full backup of it from the morning before the site was deleted. A little data loss wont hurt me. I have the .bak file. Now I need to know how to restore the database in SQL and have sharepoint see the site again.

Thanks
0
 
sandipkhardeCommented:
If you have back then you can restore entire top level site collection ( //server/sites/site ) fro your database backup.

this //server top level site collection as well //server/sites/site this site collection will have same content database.

by restoring the content database you can bring back entire site.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
sandipkhardeCommented:
I believe you are using MOSS , so

Restore SQL Backup to database server with new name don't delete existing one
Create new web application , it will create temp database for this web application, once web application is created  remove contenet database and add database which you have restored from back.

hope it ll help you.
0
 
navdeepmadanCommented:
one more thing you can do to take the back of your deleted site from the backup database and restore it on  production.
0
 
zarrothAuthor Commented:
Solution:

1. Restored WSS_CONTENT database in SQL of a backup I had.

2. In SharePoint's Central Administration in Application Management under Content Databases. I removed the WSS_CONTENT database then I added the WSS_CONTENT back which in linked to SQL and is now the restored database.

3. Did an IISRESET in Command Prompt.

Ever thing came back up just fine. Thanks Everyone!
0
 
zarrothAuthor Commented:
I did not have to make a new Web Application.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now