Venio Backup and Restore Procedure 

Step (1)

Back up Venio Project instructions

Option 1

Step (1)

1. Within Venio UI Go To Administration
2. Select > Backup/Restore Project
3. Select > Next > Select Backup Project, Select >Next
4. Select Project to Backup > Backup location 
   - Select Backup all Project Data or Backup Project database Only
   -  Turn off Compress and Archive
5. Select > Next
6. When promoted "Does the project SQL DB (Project Name) reside in this server > Select NO
   - When prompted you will need to locate the DB and place in the restore database location folder (please read the red statement) 
   - Once you place the DB Backup file in the source backup location Copy and past the UNC path into (Please enter BAK File)
7. Once you have C&P the UNC Path select Next.
8. Venio Backup utility will back up the project and files depending of your select in action (4)

Step (2)

1. Once the project has been backed up you can go back to the Process Tab 
2. Now you can do two things 
   1. Under Projects select > Delete which Delete the project from Venio
   2. Go into SQL and run the following query
   

   ----Change Backup Status---

   update tbl_pj_ProjectSetup

   set backupstatus = 1

3. Option (two will put the project in a hibernation mode allowing for it to still show up but it will not be accessible.

Option 2

Step (1)

• Create a SQL full backup of the client project and Venio PCD and store the backup onto a NAS location or external hard drive for archive projects.

Step (2)

Backing up project data files

• On the Console server open CMD as administrator.
  - Run the following command Example: robocopy c:\venio d:\venio /E /r:1 /w:3 /mir /MT:16
• After the project data is copied to it’s archive location you can now delete the project from Venio.

Restore Venio Project from Archive

• Locate the SQL backup from the archive location and move it to the SQL server
• Open SSMS > Right click on Database > Select Restore Project > Select under source <Device> Browse out to the location where the SQL.BK files reside.
• Select Files > check Relocate all files to folder.
• Select Options > Select > Overwrite the existing database (WITH REPLACE)
• Select ok and allow for the project to restore

Step (2)

Restoring project files

• Open CMD as administrator
• Execute robocopy:  robocopy <Archive Location> <Destination location> /E /r:1 /w:3 /mir /MT:16
• Once all files have been restored to the project location move to step (3)

Step (3)

Active Venio project via SQL

• Run the following SQL Commands

----Step 1-----

----Locate the projectID---

select * from tbl_pj_ProjectSetup

order by databaseinstancename

----Step2-----

----Change Backup Status---

update tbl_pj_ProjectSetup

set backupstatus = 0

where ProjectID = <Insert projectID> ----Insert New restored ProjectID Remove the <>-----

-----Step3-----

-----Update PCD-----

use litiedge

exec [sp_syn_change] <Insert projectID> ----Insert New restored ProjectID remove <>-----

----Step4-----

----Update synname-----

use [prj_CMCK_WKS_Singapore_FID65590] ----Insert New restored SQL DB NAME-----

--EXECUTE SCRIPT IN PROJECT DATABASE

DECLARE @v_veniopcd NVARCHAR(2000) ='' --PROVIDE PCD NAME insert the PCD between the ''--

DECLARE @v_synonymname NVARCHAR(2000)

DECLARE @v_query NVARCHAR(MAX)

DECLARE @v_synonymtemplate NVARCHAR(MAX)

SET @v_synonymtemplate =

'

IF  EXISTS (SELECT * FROM sys.synonyms WHERE name = N''{synname}'')

BEGIN

DROP SYNONYM [dbo].[{synname}]

END

CREATE SYNONYM [dbo].[{synname}] FOR {pcd_name}.[dbo].[{synname}]

'

------------------------------------------------

--CREATE SYNONYM [tbl_pj_GenericFileTypes]

------------------------------------------------

SET @v_synonymname = 'tbl_pj_GenericFileTypes'

SET @v_query=@v_synonymtemplate

SET @v_query = REPLACE(@v_query,'{synname}', @v_synonymname)

SET @v_query = REPLACE(@v_query,'{pcd_name}', @v_veniopcd)

EXEC sp_executesql @v_query

print @v_query

------------------------------------------------

--CREATE SYNONYM [tbl_pj_ExtractorInfo]

------------------------------------------------

SET @v_synonymname = 'tbl_pj_ExtractorInfo'

SET @v_query=@v_synonymtemplate

SET @v_query = REPLACE(@v_query,'{synname}', @v_synonymname)

SET @v_query = REPLACE(@v_query,'{pcd_name}', @v_veniopcd)

EXEC sp_executesql @v_query

------------------------------------------------

--CREATE SYNONYM [tbl_pj_ExtractorFileTypes]

------------------------------------------------

SET @v_synonymname = 'tbl_pj_ExtractorFileTypes'

SET @v_query=@v_synonymtemplate

SET @v_query = REPLACE(@v_query,'{synname}', @v_synonymname)

SET @v_query = REPLACE(@v_query,'{pcd_name}', @v_veniopcd)

EXEC sp_executesql @v_query

------------------------------------------------

--CREATE SYNONYM [tbl_pj_ProjectFileTypePriority]

------------------------------------------------

SET @v_synonymname = 'tbl_pj_ProjectFileTypePriority'

SET @v_query=@v_synonymtemplate

SET @v_query = REPLACE(@v_query,'{synname}', @v_synonymname)

SET @v_query = REPLACE(@v_query,'{pcd_name}', @v_veniopcd)

EXEC sp_executesql @v_query

• After the following SQL commands are completed move to step (4)

Step (4)

Updating Project file location using Venio UI

• Open Venio Console > select Administrator 
• Select Backup/Restore Project tab
• Select Move Project Location
• Select Project from the drop down menu
• Select the File location (where you restored the project data Top level of the Repository). The Index location will automatically populate.

Under Data Copy Option

• Select Update database only >next
• Select Move Selected Media(s) > Next
• Venio will now update the file access path along with all other relative paths in the project DB.

After the final task is completed the project is now active and ready to be used.