Use SQL Management Studio & connect to ##SSEE database
Choose the ShareWebDB
New query & run below to reduce log file size
USE ShareWebDb
GO
DBCC SHRINKFILE(ShareWebDb_log, 1)
BACKUP LOG ShareWebDb WITH TRUNCATE_ONLY
DBCC SHRINKFILE(ShareWebDb_log, 1)
GO
Friday, 31 January 2014
Wednesday, 22 January 2014
Connecting to the Windows Internal Database (MICROSOFT##SSEE)
Using SQL Management Studio
The server name to connect to is
\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
The server name to connect to is
\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
Thursday, 9 January 2014
Remove disconnected mailboxes in Exchange 2007
Get all disconnected mailboxes
Get-MailboxStatistics | where-object { $_.DisconnectDate -ne $null } | Select DisplayName,MailboxGuid
Remove a single disconnected mailbox
Remove-Mailbox -Database -StoreMailboxIdentity -confirm:$false
Remove all disconnected mailboxes
$users = Get-MailboxStatistics | where-object { $_.DisconnectDate -ne $null } | Select DisplayName,MailboxGuid,Database
Then all disconnected mailboxes are in a variable and you run following cmdlet to remove mailboxes
$users | ForEach { Remove-Mailbox -Database $_.Database -StoreMailboxIdentity $_.MailboxGuid -confirm:$false }
Subscribe to:
Posts (Atom)