Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

WSS 3.0 Restore of Individual Components from LDF Backup

Posted on 2013-12-11
3
Medium Priority
?
447 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
[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
  • 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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

A safe way to clean winsxs folder from your windows server 2008 R2 editions
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

610 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