adminSELECT file_id, name FROM sys.database_files BACKUP LOG [databaseName] TO DISK=‘nul:’ WITH STATS= 10 DBCC SHRINKFILE(‘templog’, 0, TRUNCATEONLY)
Posts
Unable to display in Datasheet view
You need to install the following – http://www.microsoft.com/en-us/download/details.aspx?id=23734
Get Office 365 Last Login Stats
$objUsers = get-mailbox -ResultSize Unlimited | select UserPrincipalName #Iterate through all users foreach ($objUser in $objUsers) { #Connect to the users mailbox $objUserMailbox = get-mailboxstatistics […]
Using ADSIEdit to change e-mail aliases on Office 365
Go to Start > Run and type adsiedit.msc Now, find the unit where your AD user’s reside Right click the user you want to edit […]
Enabling Desktop Experience in Server 2012
Type this in command prompt: dism /online /enable-feature /all /featurename:DesktopExperience
Setting Calendar permission Exchange 2010
To set the sharing permission for you, please refer the steps below, 1), connect to Exchange Online through PowerShell as administrator. 2), run Get-Mailbox to […]
Setting Office 365 User with Send As permission
Connect to O365 $LiveCred = Get-Credential $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook.com/powershell/ -Credential $LiveCred -Authentication Basic -AllowRedirection Import-PSSession $Session Send As Add-RecipientPermission sendas@yourdomain.com […]
Converting Office 365 User Mailbox to Shared Mailbox
First connect to Office 365 Connect to O365 $LiveCred = Get-Credential $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook.com/powershell/ -Credential $LiveCred -Authentication Basic -AllowRedirection Import-PSSession $Session […]