Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Restore WSS to retrieve Document library

  Asked By: Srikant    Date: Nov 01    Category: Sharepoint    Views: 1649

Can anybody explain the steps required to restore a WSS site so I can
recover a document library.

We have full tape of SQL SERVER DATA.

Share: 

 

6 Answers Found

 
Answer #1    Answered By: Megan Martin     Answered On: Nov 01

Can anybody help with this one? Can any supply a URL that provides a
solution?

 
Answer #2    Answered By: Donta Kirkland     Answered On: Nov 01

I’m assuming that these SQL Server tapes are a backup of your content database. The bad news is if you just restore  this database, you will lose data  in any other sites that has been changed since the backup. If you have critical sites, you might want to use smigrate to create more granular backups. Just a thought for the future.

You don’t say how large this document  library is, but I had to do something similar last week. (a few documents missing from an enterprise portal). So what I did was restore the DB to an alternate location and pick the missing documents out of the Docs Database in PORTALNAME_SITE Database (assuming you have Portal Server). This script will work well for one or two, but if you are restore more than a dozen documents, you might want to add another loop to identify them, and restore them all.

I hope this points you in the right direction.

---------------------------SCRIPT START----------------------------

Dim cn 'As ADODB.Connection

Dim rs 'As ADODB.Recordset

Dim st 'As ADODB.Stream

'Create a new connection object

Set cn = CreateObject("ADODB.Connection")

'Specify connection information

cn.ConnectionString = "Provider=SQLOLEDB; Data Source=DatabaseServer; Integrated Security=SSPI; Initial Catalog=DatabaseName"

'Establish the connection

cn.Open

'Execute the command and retrieve  the returned recordset

Set rs = CreateObject("ADODB.Recordset")

rs.Open "select LeafName, Content from Docs where Id='DocumentID'", cn, 0, 1

'Initialize the stream object used to persist to a file

Set st = CreateObject("ADODB.stream")

st.Type = 1

st.Open

'Write the value of the field to the stream

st.Write rs.fields("Content").Value

'Save the content of the stream to a file

st.SaveToFile("c:\" & rs("LeafName").Value)

'Close the stream

st.close

'Close recordset and connection

rs.Close

cn.Close

'Free resources

Set rs = Nothing

Set st = Nothing

Set cn = Nothing

---------------------------SCRIPT END------------------------------

 
Answer #3    Answered By: Cade Velazquez     Answered On: Nov 01

We have three enviroments interally

Pre-Development, Development and Production.

I was afraid the answer was going to be to restore  the Content DB,
but that is way the cookie crumbles.

 
Answer #4    Answered By: Ariana Christensen     Answered On: Nov 01

We have three enviroments interally

Pre-Development, Development and Production.

I was afraid the answer was going to be to restore  the Content DB,
but that is way the cookie crumbles.

 
Answer #5    Answered By: Darrius Whitfield     Answered On: Nov 01

The best way I’ve found to restore  files is to restore your content database to a separate database and use James Edelen’s SharePoint Database Explorer. This lets you dive into the database (remember this is for restoring from a separate database – don’t use it to connect to your live database). The tool lets you drill down to the document  library you want to restore, and lets you select which files and versions you want restored. It’s a great utility!

www.mindsharpblogs.com/.../SharePointDBExplore.zip

Blog article:

mindsharpblogs.com/.../189.aspx

 
Answer #6    Answered By: Adrienne Greene     Answered On: Nov 01

This is my preferred way as well. There are also third party tools that
let you do a single file restore.

 
Didn't find what you were looking for? Find more on Restore WSS to retrieve Document library Or get search suggestion and latest updates.




Tagged: