PURPOSE

This article describes how to move a Storage Profile in a repository from one location to another. 

Note: All the users needs to be off the system as the repository will be de-activated during the below procedure.

STEPS

1.  Log onto the server hosting the Synergize EMC and launch the EMC as administrator. Using EMC navigate to the Storage Profile node. Take note of the repository's No and the name of the repository that is sought to be relocated.

2. Copy the Storage Profile folder listed under Path to the new location.   

3. Temporarily deactivate the repository using the Synergize EMC.

 

4. Go to Microsoft SQL Server Management Studio and navigate to the database with the same name as the Synergize repository.  Query the dbo.StoreDev table using the statement similar to below.

SELECT TOP 20 [In_MappedDrNo]
,[In_MappedDrName]
,[In_ActiveDr]
,[In_CurDirStruct]
,[In_CurFileCount]
,[In_DrivePurpose]
,[In_NextDrName]
,[In_MaxFilesPDir]
,[In_MaxDirPDir]
,[In_DevType]
,[In_AutomaticDr]
,[In_DrAlias]
FROM [REPOSITORY_NAME].[dbo].[StoreDev]

 5. Execute an update statement similar to below to modify the table to reflect the new location.

Update [databasename].[dbo].[StoreDev] SET In_MappedDrName = 'PathTo_NEW_Directory' WHERE In_MappedDrNo = X 

 

6. Query the dbo.StoreDev table using a statement similar to below to ensure the table reflects the changes.

SELECT TOP 20 [In_MappedDrNo]
,[In_MappedDrName]
,[In_ActiveDr]
,[In_CurDirStruct]
,[In_CurFileCount]
,[In_DrivePurpose]
,[In_NextDrName]
,[In_MaxFilesPDir]
,[In_MaxDirPDir]
,[In_DevType]
,[In_AutomaticDr]
,[In_DrAlias]
FROM [REPOSITORY_NAME].[dbo].[StoreDev]

7. Reactivate the database from the Synergize EMC.

If you have further inquires please contact support@microdea.com