AXForum  
Вернуться   AXForum > Microsoft Dynamics AX > DAX Blogs
All
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 29.08.2012, 14:11   #1  
Blog bot is offline
Blog bot
Участник
 
25,475 / 846 (79) +++++++
Регистрация: 28.10.2006
axStart: Get in conrtol with Sharepoint DB names
Источник: http://www.axstart.com/get-in-conrto...point-db-names
==============

1        Introduction

When installing SharePoint 2010 a lot of additional DB’s are created. This can be nasty from maintenance point of view, especially when a Central SQL server is used. Take a look at the next picture. This shows the worst case of DB naming.  If these DB are stored on a central DB, you have known idea, if those DB are obsolete in one year, because you don’t know who used them.



We know how to change the DB name for:
  • Microsoft Dynamics AX
  • SharePoint_Config (define a correct name when installing SharePoint)
  • WSS_Content (define a correct name when creating the Web Application)
Most of all other DB from SharePoint can be renamed with the SharePoint Administration tool or PowerShell. (Take a look at http://technet.microsoft.com/en-us/l.../ff851878.aspx)

2        Change the names

2.1      SharePoint Admin

PowerShell



2.2      SharePoint Search
  • Backup the Search_Service_Application_DB_GUID_ DB _ SQL
  • Create new DB AxStart_ Search_Service_Application_DB
  • Restore Search_Service_Application_DB_GUID_ DB _ SQL in the new created DB
  • PowerShell


2.3      SharePoint  State Service

PowerShell



2.4      Business Data Connectivity Service

In SharePoint Administrator Tool, Go to Manage Service applications. Select Business Data Connectivity Service and Properties, and change the DB Name
  • Remove the old Bdc_Service_DB manually on SQL!

2.5      Search Service Application

In SharePoint Administrator Tool, Go to Manage Service applications. Select Search Service Application and Manage, on the next screen press modify button
  • You can change Crawl & Property DB Name
  • Don’t forget to press the apply topology button

2.6      Secure Store

In SharePoint Administrator Tool, Go to Manage Service applications. Select Secure Store and Properties, and change the DB Name
  • Remove the old Secure_Store_DB manually on SQL!

2.7      Select Web Analytics Server Application

In SharePoint Administrator Tool, Go to Manage Service applications. Select Web Analytics Server Application and Properties, on the pop screen select next button.
  • Change the names and select next
  • Delete the OLD DB manually on SQL!

2.8      Web analytics and Health

In SharePoint Administrator Tool, Go to Manage Service applications. Select Web analytics and Health (WSS_Logging DB)
  • Disable Enable Health Data Collection
  • Disable Enable usage Data Collection
  • Select  OK
  • Reopen the form and rename the DB
  • Also enable the options again
  • Delete the Old WSS_Longing DB manual in SQL
3        Mission accomplished








Источник: http://www.axstart.com/get-in-conrto...point-db-names
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
 

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
emeadaxsupport: You get a Script Error when viewing Role Centers (deployed on SharePoint 2010) in a Microsoft Dynamics AX 2009 Client Blog bot DAX Blogs 0 04.01.2011 20:11
Почему Microsoft SharePoint не BPM? pm-erp Microsoft и системы Microsoft Dynamics 0 29.04.2010 10:12
axStart: Get your forms back in one workspace Blog bot DAX Blogs 0 10.12.2008 14:05
axStart: AXC configuratied SharePoint AX configuration. Blog bot DAX Blogs 0 17.01.2008 03:30
axStart: Checklist when AX is not working with SharePoint Blog bot DAX Blogs 0 10.01.2008 23:17
Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Рейтинг@Mail.ru
Часовой пояс GMT +3, время: 09:28.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.