Recreate form library

If a problem occurs in the original form library, you need to re-create the form library to replace the original form library.

 

1. First copy all the forms and soft copies to the local hard disk.

 

2. Use powergrep to replace the header of the infopath form.

Name href. If these two attributes are used

 

3. Copy these replace files and upload them to the new form library.

 

4. Use statements to modify several fields, including folders, files, form creators, creation time, modifier, and modification time.

Update
Set
A. tp_author = B. tp_author,
A. tp_editor = B. tp_editor,
A. tp_modified = B. tp_modified,
A. tp_created = B. tp_created,
A. nvarchar1 = B. nvarchar1,
A. nvarchar2 = B. nvarchar2

From alluserdata A, temp B
Where
A. tp_dirname like n 'xxxx' ----> If the data volume is large, it can be updated step by step.

And a. tp_listid = 'e166fa95-48fc-45bf-9eec-5e75ec6aadf0'
And a. tp_dirname = B. tp_dirname ------> here, the temp tp_dirname is replaced in advance with the same name as the new form library.
And a. tp_leafname = B. tp_leafname
And a. tp_deletetransactionid = 0x

5. Add the secondary development originally performed in the old form library.

 

6. Delete the old form library from the secondary recycle bin.

The database size remains unchanged after deletion, and the database size needs to be reduced

Clear logs: backup log wss_content with no_log (Sybase statement: Dump transaction wss_content with no_log)

Shrink: DBCC shrinkdatabase (wss_database)

 

 

7. Create a full-text index again.