Re: How to Restore a single document from Sharepoint 2003

Rob, I'd suggest you query the docs table, the DirName(has the document path) and LeafName(the name of the document) can help get the document. You'll see that DB holds every doc , including ASPX page so make a good search.

That can help you locate the document in your backup database, and then try to insert that manually in the current Sharepoint DB.

Please keep in mind this is clearly unsupported!. So good luck!

Victor



Thank you Victor.

Do you happen to know of a SQL script method to simply query against
the DOCS table to retrieve a document?

"Victor Daicich" <victordaicich@xxxxxxxxxxx> wrote in message
news:12613abe09de8c80f611bf2a0d0@xxxxxxxxxxxxxxxxxxxxxxx

Hello Rob,

You have a couple of options, one is going to 3rd party tools, and
some

others.

You can check some info here:

http://blogs.tamtam.nl/mart/CommentView,guid,ae000c18-30ca-47ef-903f-d
e53e70b7cba.aspx

Victor

I have the Sharepoint 2003 Server backed up at the SQL level and the
file level of the website. I did not use the Sharepoint Backup
Utility.

I just want to restore one file out of the doc table from the SQL
restore that got overwritten by mistake.

Is there a way to do this without re-installing and setting up the
entire Sharepoint Server from this SQL backup?



.

Relevant Pages

  • RE: SQL 2005 Failing Backups Because it Exits The Query Prematurely
    ... it might be a behavior change in SQL 2005. ... SQL 2005 Failing Backups Because it Exits The Query Prematurely ... This same application (which uses ODBC) is able to backup SQL 7.0 and SQL ...
    (microsoft.public.sqlserver.odbc)
  • Re: Sharepoint Portal Server 2003 Backup: Is it even possible?
    ... There are several ways to back up SharePoint. ... Use SQL Enterprise Manager to backup your SQL databases. ... Use the SharePoint Portal Server Data Backup and Restore tool that is ...
    (microsoft.public.sharepoint.portalserver)
  • Re: My query is empty. How do I reestabish relationships to add d
    ... Following is the SQL and a little other information on the 2 queries ... Following the Query is some information on the Customners ... Backup, backup, backup! ... consider posting the SQL statement of the query that isn't ...
    (microsoft.public.access.queries)
  • Restoring SharePoint Portal 2003 & SQL
    ... Create a backup of the SharePoint environment (SQL ... Remove the SharePoint Portal 2003 installation. ... Restore the databases, ... Restore the SQL databases and ultimately the Portal ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Moving portal to another server
    ... new domain, SQL and portal box. ... the Sharepoint Portal using the Sharepoint backup tool and a backup of the ... > Which is the best way to move SharePoint Portal Server 2003 to another ...
    (microsoft.public.sharepoint.portalserver)