?
Solved

WSS 3.0 Restore of Individual Components from LDF Backup

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
A safe way to clean winsxs folder from your windows server 2008 R2 editions
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 …
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…

569 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