Solved

WSS 3.0 Restore of Individual Components from LDF Backup

Posted on 2013-12-11
3
409 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

861 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