Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SP Manager

  Asked By: Herman    Date: Nov 20    Category: Sharepoint    Views: 1288

I ran into a program called SP Manager for Sharepoint. Has anyone
this program?

Can I backup and restore single files using SharePoint, or should I
envest into SP Manager.

It looks like restoring a single file in sps/wss will be a pain.



5 Answers Found

Answer #1    Answered By: Deonte Stein     Answered On: Nov 20

i like the idea of intercepting that delete command :)


its better than mirroring 30gb worth of sql data as ms wants us to do.

what do you think of that? everything you delete will go into the "DeletedDocs"
table, just fashion up some sort of datagrid (im still working that part out) or
use textcopy to get docs back. its kinda poor man's way but hey, its job
security :)

anyone else had any good experiences with recycle bin functionality OTHER than
the article ms wrote?

Answer #2    Answered By: Stephon Valentine     Answered On: Nov 20

I looked at the MS RecycleBin solution and don't like it - our SITE
DBs are up to 40Gb and growing ... I wouldn't even consider
duplicating all of my Doc Libs for their solution.

I figured the least worst solution was to add a trigger to the DOCS
table to duplicate the row before the delete... your message sounds
promising but linkie no workie. Do you have an updated link to your

Answer #3    Answered By: Leif Cardenas     Answered On: Nov 20

Watch for an announcement for my Deleted Items Document Library Custom
List Template later this month. You won't want to miss it.

Answer #4    Answered By: Jasper Hatfield     Answered On: Nov 20

try out this link from MSDN.


Answer #5    Answered By: Rashawn Hopper     Answered On: Nov 20

i did not write this, i give credit to bryant likes (blogs.sqlxml.org/.../2776.aspx):

I recently read the MSDN article Add a Recycle Bin to Windows SharePoint Services for Easy Document Recovery by Maxim V. Karpov and Eric Schoonover. It was an interesting read, but I was pretty amazed at the lengths they had to go to in order to get something as simple as a recycle bin. Obviously, this biggest setback was the fact that

events are processed asynchronously. As a result, a registered event sink will only be notified about the document deletion after that document has already been deleted from the SQL Serverâ„¢ backend database. As a result, the event sink can't simply copy the document to the recycle bin library because the deleted document no longer exists.

Sounds like a YASPQ (or YASQ if you prefer) to me. So in order to create the recycle bin they Maxim and Eric end up mirroring the document libraries in order to add the recycle bin functionality. While reading the article my mind couldn't help of trying to come up with a simplier method. Here is my own version of a SharePoint recycle bin (note: don't play around with your SharePoint databases if you don't know what you're getting yourself into. I always build and test my scripts out on test servers and sites and this is what I would call a pre-alpha release).

Connect to the _SITE database using Query Analyzer and run the following SQL Scripts.

1) Create the RecycledDocs table which is basically a copy of the Docs table:

-- create the RecycledDocs table
select *
into RecycledDocs
from Docs
where 1 = 0

2) Create an instead of trigger on the docs table that will redirects requests to delete documents.

create trigger doc_recycle on docs instead of delete
delete RecycledDocs
where id in (select id from deleted)
insert into RecycledDocs
select id, siteid, dirname, leafname, webid, listid, doclibrowid,
type, size, metainfosize, version, uiversion, dirty, cacheparseid,
docflags, thicketflag, charset, timecreated, timelastmodified, nexttolasttimemodified, metainfotimelastmodified, timelastwritten,
setuppath, checkoutuserid, checkoutdate, checkoutexpires, checkoutsize,
versioncreatedsincestcheckout, ltcheckoutuserid, virusvendorid,
virusstatus, virusinfo, metainfo, content, checkoutcontent
from Docs where type = 0 and Id in (select Id from deleted)
delete docs
where id in (select id from deleted)

That is basically it. Of course, there is a lot of functionality that needs to be added from a user perspective, but as an admin you can now restore  any document that gets deleted.

I'm not sure how this would affect Microsoft's support of a SharePoint installation, it may or may not. Your RecycledDocs table will also fill up (much like the Windows Recycle Bin) until you manually empty it. I'm hoping to do a longer write up on this along with either a web part or an ASPX page that can manage it.

So there is my simple method of creating a Recycle Bin in SharePoint. It isn't very fancy, but it works.

Didn't find what you were looking for? Find more on SP Manager Or get search suggestion and latest updates.