The procedure to Move Closed rows back to the main tables is as follows.

1) ALWAYS create a backup of the source database
2) Get the latest version of MoveClosedToMatters.sql from Subversion
3) Run the file. You have now run the script in "Reporting" mode. As part of the script it will create a new database, e.g. Keyhouse_MoveClosed - there will be a number of tables in that database. The most important one is [dbo].[ExecutionLog], which will tell you whether all reporting steps ran successfully. Check also the content of the other tables, e.g. MatterRenumberingLog, OrphanedCaseMasterRecords and RestoredMatters. If there are Matters in the Closed table that have the same code as active matters in the Matter table, the MatterRenumberingLog table will tell you what their matter codes will be when they're restored to the matters table. OrphanedCaseMasterRecords will give you matter codes that are present in CaseMaster but that don't exist in the matters table. If any of these tables show you issues that need addressing, address them before proceeding to step 4.

4) Find the following statement in MoveClosedMatters.sql:
/* SET REPORTMODE to 0 to actually run the query
   SET ROLLBACK to 0 to have the transaction committed at the end*/
INSERT
  INTO [dbo].[MoveClosed]
      ([REPORTMODE],
       [STOP],
       [ROLLBACK])
VALUES(1,
       0,
       1)
GO

Change it to
/* SET REPORTMODE to 0 to actually run the query
   SET ROLLBACK to 0 to have the transaction committed at the end*/
INSERT
  INTO [dbo].[MoveClosed]
      ([REPORTMODE],
       [STOP],
       [ROLLBACK])
VALUES(0,
       0,
       1)
GO

5) Run the script again. This time it will perform all the actions that it will perform on the final run, but it will rollback all its actions at the end of the run. It is important on this occasion to confirm that the script runs without any errors. Also, check the _MoveClosed database again after this run and see if it has highlighted any other issues that need addressing.

6) If any further issues need to be addressed before the final run, address them now.

7) Go back to the statement mentioned in Step 4, and this time change it to:
Change it to
/* SET REPORTMODE to 0 to actually run the query
   SET ROLLBACK to 0 to have the transaction committed at the end*/
INSERT
  INTO [dbo].[MoveClosed]
      ([REPORTMODE],
       [STOP],
       [ROLLBACK])
VALUES(0,
       0,
       0)
GO

8) Run the script again.
9) Check the _MoveClosed tables again
10) Have a good look at the source database, make sure it's fully functional, check that nothing appears to be lost.
11) If any problems, restore the database from the backup made in point 1, address issues, and repeat this process.