backup and restore of files in sharepoint

[bj daniels]

I have been reading the documentation and playing with the product, but I
havn't seen how to backup and restore a particular document in a document
library. I would like to start piloting this in my organization, but I am
very nervous if I cannot respond to a call that a particular document was
deleted last night can I restore from backup (which is something I do quite
often on the file servers).

thanks

bj daniels
dani...@gunnery.org

[Mike Walsh [MVP]]

This has just been discussed in another thread.

You can't.

Until a backup vendor provides document level restores (none of them do at
the moment), you have to restore the entire data base in order to get one
delted document back.

(Roughly the same situation that Exchange was for a long time with
individual mail messages).

The only way round this is to impose versioning and hope there was an older
version made than the one deleted.

Mike Walsh, Helsinki, Finland
WSS FAQ at wss.collutions.com
Please post questions to the newsgroup only.

"bj daniels" <dani...@gunnery.org> wrote in message
news:OlHVgYe1...@tk2msftngp13.phx.gbl...

[bj daniels]

thanks for the quick reply. That really is a shame, since the product is so
nifty I would really like to start using it, but lack of a simple backup /
restore routine is a 'deal-breaker'. Can't take chances when everything is
'mission critical'.

bj

"Mike Walsh [MVP]" <englant...@hotmail.com> wrote in message
news:uWL6Vge1...@TK2MSFTNGP09.phx.gbl...

[cyberpunk]

bj,

not trying to sound like a smart a**, but its been my experience that if an
IT person finds themself doing a lot of file restores then its time to get
the users better trained. I was in this boat myself a few years ago and
some emails to supervisors and better user training solved a lot of these.

Just my 2 cents.

"bj daniels" <dani...@gunnery.org> wrote in message

news:O30Ucme1...@TK2MSFTNGP11.phx.gbl...

[bj daniels]

quite often may be an exageration (1 / month) - and this is a high school,
and students are not always as careful as they might be. Regardless, having
to setup a backup server and do a restore just to find one document, even
1/quarter would be a royal pain.

Basically, I don't feel comfortable unless I can do a granular restore.

bj

"cyberpunk" <bl...@anon.com> wrote in message
news:ujzihBf1...@tk2msftngp13.phx.gbl...

[jeter...@hotmail.com]

bj, we use a webpart that allows documents to become
undeleted.

>.
>

[Steven Collier [MVP]]

That webpart is for SharePoint Portal 2001, not the new 2003 product.

Some people address this issue in 2003 by using the smigrate tool to export
all them teamsites each night, and then if they need ot recover they can
bring back just one workspace as a different name on the same server and
retrieve the data.

--
Steven Collier

SharePoint Portal Server MVP

[Bill English [MVP]]

We have a script for the resource kit that, if we can get it tested, will
copy documents out of a doc lib to a file system for backup purposes. The
lack of per item backup/restore as well as permissions is a negative that
the product team has heard loud and clear. I'd be willing to bet large
dollars that feature will be included in the next version of SPS.

The lack of per item backup/restore should not be a deal killer. Just keep
and offline server around to do the restores on and then grab the individual
file and copy it back to the doc lib. This is really no different, in
principle, than what we had in Exchange 5.5 lacking individual mailbox
restores. People worked around the issue and got is solved.

--
Bill English, MCSE, MCT, MVP, MCSA, GSEC
https://www.sharepointsummit.com
sharepointdiscu...@yahoogroups.com

"bj daniels" <dani...@gunnery.org> wrote in message
news:OlHVgYe1...@tk2msftngp13.phx.gbl...

[David McKenzie]

We took the view that versioning solves many of the problems currently
addressed by single file restores.
That said, one has to budget considerably more disk resources...

"bj daniels" <dani...@gunnery.org> wrote in message

news:u6EPzNf1...@TK2MSFTNGP09.phx.gbl...

[David McKenzie]

oddly enough, an email from MSD2D contained an advert for
http://www.avepoint.com/website/product.html
you would have to ask them if it supports WSS

"bj daniels" <dani...@gunnery.org> wrote in message

news:u6EPzNf1...@TK2MSFTNGP09.phx.gbl...

[James Edelen [MVP]]

Search the newsgroup, I responded to a similar post with 6 options (none
really that great) that can be used until a 3rd party comes out with a
solution.

--
James Edelen
Microsoft MVP - SharePoint Portal Server
Microsoft MVP - Windows XP Media Center
Microsoft Associate Expert
Expert Zone - http://www.microsoft.com/windowsxp/expertzone

"bj daniels" <dani...@gunnery.org> wrote in message
news:OlHVgYe1...@tk2msftngp13.phx.gbl...

[James Edelen [MVP]]

Just because I felt like it, I decided to repost my original answer:

You have a couple of options. 1) Restore the SQL Content Database(s) to
another location and restore the file directly from there (I am working on a
tool to do this, or you can write your own). This requires you to backup
the SQL databases 2) Restore the entire portal to a different server, then
copy the file from the temporary portal to the live portal. This requires
you to backup the portal/farm using SPSBackup.exe 3) Restore the site with
the file you need to a temporary site on your portal server copy the file
from the temporary site to the live site. This requires you to use smigrate
to backup EVERY site, which is resource intensive and you must write your
own script to do so. 4) Use UNC paths to backup the files to tape. This
requires you to setup your backup program to backup every Document Library
individually (as they each have their own UNC path, so it is very
time-consuming). 5) Use a tool such as SPExport (or write your own).
SPExport is a quick program I put together which will copy all files to the
local filesystem (must be run on an SPS server in the farm) essentially
acting like a backup. It isn't supported, but I initially wrote it to so
basically what you are looking for. I have also provided the source code
(in case you want to write you own). It can be found at
http://jj4.bloggedup.com/mt/archives/SPExport.zip (source code) or
http://jj4.bloggedup.com/mt/archives/000059.html (Binary download)

HTH

--
James Edelen
Microsoft MVP - SharePoint Portal Server
Microsoft MVP - Windows XP Media Center
Microsoft Associate Expert
Expert Zone - http://www.microsoft.com/windowsxp/expertzone
"bj daniels" <dani...@gunnery.org> wrote in message
news:OlHVgYe1...@tk2msftngp13.phx.gbl...

[Mike Walsh [MVP]]

> Search the newsgroup (earlier message)

Difficult to find your earlier message when reading this thread in the WSS
newsgroup (dual posted - unnecessarily), so thanks for posting it in this
thread where we non-SPS users could see it !

Bill (English)? will your "script for the resource kit " also work in
standalone WSS ? Earlier in this thread you only mention SPS. (Probably only
because *you* were reading this thread in the SPS newsgroup just as I was
reading it in the WSS newsgroup and referred to an earlier thread that was
only there)

Mike Walsh, Helsinki, Finland

"James Edelen [MVP]" <j...@mvps.org> wrote in message
news:eC%232Sjl1...@TK2MSFTNGP11.phx.gbl...

[Steven Collier [MVP]]

If there was an either-or choice, I would choose undelete instead of Item
level backup/restore .....

--
Steven Collier

SharePoint Portal Server MVP

Bill English [MVP] <beng...@networknowledge.com> wrote:
> We have a script for the resource kit that, if we can get it tested,
> will copy documents out of a doc lib to a file system for backup
> purposes. The lack of per item backup/restore as well as permissions
> is a negative that the product team has heard loud and clear. I'd be
> willing to bet large dollars that feature will be included in the
> next version of SPS.
>
> The lack of per item backup/restore should not be a deal killer.
> Just keep and offline server around to do the restores on and then
> grab the individual file and copy it back to the doc lib. This is
> really no different, in principle, than what we had in Exchange 5.5
> lacking individual mailbox restores. People worked around the issue
> and got is solved.
>
>

[Bill English [MVP]]

Yep - the only group I visit in the sharepoint.portalserver group. I don't
go to the windowsservices group, not out of spite or anything, just that I
don't have time to do two groups and my focus is really more on portal than
it is on WSS, though I must admit, I can't do portal without WSS.

As for the tool - I think it is doc lib specific, so it should work. James
is the author, so you can ping him.

Thanks, Mike (Walsh)?

<grin>

--
Bill English, MCSE, MCT, MVP, MCSA, GSEC
https://www.sharepointsummit.com
sharepointdiscu...@yahoogroups.com

"Mike Walsh [MVP]" <englant...@hotmail.com> wrote in message

news:%23ZzAoGn...@TK2MSFTNGP10.phx.gbl...

[Mike Walsh [MVP]]

I seem to have placed my question mark somewhat unluckily (and immediately
reaped the consequences :) ).

I'm like you in reverse. No time to read the portalserver newsgroup as well
as the WSS one (and I add to this an inibility to realise that a posting is
not just going to the WSS newsgroup).

Mike Walsh?, Helsinki, Finland

"Bill English [MVP]" <beng...@networknowledge.com> wrote in message
news:ez0nrFz1...@TK2MSFTNGP10.phx.gbl...

[Ric]

"James Edelen [MVP]" <j...@mvps.org> wrote in message
news:eC%232Sjl1...@TK2MSFTNGP11.phx.gbl...

> Just because I felt like it, I decided to repost my original answer:

> . ..3) Restore the site with

> the file you need to a temporary site on your portal server copy the file
> from the temporary site to the live site. This requires you to use
smigrate
> to backup EVERY site, which is resource intensive and you must write your
> own script to do so.

You have the same ability (restore to a temp site on your exisiting server)
with STSADM. Then you can copy and paste the errant files back to the
original site.

// Ric

[bj daniels]

Thank you all for you suggestions. I may look into the methods suggested.
Having a spare server is tough - I did have to restore an exch 5.5 mailbox
item once, and it was a nightmare. I don't want to repeat that again.

anyway, thanks!

bj

"James Edelen [MVP]" <j...@mvps.org> wrote in message
news:eC%232Sjl1...@TK2MSFTNGP11.phx.gbl...

[bj daniels]

I have not tried it myself yet - but the other posts replying to my initial
inquiry have given me some good techniques to try.

bj

"Roland" <anon...@discussions.microsoft.com> wrote in message
news:5DDA95FF-7D88-4EB4...@microsoft.com...
> Hi bj! Did you find out a way to do it? Thank you