Re: Extracting Docs from the SPS DB

Tech-Archive recommends: Fix windows errors by optimizing your registry

Backup up the SQL databases using the standard SQL Enterprise Admin and also
run a Sharepoint backup which you can find in program files - Sharepoint -
backup / restore.

--
Steve Smith

UK Sharepoint Training
http://www.combined-knowledge.com/sharepoint_knowledge_tracks.htm


"Dan" <Daniel.hogsed@xxxxxxxxxx> wrote in message
news:1132347427.732981.237450@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi All,
>
> Sorry I am not very SQL savy and I have an SPS install I just inherited
> from a new job. Problem is we want to be sure we get all the docs from
> the content DB (the docs table I think) before we do anything that may
> jeopardize the server.
> Any advice?
>
> Thanks!!
>


.

Relevant Pages

  • 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)
  • 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)
  • Re: Premium SQL Sharepoint to Standard MSDE Sharepoint?
    ... I assume you used the SQL files and not the SBS ... I replaced the files from my SQL Sharepoint restore over the newly ... Unable to connect to database. ... I should mention that my backup of the original Sharepoint database was ...
    (microsoft.public.windows.server.sbs)
  • Re: How to Restore a single document from Sharepoint 2003
    ... Rob, I'd suggest you query the docs table, the DirNameand LeafNamecan help get the document. ... That can help you locate the document in your backup database, and then try to insert that manually in the current Sharepoint DB. ... I just want to restore one file out of the doc table from the SQL ...
    (microsoft.public.sharepoint.portalserver)