For some 'time Data Protection Manager 2010 (DPM 2010) failed to back up two SharePoint databases (Project Server 2007 to be precise) citing as justification for the excessive length of the name of the database backupped (specifically SharePoint_AdminContent_GUID and SharedServicesContent_ \u0026lt;GUID>) and suggested to rename the database with a name more 'short.
The first thing I did, and 'check the maximum length the name of a member belonging to a protection group, and the Microsoft documentation I have found that, in reality 'the length of the database from backupped did not exceed the maximum allowed, but the errors still show incorrect synchronization. I then decided to rename the database so 'as suggested by DPM ... and here are the problems begin.
In short, the first to summarize the steps that led to the solution of all problems, faro 'a small preamble. In practice, the installation of Project Server 2007 is not 'was carried out following the directions provided by the Best Practice for the administrator of the farm was the service user Network Service and have created many problems in the process of renaming the DB.
The following steps summarize the steps to follow to do the rename of the database content SharePoint_AdminContent_ \u0026lt;GUID> even in cases where the installation of MOSS 2007 / WSS 3.0 / Project Server 2007 has been carried out with the necessary criteria.
- If the installation is not 'been made by you or not' been documented, make sure that the administrator of the Farm is a domain account.
a. If the Application pool account SharePoint Central Administration v3 and 'a system account (Network Service, Local System or Local Service) then most likely and the farm administrator 'account that the "run" the application pool. In this case, then we'll see all the commands will fail with the message of Access Denied .
b. To prevent this' must run the following command:
stsadm-o-updatefarmcredentials identitytype configurableid-userlogin \u0026lt;DomainName> \\ \u0026lt;UserName>-password \u0026lt;Password>
c. After making the change administrator must restart Internet Information Services effettevio to make the change of identity 'for the application pool in point 1.a. - Start the console SharePoint Administration
- Back up the database you want to rename
- Restore the database with the new name
- Start the command prompt with administrator credentials Farm
- Run the command
stsadm-o-deletecontentdb url \u0026lt;CentralAdministrationUrl> \u0026lt;: \u0026lt;port>> -databasename SharePoint_AdminContent_ \u0026lt;GUID> - databaseserver \u0026lt;DatabaseInstance> - Also from commandline, run
stsadm-o addcontentdb \u0026lt;CentralAdministrationUrl>-url \u0026lt;: \u0026lt;port>>-databasename \u0026lt;SharePoint_AdminContent_NewName> - databaseserver \u0026lt;DatabaseInstance> - Start the Central Administration Console
- Remove the old database
- Delete the database from SQL Server
0 comments:
Post a Comment