Connected workgroup - steps for moving SQL databases on Publisher

Anonymous — Wed, 22 Aug 2018 12:16:49 GMT

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.

Re: Connected workgroup - steps for moving SQL databases on Publisher

cbenner — Wed, 22 Aug 2018 15:33:59 GMT

@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.

Re: Connected workgroup - steps for moving SQL databases on Publisher

Jason.Courtemanche — Wed, 22 Aug 2018 17:43:28 GMT

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:

Opening ADMS Console
Select Tools > Administration
Select Advanced Setting tab
Select Settings
Look at Impersonation Username:

To find the SQL Service User account:

Open Window Services
Right Click SQL Server (AutodeskVault)
Select Log On (tab)
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)

Right-click folder
Select Properties
Select Security (tab)
Select Edit
Select Add
Select Impersonation user & SQL Username
Select OK
Select Impersonation user
Select Full Control
Select SQL User Name
Select Full Control
Select OK
Select OK

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

Open ADMS Console
Expand Vaults
Select Vault
Right Click Vault
Select Move Databases...
Change file Paths Select ...
1. Data File Location will move the .mdf file
2. Log File Location will move the .ldf file
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

topic Connected workgroup - steps for moving SQL databases on Publisher in Vault Forum

Connected workgroup - steps for moving SQL databases on Publisher

Re: Connected workgroup - steps for moving SQL databases on Publisher

Re: Connected workgroup - steps for moving SQL databases on Publisher