popular question, i guess. sharepoint backups...aarrgghh!!

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

From: Steve (daryn_at_blahblahntlworld.com)
Date: 07/06/04 

Date: Tue, 06 Jul 2004 16:13:25 +0100

Hi..

Couldnt find a faq in this group so am asking instead.. have hunted on
the web and found a number of solutions but being a complete
sharepoint muppet, not many of them apparently work, so apologies if
this is in the faq for the group.

A sharepoint team services server has been dumped in my lap with 6
sharepoint-enabled virtual servers installed on it. Recently, we had
to move the sharepoint stuff to another server since the original was
dying so it fell to me to make sure the web sites were moved
successfully.

one way I found to accomplish this (barely) was using smigrate.exe in
the form of:

smigrate -r -w http://www.blah.com -f sharepoint1backup.bak.fw
p -u username -pw password

and this created fwp files that could apparently be restored to the
same server using smigrate again.

another was to just manually create .bak files using the
backup/restore pages in the sharepoint site administration pages.

Both of these files wouldnt restore onto the new server and in the
end, I had to ask the hosting company that the servers were hosted
with to take a hand and they informed me that the bak files had to be
installed onto the new server with MS Sql Server.

Everything was happy. I had no idea how they had got the database
files back onto the new server but after we copied the web html files
over , it was all happy doody.

Now, we want to run a scheduled backup every day of the database and
the actual web files and ftp it or something over to another server.

I'd use smigrate but never tested the fwp restore function (cant
restore to another server and scared sh*tless of restoring them on the
live one) so aint too sure about it.

Using the stsadm.exe, a' la script file:

cd \Program Files\Common Files\Microsoft Shared\Web Server
Extensions\60\BIN

stsadm.exe -o backup -url http://www.blah.com -filename
d:\sharepointbackups\www.blah.com.dat

brings up the error :

The virtual server that is referenced here is not in the config
database.

which means absolutely squat to me and I cant find anything on the web
referring to it.
(hell, it took me a little under a week to discover we had team
services and not portal services, i know that little about sharepoint)

So.. I place myself in your hands. Could _anyone_ help with this prob?

I need to know what command to run to backup the database of a
specifid sharepoint ts site on a server.

I need to know (this isnt neccessary since i can get the hoster's to
do it for me but it'd be nice to know) how to restore the damn things
to either a formatted original server or a completely different
server.

I need to know why this godsforsaken web app doesnt have the slightest
idea what "user friendly" is when you want to move beyond point and
click!! AARRGGH!!

-slaps himself-

ah. thats better. needed that.

Any ideas, peeps? thanks in advance for any answers winging my way.

Steve

Relevant Pages

  • Re: Restore individual files in sharepoint
    ... the item to the live SP server. ... To enable recovery of individual SharePoint files ... Use the following procedure to schedule a task to enable you to restore ... If you do not want a duplicate of your SharePoint database in your backup, ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Backups and file storage
    ... Have you ever performed any actual disaster recovery content database ... here's a link to Veritas' agent for Sharepoint Portal Server 2003 ... or by using SharePoint's Backup and Restore utility that can ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Problem with disable msde connection pool
    ... 'ALTER DATABASE TestDB SET single_user WITH ROLLBACK after 10 ... ' Restart the server... ... ' Execute query through SQLDMO to run the restore TSQL command ... the connection pool must be disabled. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Restore public folders and companyweb
    ... I understand that the Public Folder Store ... > database cannot be mounted due to integrity problems, ... > the pub.edb database from your backup of the old Server, ... please try the following steps to restore your public ...
    (microsoft.public.windows.server.sbs)
  • RE: Sharepoint Database already exists?
    ... How to back up and restore http://companyweb data in Windows Small Business ... You can remove and reinstall SharePoint. ... How to remove and how to install the Windows Small Business Server 2003 ... The Microsoft Active Directory directory service domain database has not ...
    (microsoft.public.windows.server.sbs)