Перемещение базы данных tempdb

Поскольку база данных tempdb создается повторно при каждом запуске экземпляра SQL Server, необходимости в физическом перемещении ее файлов данных и журнала нет. Файлы создаются в новом месте во время перезагрузки службы.

USE master;

ALTERDATABASE tempdb MODIFYFILE (NAME = tempdev,FILENAME='J:\MSSQLINSTANCES\MSSQL11.MSSQLSERVER\TempDBData\tempdb.mdf');

ALTERDATABASE tempdb MODIFYFILE (NAME = templog,FILENAME='J:\MSSQLINSTANCES\MSSQL11.MSSQLSERVER\TempDBLog\templog.ldf');

Permanent link to this article: http://www.blogss.ru/moving_the_tempdb_database

SQL Server - добавить права администратора (single-user mode)

Краткая инструкция.

1) Запустить CMD (run as administrator)

2) net stop MSSQLSERVER (Остановить службу SQL Server )

3) net start MSSQLSERVER /m (Стартовать службу SQL Server в однопользовательском режиме)

4) sqlcmd -E (Запускаем sqlcmd из командной строки для управления SQL Server)

5) CREATE LOGIN [Domain\User] FROM WINDOWS;  (Добавить пользователя в SQL Server) -> go

6) EXEC sp_addsrvrolemember 'LoginName', 'sysadmin'; (Добавить пользователю права администратора SQL Server) -> go

7) net stop MSSQLSERVER (Остановить службу SQL Server)

8) net start MSSQLSERVER (Запустить службу SQL Server в обычном режиме)

Permanent link to this article: http://www.blogss.ru/sql-server-add-an-administrator-account-single-user-mode

Ошибки при установке PrerequisiteInstallerFiles - WindowsServerAppFabricSetup_x64

Были различные ошибки при установке PrerequisiteInstallerFiles (Offline) для Sharepoint 2013 а именно - WindowsServerAppFabricSetup_x64.

  • The following configuration issues were detected. Please resolve them before continuing.
  • AppFabric installation failed because installer MSI returned with error code : 1603
  • Error: Startup task doesn’t exist. This is not a continuation after a restart.

Решение:

Были установлены кавычки в конце пути системной переменной - PSModulePath

C:\Windows\system32\WindowsPowerShell\v1.0\Modules\;D:\Program Files\Microsoft Office Web Apps\AdminModule\;D:\Program Files (x86)\Microsoft SQL Server\110\Tools\PowerShell\Modules;C:\Program Files\AppFabric 1.1 for Windows Server\PowershellModules"

Удалить кавычки.

Control Panel -> System -> Advanced System Settings -> On the Advanced Tab Select Enviroment Variables ->

Найдите переменную PSModulePath, проверьте путь.

Пробуем установить.

PrerequisiteInstaller.exe /AppFabric:<location Of the Appfabric installation file> /KB2671763:"<path>\AppFabric1.1-RTM-KB2671763-x64-ENU.exe"

.\WindowsServerAppFabricSetup_x64.exe /i CacheClient”,”CachingService”,”CacheAdmin /gac

Permanent link to this article: http://www.blogss.ru/issues_prerequisiteinstallerfiles_windowsserverappfabricsetup_x64

Copy and Paste is not working on my Remote Desktop Connection

Copy and Paste is not working on my Remote Desktop Connection.

Luckily fixing the issue is pretty straightforward and involves a few simple steps.

  1. Load up task manager (right click taskbar and select Task Manager)
  2. Go to the Processes Tab
  3. Select rdpclip.exe
  4. Click End Process
  5. Go to the Application Tab
  6. Click New Process
  7. Type rdpclip
  8. Click Ok

There, copy and paste should now work normally again.

Original: http://www.gfi.com/blog/copy-paste-working-remote-desktop-connection-whats-wrong/

Permanent link to this article: http://www.blogss.ru/copy-and-paste-is-not-working-on-my-remote-desktop-connection

Путь к задаче в Project Server 2013 через Project Prof (VBA) - Path summary task Project Server

Поскольку в Project Server 2013 нет возможности как раньше в 2007 узнать путь к задаче.

10.12

Можно использовать макрос в Project Prof. Этот макрос возвращает путь к задаче и сохраняет его в text10. Это полезно, если у вас есть много задач, которые имеют то же имя, но имеют разные суммарные задачи.

Sub Имя_суммарной_задачи()
Dim ls As String
Dim mystring As String
Dim mytask As Task
Dim myoutlinelevel As Integer
myoutlinelevel = 1
While myoutlinelevel < 10
For Each mytask In ActiveProject.Tasks
If Not (mytask Is Nothing) Then
If mytask.OutlineLevel = myoutlinelevel Then

ls = Left(mytask.OutlineParent.Text10 & "\" & mytask.Name, 250)
mytask.Text10 = ls

End If
End If
Next mytask
myoutlinelevel = myoutlinelevel + 1
Wend

MsgBox "Обновление завершено. Опубликуйте календарный план."
End Sub

Пример использования: Имена задач одинаковые -> суммарных разные.

10.12_2

 

Permanent link to this article: http://www.blogss.ru/the-path-to-the-task-summary-in-project-server-2013

Project 2013: Upgrade-SPProjectWebInstance – ActivatePWAWebThemesFeature failed

Trying to upgrade a Project instance from 2010 to 2013:

Upgrade-SPProjectWebInstance https://url/pwa

I got the following error:

Upgrade-SPProjectWebInstance : Post provision setup failed.
ActivatePWAWebThemesFeature failed.
At line:1 char:1
+ Upgrade-SPProjectWebInstance https://url/pwa
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 + CategoryInfo : InvalidData: (Microsoft.Offic...radePwaInstance:
 PSCmdletUpgradePwaInstance) [Upgrade-SPProjectWebInstance], ProvisionException
 + FullyQualifiedErrorId : Microsoft.Office.Project.Server.Cmdlet.PSCmdletUpgradePwaInstance

 

Solution:

You need to firstly upgrade the SharePoint site to 20103 to get the feature available::

Upgrade-SPSite -Identity https://url/pwa -versionupgrade

Then start again the pwa upgrade:

Upgrade-SPProjectWebInstance https://url/pwa

Permanent link to this article: http://www.blogss.ru/project-2013-upgrade-spprojectwebinstance-activatepwawebthemesfeature-failed

Выгрузка пользователей Project 2007/2013(членство в группах). SQL retrieve group memberships from sql database

Выгрузка пользователей Project Server (членство в группах). Retrieve group memberships from sql database

2013

use [Project Server Database]

SELECT WSG.WSEC_GRP_NAME AS [Group], R.RES_NAME AS Member

FROM pub.MSP_WEB_SECURITY_GROUPS AS WSG

INNER JOIN pub.MSP_WEB_SECURITY_GROUP_MEMBERS AS WSGM ON WSG.WSEC_GRP_GUID = WSGM.WSEC_GRP_GUID

inner join pub.MSP_WEB_SECURITY_CLAIMS AS WSC on WSC.SECURITY_GUID = wsgm.wres_guid

INNER JOIN pub.MSP_RESOURCES AS R ON WSC.ENCODED_CLAIM = R.WRES_ACCOUNT

ORDER BY [Group], Member

2007

use [Project Server Database]

SELECT WSG.WSEC_GRP_NAME AS [Group], R.RES_NAME AS Member

FROM MSP_WEB_SECURITY_GROUPS AS WSG

INNER JOIN MSP_WEB_SECURITY_GROUP_MEMBERS AS WSGM ON WSG.WSEC_GRP_GUID = WSGM.WSEC_GRP_GUID

INNER JOIN MSP_RESOURCES AS R ON WSGM.WRES_GUID = R.RES_SECURITY_GUID

ORDERBY [Group], Member

Permanent link to this article: http://www.blogss.ru/retrieve_group_memberships_from_sql_database

SharePoint 2010/2013 – Clearing the Configuration Cache

Руководство по очистке содержимого кэша - SharePoint 2010/2013

The new path for the Configuration Cache under Windows Server 2008 is: %SystemDrive%\ProgramData\Microsoft\SharePoint\Config\<GUID> The overall steps remain largely the same:

  1. Stop the Timer service. To do this, follow these steps:
    1. Click Start, point to Administrative Tools, and then click Services.
    2. Right-click SharePoint 2010 Timer, and then click Stop.
    3. Close the Services console.
  2. On the computer that is running Microsoft SharePoint Server 2010 and on which the Central Administration site is hosted, click Start, click Run, type explorer, and then press ENTER.
  3. In Windows Explorer, locate and then double-click the following folder:
  4. %SystemDrive%\ProgramData\Microsoft\SharePoint\Config\GUID
  5. Notes Подробнее »

Permanent link to this article: http://www.blogss.ru/sharepoint-20102013-clearing-the-configuration-cache

Страница 1 из 1412345...10...Последняя »