Connected workgroup - steps for moving SQL databases on Publisher

[Anonymous]

We use Multi-Site Replication and because drive where SQL databases are located is almost full we have to move our databases from one drive to another drive on the Publisher server.

We plan to use ADMS Console. Could you, please help us to determine what exactly steps we have to take, is there needed to stop any SQL jobs on Publisher/Subscribers or stop replication?

Any help would be very appreciated.

[cbenner]

@Anonymous

>>This document<< may partially answer your question.  I'm not sure about the replication or stopping other SQL jobs.  I'm going to call in @Jason.Courtemanche who probably has more expertise on this sort of thing.

[Jason.Courtemanche · Accepted solution]

Hi @cbenner, thanks for bringing this to my attention! 

Hi @Anonymous, 

Welcome to the Autodesk Community, and thank you for posting your question here in the Vault forum!

Before making any change to the Vault Server make sure the replication is running correctly and that all files are replicated to the publisher. Then take a full Vault backup from the ADMS Console by selecting Tools > Backup and Restore. 

Yes, you can move the databases by selecting the Vault in the ADMS Console and select Move Databases... During the moving process, you will not have access to the Vault until it is finished. I tested this in a replication environment and moving the Vault database had no effect on replication or the merge agents. 

When you select the new folder on the new hard drive you need to make sure that you have given full permissions to two users the Impersonation account and the User account SQL is running as. If this is not setup correctly you will see SQL errors. 

The default Impersonation account is HostName\AutodeskVault, you can confirm your Vault is using the same user by following these steps:

1. Opening ADMS Console
2. Select Tools > Administration
3. Select Advanced Setting tab
4. Select Settings
5. Look at Impersonation Username:

To find the SQL Service User account:

1. Open Window Services
2. Right Click SQL Server (AutodeskVault)
3. Select Log On (tab)
4. Look at: This Account Network Service

Once you confirmed what the two usernames, need to make sure these two users have full control over the folder you are moving the database to (.mdf & .ldf files)

1. Right-click folder
2. Select Properties
3. Select Security (tab)
4. Select Edit
5. Select Add
6. Select Impersonation user & SQL Username
7. Select OK
8. Select Impersonation user
9. Select Full Control
10. Select SQL User Name
11. Select Full Control
12. Select OK
13. Select OK

Once the folder is set up then you can start the move from the ADMS Console

1. Open ADMS Console
2. Expand Vaults
3. Select Vault
4. Right Click Vault
5. Select Move Databases...
6. Change file Paths Select ...
   1. Data File Location will move the .mdf file
   2. Log File Location will move the .ldf file
7. Select Ok

**Once this starts you will not have access to this Vault until the process finishes

I hope this helps you get your Vault database moved to the new hard drive. Please let me know if that did not work if it does please mark this as the solution so its easier for others to find it. 

Also, I would recommend looking into making sure you have an SQL Maintenance plan set up for your Vault. 

Regards,

Jason