Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts

Monday, February 14, 2022

Rename AxDB database in D365Fo

To rename the AxDB database in the tier-1 machine (Dev machine), stop following services.
  1. Management reporter 2012 process service
  2. Microsoft Dynamics 365 for Operations – Batch Management service
  3. Microsoft Dynamics 365 for Operations – Data import/Export Framework service
  4. World Wide Web Publishing Service

Monday, April 23, 2012

Re Indexing of Database by Scheduling


Open studio management >> Go to Maintenace Plans Right click and select “Maintenance Plan Wizard”





    Enter the name and description of reindexing process 


   Select Rebuild Index option



   Select the database name on which you have to run Indexing process








   Select newly created maintenance plan , right click it and select “Modify” option

   
    Select the scheduling option which is having calendar symbol you will get following window


   You can Disable/Enable the reindixing  Job from Jobs node in SQL Server Agent.