How to retrieve file from <name>_SITE database DOC table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi there,

I need to recover 1 particular file, which accidently deleted from
sharepoint portal server.

Since many other files being updated, I can't restore the database from tape
to original location. Now I restored the database to another location,
renamed it & attached back to SQL server.

>From the restored <name>_SITE database DOC table, I located the record by
select * from doc where (leafname = 'filename.ext').

Wondering now how can I recover the file from this record?

Million thanks in advance!



.

Relevant Pages

  • Re: RMAN help
    ... Database mounted. ... RMAN> recover database; ... allocated channel: ORA_DISK_1 ... Starting restore at 11-MAY-06 ...
    (comp.databases.oracle.server)
  • Re: Recovering Inbox Hard Deleted Items
    ... If you can't recover from dumpster, ... that the restored database didn't have any "dumpster" items. ... I need to restore some emails that the user hard deleted from the inbox ...
    (microsoft.public.exchange.admin)
  • Re: WSS Backup Strategy
    ... It works with WSS ... > were forced to recover single users mailboxes for years. ... > capability to restore single documents from its backup. ... >> We have a single Sharepoint server and the database resides in our ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: deletion mistake
    ... Use POINT_IN_TIME restore strategy to recover the tables. ... Take a backup transaction log in current database ... Restore with full backup file with NORECOVERY ...
    (microsoft.public.sqlserver.security)
  • Re: Problem with Server
    ... I would restore to a backup before the problem ... I would guess at the problem being with the database, ... > Very vague subject, ... > Sharepoint Portal server running on a Windows 2000 Server. ...
    (microsoft.public.sharepoint.portalserver)