Re: Backup/Restore for WSS or SPS?

Meggie:

I have just gone through a very difficult restore problem and worked
extensively with MS Product support on this, so I think I can give you a
very clear explanation.

1. Both WSS and SPS store all data in a SQL database. SPS is built on WSS
and extends the configdb and the sites db.
2. Both WSS and SPS backups using SQL server are supported by Microsoft.
3. Both WSS and SPS have backup tools. (stsadmin.exe and spsbackup.exe)
4. While SPS can be restored from SQL backups alone, there are certain
GUID's that are written in both the configdb and the sites db, which must
match. Under certain circumstances these GUID's may be out of sync, making
it impossible to restore from the SQL backup.
5. Therefore, Microsoft **RECOMMENDS** using spsbackup for backup and
restore of portal sites. In addition to backing up the SQL db's, spsbackup
also writes a manifest file and insures that everything is in sync.

The restore process from SQL server when this sync failure occurs in very
painful and I highly recommend that you work on automating the spsbackup
procudure.

John Willard
VA Dept of Transportation

"Meggie" <Meggie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:70B72669-9BC1-4D90-A612-2741CCC24810@xxxxxxxxxxxxxxxx
> Dear all,
>
> Please shed me some lights on the different between backup/restore for WSS
> and backup/restore for SPS Portal Server. I am very confusing here. It
> seems
> to me backup/restore for WSS is exactly the same as backup/restore for
> SPS.
> According to Microsoft articles that using SQL backup/restore is only good
> for WSS, why only for WSS? It can restore my SPS portal site very well
> using
> SQL backup/restore tool. I am confused now; please educate me a little bit
> here the different on both kinds of BACKUP/RESTORE
>
> Thanks.
>


.

Relevant Pages

  • Re: SBS2003 rebuild
    ... An ASR backup/restore is then more likely to succeed than imaging. ... allowing you to reinitialise the array but maintain your current AD. ... and then restore the rest. ... In this context the 'rebuild' takes the existing ...
    (microsoft.public.windows.server.sbs)
  • Re: changing from RAID-0 backup/restore problem
    ... Backup/Restore on different machines. ... Today or tomorrow I shall receive the new disks to mount ... >> restored on that server and now up and running. ... >> Directory and restore on a test environement ...
    (microsoft.public.windows.server.sbs)
  • Restoring SPS 2003 Portal + sites to alternate server using only a SQL Backup
    ... At our organisation we are looking at the usual backup/restore options - i.e. disaster recovery and/or document level restore capability. ... What we actually do at the moment is use Veritas BackupExec Agents to back up the files and system state on the SPS 2003 server, and use the SQL Agent on the backend SQL 2000 Server where all the content is stored. ...
    (microsoft.public.sharepoint.portalserver)
  • Backup/Restore for WSS or SPS?
    ... Please shed me some lights on the different between backup/restore for WSS ... I am very confusing here. ... According to Microsoft articles that using SQL backup/restore is only good ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Restore issues
    ... there's a major difference between Backup/Restore for SPS ... and for standalone WSS mainly because of the number of ...
    (microsoft.public.sharepoint.windowsservices)