Re: WSS 3.0 Backup Problems

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



I found the answers with an assist to Mike Walsh. I was looking at
the WSS 2.0 documentation, which is different from the docs for the
WSS 3.0 STSADM utility. The backup and restore documentation for WSS
3.0 is here:
http://technet2.microsoft.com/windowsserver/WSS/en/library/5b36d390-3b11-42eb-9150-95634e9019851033.mspx?mfr=true

A GREAT WSS 3.0 backup script written by Jerry Rasmussen is available
here:
http://blogs.threewill.com/worktogetherbetter/Lists/Posts/Post.aspx?ID=40

Thanks to you both. Great work.

Carl

On Mar 15, 5:23 pm, "Carl" <ccam...@xxxxxxxxx> wrote:
I have a bunch of questions/problems with WSS 3.0 backup, so any help
would really be appreciated. I'm using WSS 3.0 on Windows Server 2003
with the built-in WID/SQL Embedded database. I have two site
collections, one of which is still at the absolute default, and the
other one I've added a few subsites and documents.

1. Backups started from the Central Admin web interface never start.
I'm trying to backup my farm (any part at all) to a local drive (d:
\sharepointbackups) via the Central Admin "Perform a backup"
function. The backups just sit in "Preparing current backup/restore
job" status forever. No log is ever created. The local directory has
Everyone - Full Control permission. I've logged into WSS as a Domain
Admin, which is also a Site Admin of my two sites. I've tried
creating a share and using a UNC path instead, but the backup just
hangs at "Preparing". I can make backups to that directory using
either STSADM or the SQL Management Studio. Any ideas here?
2. Microsoft's backup/restore documentation is unclear on whether
STSADM is enough to restore a site to a new server. These two
documents:http://www.microsoft.com/resources/documentation/wss/2/all/adminguide...http://www.microsoft.com/resources/documentation/wss/2/all/adminguide...
have given me the impression that I need both the STSADM backup AND
the configuration database to restore a site to a new server. The
text from those documents says:
******
This [backup and restore] process is not intended for moving a site to
a new server. If you want to move a site, use the Microsoft
SharePoint Migration Tool (smigrate.exe) instead. [SMigrate doesn't
move permissions, so it's not useful to me as a disaster recovery
tool.]
AND
You have three options for restoring sites from a backup.
a. You can restore a site over an existing site.
b. You can restore a site to a new site on the same server.
[Confusing statement:] c. You can restore a site to a separate server,
with a separate installation of Windows SharePoint Services that uses
a copy of the original server's configuration database.
*****
3. I can't figure out a way to backup more than a single database at a
time from the WID/SQL Embedded database engine. I also can't figure
out how to overwrite databases after x number of days. I could solve
this by creating an individual job for each database on each day, but
there are six databases and seven days in the week, meaning I'd have
to manage 42 separate jobs.
4. I can't back the databases up remotely with Backup Exec because I
can't figure out how to enable remote access to the WID/SQL Embedded
database engine. It appears that you can run the SQL Surface Area
configuration tool with SQL Exrpess, but I can't find a download of
this tool for WID/SQL Embedded. Is it possible to configure remote
access to WID/SQL Embedded?
5. How are other people backing up WSS 3.0 with WID/SQL Embedded?
6. Is the STSADM backup enough to completely restore a site to a new
server, or do you also need the configuration database?
7. Can anyone point me to documentation on exactly what needs to be
done to restore a DB to a new server?

Sorry for all the questions, but I can't deploy WSS until I'm
confident that I have a way to recover it. Maybe it's just me, but
I'm REALLY disappointed in the documentation that's been provided.
Thanks in advance.


.



Relevant Pages

  • Re: Moving SharePoint Site from one machine to another machine
    ... When you backup and restore WSS Web Site, ... (Content Database and Site configuration with WSS 3.0). ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: WSUS and WSS 3.0 broken
    ... Unfortunately the documentation just gave me the command line string but did ... install to its own drive, and it was upgraded from WSUS 2, so I can't say ... WSS uses that database in addition to WSUS, so you're going to have to ...
    (microsoft.public.windows.server.sbs)
  • Re: Backup and Restore of entire site, databases, IIS settings etc
    ... all the hard disks after a backup of the database has been done (using SQL ... Server tools) and saved on one of those hard disks. ... WSS has no snyc problems unlike SPS 2003, ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: WSS 3.0 Migrating database from wmsde to sql server 2005
    ... database to SQL directly. ... Has anyone else out there done this database migration in WSS 3.0? ... different server that is running SQL server 2005. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Mike Walsh - Is there another group or site that might help?
    ... I backup my sites using a backup routine in WSS 3.0 where I backup ... The database is intact in SQL, but when I look at the Manage Content ... It does this for all databases I restore using the WSS Restore Interface. ...
    (microsoft.public.sharepoint.windowsservices)