Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2011-03-15
7
Medium Priority
?
610 Views
Last Modified: 2012-08-14
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
Comment
Question by:zarroth
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 14

Expert Comment

by:KoenVosters
ID: 35144079
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
 

Author Comment

by:zarroth
ID: 35144387
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
 
LVL 8

Accepted Solution

by:
sandipkharde earned 248 total points
ID: 35144505
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
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 8

Expert Comment

by:sandipkharde
ID: 35144513
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
 
LVL 5

Assisted Solution

by:navdeepmadan
navdeepmadan earned 252 total points
ID: 35144631
one more thing you can do to take the back of your deleted site from the backup database and restore it on  production.
0
 

Assisted Solution

by:zarroth
zarroth earned 0 total points
ID: 35172546
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
 

Author Closing Comment

by:zarroth
ID: 35205041
I did not have to make a new Web Application.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question