WSS 3.0 Restore of Individual Components from LDF Backup

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
Jake PrattAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Jake PrattConnect With a Mentor Author Commented:
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
 
skipper68Application Development ManagerCommented:
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
 
Jake PrattAuthor Commented:
Found the answer myself.
0
All Courses

From novice to tech pro — start learning today.