Hello. I create a site in the My Site. THis site had a document library w/ 1 file in it. The Document Library was deleted. Is there any way to recover the document library or more importantly the file that was in it? THe only backup I have is a full database backup from Veritas.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Need to restore document library
- Thread starter Jaminj
- Start date
- Thread starter
- #3
LordJohnson
Technical User
Jeff Dunmall has written a VB script for recovering a file from a WSS/SPS database.
If you need to ever extract a file manually out of WSS/SPS, this is how you do it:
1) Find the right row. Everything is in the DOCS table, and there is a DirName property that you can use to find it based on a relative path. Something like this will work.
SELECT *
FROM Docs
WHERE (DirName LIKE 'sites/showlett/Shared Documents%')
2) From there, grab the ID guid. Save the following to a local .vbs file, and replace the servername, database name, GUID and filename.
Set cn = WScript.CreateObject("ADODB.Connection")
cn.Open "Provider=SQLOLEDB;data Source=SERVERENAME;Initial Catalog=WSS or SPS SITE DB name;Trusted_Connection=yes"
Set rs = WScript.CreateObject("ADODB.Recordset")
rs.Open "Select content from docs where id='{guid goes here}'", cn
Set mstream = WScript.CreateObject("ADODB.Stream")
mstream.Type = 1
mstream.Open
mstream.Write rs.Fields("content").Value
mstream.SaveToFile "c:\filename goes here", 2
rs.Close
cn.Close
If you need to ever extract a file manually out of WSS/SPS, this is how you do it:
1) Find the right row. Everything is in the DOCS table, and there is a DirName property that you can use to find it based on a relative path. Something like this will work.
SELECT *
FROM Docs
WHERE (DirName LIKE 'sites/showlett/Shared Documents%')
2) From there, grab the ID guid. Save the following to a local .vbs file, and replace the servername, database name, GUID and filename.
Set cn = WScript.CreateObject("ADODB.Connection")
cn.Open "Provider=SQLOLEDB;data Source=SERVERENAME;Initial Catalog=WSS or SPS SITE DB name;Trusted_Connection=yes"
Set rs = WScript.CreateObject("ADODB.Recordset")
rs.Open "Select content from docs where id='{guid goes here}'", cn
Set mstream = WScript.CreateObject("ADODB.Stream")
mstream.Type = 1
mstream.Open
mstream.Write rs.Fields("content").Value
mstream.SaveToFile "c:\filename goes here", 2
rs.Close
cn.Close
I have quick question. I am very new to sharepoint. I have created several lists and I want these lists to appear on the actual page. Instead it is giving an overall summary and it will only let you view details in an excel spreadsheet. Does anyone know what I have done wrong? Please help me...
meastaugh1
Technical User
- Apr 21, 2002
- 316
I realise this doesn't help the original poster, but you may want to look at Sharepoint Recycle Bin. I've been playing with it today and it looks very good. It's an ISAPI filter which intercepts delete requests and drops them in a specified flat folder (eg c:\recyclebin) on the SP server.
The Delete Items Document Library also looks impressive, and it allows users to restore their own deleted documents.
The Delete Items Document Library also looks impressive, and it allows users to restore their own deleted documents.
- Status
Similar threads
- Locked
- Question
- Locked
- Question