How to restore a deleted iManage Folder

Folders can’t be recovered but the files are still present so you can manually recreate the folder and search for the files in iManage and move them back into it. If your not sure all the files you can restore the database to find the old PRJ_ID of the folder then search for the files with that Parent

A script below helps with restoring Subfolders etc : 

The first for the folders, the second for documents. You will also need to run something similar for folder profiles and security, but that should be straight forward.

@prjid would the first folder you wish to restore, the query will pull all of the children.

Replace “PRODUCTION” and “RESTORE” with your own db names.

!!Of course use at your own risk, this works on my environment, and should work on yours too. !!

-- Folders / Workspace
DECLARE @prjID BIGINT;
select @prjid = --PARENT FOLDER ID


WITH tblChild AS
(
    SELECT * FROM  RESTORE.mhgroup.projects WHERE prj_pid = @prjID
    UNION ALL
    SELECT p.*  FROM RESTORE.mhgroup.projects p JOIN tblChild c  ON p.prj_pid = c.prj_id
)
insert into PRODUCTION.mhgroup.projects
SELECT * FROM tblChild where prj_id not in (select prj_id from PRODUCTION.mhgroup.projects)
OPTION(MAXRECURSION 32767)


-- Documents
DECLARE @prjID BIGINT;
select @prjid = --PARENT FOLDER ID

WITH tblChild AS
(
    SELECT * FROM  mhgroup.projects WHERE prj_pid = @prjID
    UNION ALL
    SELECT p.*  FROM mhgroup.projects p JOIN tblChild c  ON p.prj_pid = c.prj_id
)

insert into PRODUCTION.mhgroup.project_items
SELECT s.* FROM tblChild p
 inner join RESTORE.mhgroup.project_items s on s.prj_id = p.prj_id
where sid not in (select sid from PRODUCTION.mhgroup.project_items)
OPTION(MAXRECURSION 32767)
VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Trackback from your site.