Solved

WSS 3.0 Restore of Individual Components from LDF Backup

Posted on 2013-12-11
3
377 Views
Last Modified: 2014-01-21
I am running Sharepoint Services (WSS 3.0) on a Windows 2008 server, with SQL Express 2005.  One of my users just deleted a few components from one of our sites, and they do not show up in the recycle bin.  I have full backups of the server from the day before, so I have the SQL database files (.LDF backup).  I'm trying to find the best way to restore individual components from that backup.  Specifically, some wiki pages.

If I had to restore the whole sub-site, I would not be opposed to that.  This WSS runs our intranet.  The components were removed from our HR site.  So the site name is https://intranet/hr.

Is there a way to restore just the missing wiki pages, or even the entire hr site from the SQL backups?  I have spent a lot of time searching around, and haven't found anything particularly useful yet.

Thanks
0
Comment
Question by:Jake Pratt
  • 2
3 Comments
 
LVL 9

Expert Comment

by:skipper68
ID: 39712310
You can restore the entire database to a different server (dev or test) essentially creating a duplicate copy.  You can then pull the individual pages or you can use STSADM to backup the entire collection from the temporary site and restore it to the original site.

stsadm -o backup -url  <URL name>  -filename  <\\server. name\folder name\file name>  [-overwrite]
stsadm -o restore -url  <URL name>  -filename  <UNC path>

I haven't done this personally but the backup and restore should work.
0
 

Accepted Solution

by:
Jake Pratt earned 0 total points
ID: 39712382
I read those same instructions on a technet site.  What I ended up doing is just stopping IIS and SQL, copying over my .mdf and .ldf files to the SQL folder (renaming the old ones), then starting SQL and IIS.  Luckily there weren't too many changes since the deletion, and backup.
0
 

Author Closing Comment

by:Jake Pratt
ID: 39796463
Found the answer myself.
0

Featured Post

How does your email signature look on mobiles?

Do your employees use mobile devices to reply to emails? With mobile becoming increasingly important to the business world, it is in your best interest to make sure that your email signature looks great across all types of devices.

Join & Write a Comment

Suggested Solutions

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …

708 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now