Open the Exchange Powershell and type the following to view the language of the mailbox.
Get-Mailbox -Identity "Noel Pulis" | fl name, languages
Now, to change the language of the mailbox use the below, for example the code below will change my mailbox to English.
Set-Mailbox -Identity "Noel Pulis" -Languages "en-GB"
(641)
Making a scheduled automated shrink logs for the databases with specific space to shrink.
DECLARE @Step1 VARCHAR(200)
DECLARE @Name varchar(50)
DECLARE DBNames CURSOR
FOR
SELECT NAME FROM sysdatabases WHERE dbid > 4
OPEN DBNames
FETCH NEXT FROM DBNames INTO @Name WHILE (@@FETCH_STATUS <> -1)
BEGIN
SET @Step1 = 'USE ' + @Name + '' + CHAR(10)
SET @Step1 = @Step1 + 'ALTER DATABASE [' + @Name + '] SET RECOVERY SIMPLE;' + CHAR(10)
SET @Step1 = @Step1 + 'DBCC SHRINKFILE (' +@Name + '_LOG, 500);' + CHAR(10)
SET @Step1 = @Step1 + 'ALTER DATABASE [' + @Name + '] SET RECOVERY FULL;' + CHAR(10)
EXEC (@Step1)
FETCH NEXT FROM DBNames INTO @Name
END
CLOSE DBNames
DEALLOCATE DBNames
(54858)
Technical help and scripts for everyday issues of a system administrator