Re: Restoring a SSP 3.0

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



I would do this steps to accomplish what you ask for.

First of all you need to make sure that all accounts are correctly configured and with the right permissions to SQL Server.
Also make sure this accounts are configured correctly in the IIS application pools

then follow this steps:

1. Backup ContentDB in SQL Server using SQL Managagement Studio
2. Restore the ContentDB from step 1 to new env.
3. Install SharePoint on new env.
4. Create a web application using the central administration tool
5. Create a new site collection with a new ContentDB
6. Configure the new web application to use the restored ContentDB
7. Create a new SearchDB or restore the old one and attach it to new SharePoint.

/Daniel Bugday

<chagrinmf@xxxxxxxxx> wrote in message news:1187712628.248151.57320@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Sorry,

Too many acronyms today. Right now I'm working on a MOSS 2007 restore.

I backed up a farm that was all on one box with sql server 2005. I'm
restoring to a new environment that has an AD, sql 2005, and a
sharepoint server. I'm using the built in restore tool to do the
restore. I keep getting an error message:

<DB> failed in event OnRestore. For more information, see the error
log located in the backup directory. SqlException: Cannot open backup
device &#39;<path>\spbr0000\00000017.bak&#39;. Operating system error
3(The system cannot find the path specified.). RESTORE DATABASE is
terminating abnormally.

This message shows up for all the content db's, the search db, and the
shared service db. I've ended up putting everyone full permissions on
the share on the db server (reference via unc) put the SA sql account
in the administrators group, and used various different accounts to
get this done but nothing seems to work.

I've been reading through this newsgroup to find another way to get
this done or if I'm even doing it right.

Any help would be appreciated.



On Aug 21, 9:05 am, "Daniel Bugday" <itkons...@xxxxxxxxx> wrote:
SSP 3.0?

Are you running WSS 3.0 or MOSS 2007?

/Daniel Bugday

<chagri...@xxxxxxxxx> wrote in message

news:1187704241.986622.166220@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

> Hi there,

> I'm a few months new to the sharepoint world. I've got several
> implementations coming up where I'll be taking an SSP 3.0 Portal from
> a customer site and bringing them into our hosting data centre. I've
> been looking at several options to do this.

> I'm testing a full farm backup building an empty clone environment
> then restoring the full farm backup. I keep running into permission
> errors. Access to certain files in the directory is denied. I'm logged
> in as domain admin and unsure as to why i'm receiving these errors.

> Questions:

> 1) Is backup/restore the best way to go about this?

> 2) If so, why am I receiving the permission errors?

> Thanks



.



Relevant Pages

  • Re: Backing Up WSS
    ... Backup and Restore Options for Windows SharePoint Services ... ·Use the Microsoft SQL Server 2000 tools to back up the databases. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Exchange 2003 & NTBackup Restore problems
    ... > have you tried simply dismounting the mailbox store and deleting the ... > remove all mailbox data from the accounts. ... > time than restoring from backup. ... Prepared to perform a restore, from the clean backup, to clean up the ...
    (microsoft.public.exchange.admin)
  • Re: stsadm.exe
    ... Yes, Stsadm will create the site for you on restore, and it will maintain all permissions. ... Stsadm only backups up data that is stored in the database, so any changes you make to the IIS server's file system you'll have to back up via some other method. ... only backup. ... For example, your production environment is IIS/WSS on one server, SQL Server on another. ...
    (microsoft.public.sharepoint.windowsservices)
  • Backing Up WSS
    ... Backup and Restore Options for Windows SharePoint Services ... ·Use the Microsoft SQL Server 2000 tools to back up the databases. ...
    (microsoft.public.sharepoint.portalserver)
  • Backing Up WSS
    ... Backup and Restore Options for Windows SharePoint Services ... ·Use the Microsoft SQL Server 2000 tools to back up the databases. ...
    (microsoft.public.sharepoint.portalserver)