How to move a database path in the case of a DAG

Source: Internet
Author: User

There are many scenarios for moving database paths, typically because disk space is not enough and you want to move to another disk, it is not difficult to move the database path with a wizard, but if you enable the DAG case, there are some caveats, the following instructions.


PS: If you need to move the database path, you must first uninstall the database that needs to be moved, so it is best to migrate during non-working hours.


  1. The following is aITThis database demonstrates thatMBX1and theMBX2enabled on theDAG,MBX1on theITthe database is active,MBX2on theITThe database is in a replicated state:

    650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/7F/74/wKioL1cfU5yx2FweAACctX08iw4021.png "title=" 01.png "alt=" Wkiol1cfu5yx2fweaacctx08iw4021.png "/>

  2. Dismount Database

    650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/7F/74/wKioL1cfU-LC47l2AACoTEMrwZk955.png "title=" 02.png "alt=" Wkiol1cfu-lc47l2aacotemrwzk955.png "/>

  3. Delete the copy of the IT database because it database only MBX2 on the server 1 a copy, delete directly, if there are multiple copies, one should be deleted;

    PS: Delete operation does not really erase MBX2 database files on the server, and these files are also useful next.

    650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/7F/75/wKioL1cfVNmy3ybQAAC89CO-6yw193.png "title=" 03.png "Style=" Float:none; "alt=" Wkiol1cfvnmy3ybqaac89co-6yw193.png "/>

    650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/7F/77/wKiom1cfVBDBZx7uAACb_UVSUeM880.png "title=" 04.png "Style=" Float:none; "alt=" Wkiom1cfvbdbzx7uaacb_uvsuem880.png "/>

  4. Delete Succeeded

    650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/7F/75/wKioL1cfVprDSzLQAAC0eNVHpyI533.png "title=" 05.png "alt=" Wkiol1cfvprdszlqaac0envhpyi533.png "/>

  5. See if the database file is still

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/7F/75/wKioL1cfV0_A6A6FAACoicFL4gk604.png "title=" 06.png "alt=" Wkiol1cfv0_a6a6faacoicfl4gk604.png "/>

6. Before you begin the migration, you need to create a directory name with the same name under the same disk path on all MBX servers, such as db-it, before you perform the migration operation :

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/7F/77/wKiom1cfV0LCbQBrAACHa10d1EI033.png "title=" 07.png "alt=" Wkiom1cfv0lcbqbraacha10d1ei033.png "/>

7. After all copies have been deleted, go back to MBX1 and move the database path:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/7F/75/wKioL1cfWL3Ch6uEAADOp5XT_pE913.png "title=" 08.png "alt=" Wkiol1cfwl3ch6ueaadop5xt_pe913.png "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/7F/75/wKioL1cfWKfz66lsAAEf3xLlxno000.png "style=" float: none; "title=" 09.png "alt=" Wkiol1cfwkfz66lsaaef3xllxno000.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/7F/77/wKiom1cfV-DD8LldAAEiPP6r6dg653.png "style=" float: none; "title=" 10.png "alt=" Wkiom1cfv-dd8lldaaeipp6r6dg653.png "/>


PS: Here we can also use the command line to migrate, command: move-databasepath-identity'IT' -edbfilepath 'C:\DB-IT\IT.edb'-logfolderpath 'C:\DB_IT'


8. After the migration is complete, check to see if the path has been updated

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/7F/77/wKiom1cfWhjh9yDPAACpoDzYNj0668.png "style=" float: none; "title=" 11.png "alt=" Wkiom1cfwhjh9ydpaacpodzynj0668.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/7F/77/wKiom1cfWhmANzrtAACvFk6zJhE127.png "style=" float: none; "title=" 12.png "alt=" Wkiom1cfwhmanzrtaacvfk6zjhe127.png "/>

9. The next step is to manually copy / or move the previous database files to the newly created directory db-it on all replica servers , so that data synchronization can be completed faster:

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/7F/75/wKioL1cfW-mxcvlKAADXxXWKZpc410.png "style=" float: none; "title=" 13.png "alt=" Wkiol1cfw-mxcvlkaadxxxwkzpc410.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/7F/77/wKiom1cfWyCAALZ7AACBT7yEiDI576.png "style=" float: none; "title=" 14.png "alt=" Wkiom1cfwycaalz7aacbt7yeidi576.png "/>

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/7F/75/wKioL1cfW-uxnyTlAACYRO_PL6g164.png "style=" float: none; "title=" 15.png "alt=" Wkiol1cfw-uxnytlaacyro_pl6g164.png "/>

10. Add a Copy

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/7F/75/wKioL1cfXK-yyPg5AADBmg6m1eI863.png "style=" float: none; "title=" 16.png "alt=" Wkiol1cfxk-yypg5aadbmg6m1ei863.png "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/7F/77/wKiom1cfW-iz6VuaAAEX13arufI896.png "style=" float: none; "title=" 17.png "alt=" Wkiom1cfw-iz6vuaaaex13arufi896.png "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/7F/78/wKiom1cfXCHwLF08AAE5vqcnqS8851.png "title=" 18.png "alt=" Wkiom1cfxchwlf08aae5vqcnqs8851.png "/>

11. Copy Add complete

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/7F/78/wKiom1cfXJfRTlwhAACleohEjY4366.png "title=" 19.png "alt=" Wkiom1cfxjfrtlwhaacleohejy4366.png "/>

Restart the Microsoft Exchange Search Indexer service on all replica servers , or you will get an error activating the copy as follows:

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/7F/78/wKiom1cfXPXykOFgAACn0X9Ds4A470.png "style=" float: none; "title=" 20.png "alt=" Wkiom1cfxpxykofgaacn0x9ds4a470.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/7F/75/wKioL1cfXcHBJWMPAAEGdMhn-lw911.png "style=" float: none; "title=" 21.png "alt=" Wkiol1cfxchbjwmpaaegdmhn-lw911.png "/>

13. Mount the database, check the status

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/7F/75/wKioL1cfXjuSVxtKAACk6GAV9w0958.png "title=" 22.png "alt=" Wkiol1cfxjusvxtkaack6gav9w0958.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/7F/78/wKiom1cfXZrC2TEDAACeJEOgoPE895.png "title=" 23.png "alt=" Wkiom1cfxzrc2tedaacejeogope895.png "/>

14. The migration is complete.



This article is from the "Juck Zhang" blog, please be sure to keep this source http://daodefangxiang.blog.51cto.com/8658374/1768023

How to move a database path in the case of a DAG

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.