Re: Sharepoint Portal Server 2003 Backup: Is it even possible?

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

I wasn't looking at the locks when I used it. I had locked everyone out so
that I knew that no users were in there. You say that you have looked thru
the locks in SQL ... it has to be there, but the question is where. So sorry
that I didn't realize that the sbsbackup.exe was the same as the GUI
interface that I was using. You helped me and I feel badly that I didn't help
you more. Thank you and good luck.

"Ross Currie" wrote:

> One of the books is the MS Press "Sharepoint Products and Technologies"
> Resource Kit (2004)... the other I believe was a SAMS book, though someone
> else has since borrowed it (the owner took it back), so I can't say for
> certain.
>
> What you say about the SQL server backup makes sense to me - to do it you'd
> almost have to detach the database everytime you wanted to back up the site..
> something that is probably hard to automated.
>
> Which I suppose is why SPSBackup write-locks the database.. so now the
> question is - how do I unlock the locked database?
>
> --
> Ross Currie
> Small Business Solutions Architect
> 1337 Internet Solutions
> http://www.1337.com.au
>
>
> "Manfred" wrote:
>
> > Which two books do you have ?
> >
> > The Resource Kit says that SQL backup isn't enough because you can't
> > guarantee that all the backups of the different databases are taken at
> > exactly the same time (with the same matching data) [paraphrasing]. So they
> > say use SPSBackup.
> >
> > Manfred (trainee basketweaver)
> >
> >
> > "Ross Currie" <kilj@xxxxxxxxxxx> wrote in message
> > news:AFE77096-3C49-49E5-8B75-BB7542C6279D@xxxxxxxxxxxxxxxx
> > > 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
> >
> >
> >
.

Relevant Pages

  • Re: Sharepoint Portal Server 2003 Backup: Is it even possible?
    ... One of the books is the MS Press "Sharepoint Products and Technologies" ... What you say about the SQL server backup makes sense to me - to do it you'd ... Which I suppose is why SPSBackup write-locks the database.. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Sharepoint Portal Server 2003 Backup: Is it even possible?
    ... vagueness of sharepoint backup. ... >> almost have to detach the database everytime you wanted to back up the site.. ... >> Small Business Solutions Architect ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Old question: backing-up & restoring SharePoint database?
    ... I'm still looking for an official docs from Microsoft, on how to backup & ... I just can't believe it if Microsoft ... Data Protection and recovery for Office SharePoint Server ... I'm still not sure it's for SharePoint's database, ...
    (microsoft.public.windows.server.sbs)
  • Re: Premium SQL Sharepoint to Standard MSDE Sharepoint?
    ... I assume you used the SQL files and not the SBS ... I replaced the files from my SQL Sharepoint restore over the newly ... Unable to connect to database. ... I should mention that my backup of the original Sharepoint database was ...
    (microsoft.public.windows.server.sbs)
  • RE: transfer companyweb config db
    ... configuration database for sharepoint services to a new location on the sql ... You may mistake SQL server conception. ... Move the Monitoring Database ... >project web access not working correctly is to use a config database on ...
    (microsoft.public.windows.server.sbs)