Sharepoint Portal Server 2003 Backup: Is it even possible?
- From: "Ross Currie" <kilj@xxxxxxxxxxx>
- Date: Mon, 23 May 2005 01:00:10 -0700
Hi,
I've RTFM'ed, read the FAQs, read the newsgroups, read the two sharepoint
books I have next to me and the best I've been able to find out is that
everyone seems to have trouble backing up sharepoint. So, instead of pulling
my hair out or banging my head against a brick wall some more, I thought I
would post in the hope that someone knows a definitive method for backing up
sharepoint.
My scenario:
1 dev server running Sharepoint Portal 2003 with no sites setup.
1 production server running Sharepoint Portal 2003 with a single site.
Want to be able to:
- Backup EVERYTHING on the prod server, including document libraries,
customisations, users... everything. This process needs to be automated.
- restore everything on the prod server to the dev server so that a) we can
prove that the backup works successfully and know how to restore if the prod
server crashes and; b) so that I can create some webparts & do other work on
a dev environment
I have determined that of the 5+ backup methods available, there are two
which seem to be the most promising for me:
- Use SPSBackup.exe to create backup files + restore them later
- Perform a backup of SQL server databases + copy them to dev server
SPSBackup.exe approach:
------------------------------
- Have previously had a successful backup using the GUI
- But needs to be automated, so used an example by Renaud COMTE of how to do
a command line backup:
spsbackup.exe /all /file "c:\SPSbackup" /overwrite
- When run, NO ERRORS are displayed
- After a bunch of frustration, I finally figured out that event viewer was
showing errors. The error being thrown is:
-----------------------
Event Type: Error
Event Source: SharePoint Portal Server Backup
Event Category: None
Event ID: 0
Date: 5/23/2005
Time: 2:46:36 PM
User: N/A
Computer: (removed this)
Description:
The operation described below currently has exclusive write-access to the
SharePoint central database, therefore the task you're attempting cannot run
at this time.
Operation: Backing Up SharePoint Portal Server Components
Current Action: Backup in Progress
Start Time: 5/19/2005 12:01:15 PM
Percent Completed: 43%
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
-----------------------
So, it seems if I can remove the lock on the DB, then I can perform a
successful backup... but how do I do this? Searching for this error on the
groups via google shows a few people with the identical problem, but no
solution posted. Have looked at the locks in SQL server and can't see any
exclusive one that would be relevant.
SQL Server Approach:
-----------------------
- I backup the config database and 3 content databases that I have for my site
- This works fine.. I move them from the prod server to dev server
- Have tried a few ordering of things from here:
o Installing Sharepoint, then reattaching databases
o Reattaching databases, then reattaching Sharepoint
- At one stage, I was able to connect to the configuration database, but not
get my content databases or my site restored.
So what am I doing wrong here? Has anyone got a documented method for doing
an SQL backup?
-----------
So those are my two approaches... hopefully someone has a solution that they
can share with me, because I'm about ready to go teach basketweaving in a
third world country so that I never have to deal with Sharepoint again
--
Small Business Solutions Architect
1337 Internet Solutions
http://www.1337.com.au
.
- Follow-Ups:
- Prev by Date: How do you avoid duplication of Extranet / SharePoint sites doco'
- Next by Date: Re: Sharepoint Portal Server 2003 Backup: Is it even possible?
- Previous by thread: How do you avoid duplication of Extranet / SharePoint sites doco'
- Next by thread: Re: Sharepoint Portal Server 2003 Backup: Is it even possible?
- Index(es):
Relevant Pages
|
Loading
