Kenneth Qvistgaard Dalbjerg, IT Konsulent i århus
Citrix Certified

Archive for the ‘Windows’ Category

Microsoft Excel har fundet en fejl og afsluttes. Vi beklager ulejligheden ved afslutning af Excel

Thursday, January 20th, 2011 Posted in Computer, Windows | 2 Comments »

Nå du lukker et Excel ned, så kan den komme den og sige: Microsoft Excel har fundet en fejl og afsluttes. Dette kan muligvis løses ved at gå ned i start og vælg kø, skriv her: regedit og tryk kør Gå ...

howto export mailbox size to CSV file Exchange 2007/2010

Tuesday, December 7th, 2010 Posted in Exchange | No Comments »

Howto Export all mailbox'es and there size to a CSV file get-mailbox | get-mailboxstatistics | select-object DisplayName,TotalItemSize,StorageLimitStatus,LastLogonTime | Export-Csv c:\exchange.csv

Test Exchange remote connectivity

Tuesday, November 9th, 2010 Posted in Computer, Exchange, Windows | No Comments »

Microsoft have launch a new webpage to test Exchange remote connectivity. It can test: ActiveSync Activesync autodiscover Outlook autodiscover Microsoft Exchange Web Services Connectivity Tests Outlook Anywhere (RPC over HTTP) Inbound SMTP E-Mail Outbound SMTP E-Mail https://www.testexchangeconnectivity.com/

A problem occurred while trying to use your mailbox

Thursday, November 4th, 2010 Posted in Exchange, Windows | No Comments »

Today i have a user that could get access to the exchange webmail. (OWA). There are som solutions for this error, try to fix from bullet number 1, and down. Get-Mailbox User_Name | format-list ExchangeVersion if the version is below 0.1 the run ...

Howto shrink / truncate SQL transaction log file in SQL Server 2005

Friday, October 15th, 2010 Posted in MSSQL, Windows | No Comments »

USE <databasename> GO DBCC SHRINKFILE('<logfilename-logical name>', 1) BACKUP LOG <databasename> WITH TRUNCATE_ONLY DBCC SHRINKFILE('<logfilename-logical name>', 1) GO

Microsoft SQL (MSSQL) query for active session

Friday, October 15th, 2010 Posted in MSSQL, Windows | No Comments »

Howto see active sessions in a mssql. Its pretty easy just make a new query, and run sp_who or sp_who2. sp_who shows whitch active sessions there are, and sp_who2 shows more information about the users.

Ahsay and Exchange 2007 / 2010 document level backup

Friday, October 8th, 2010 Posted in Ahsay, Computer, Exchange, Windows | 1 Comment »

Post updated look here: http://kennethdalbjerg.dk/2011/02/04/backup-of-exchange-2010-with-ahsay

Export Exchange 2007/2010 tracking log

Wednesday, September 1st, 2010 Posted in Computer, Exchange, Windows | No Comments »

To export Exchange 2007/2010 tracking log to a Excel, just run this command. get-messagetrackinglog -Start "31-08-2010 00:00:00" -End "01-09-2010 12:16:00" -resultsize Unlimited | select-object Timestamp,ClientIp,ClientHostname,ServerIp,ServerHostname,SourceContext,ConnectorId,Source,EventId,InternalMessageId,MessageId,TotalBytes,RecipientCount,MessageSubject,Sender,ReturnPath,@{Name="Recipients";Expression={$_.recipients}},MessageInfo | Export-Csv It will export all mails from 31/8-2010 to 1/9-2010, with the selected fiels.

Network Policy Server problems

Friday, June 4th, 2010 Posted in Cisco, Windows | No Comments »

I have a network policy server that din't work. There was nothing standing in the Event viewer. I have install Wireshack and could se the packets was incoming and a reject was coming back to the Radius Client. I was search ...

Exchange 2007 – Ahsay restore to a recovery group

Tuesday, May 25th, 2010 Posted in Ahsay, Exchange, Windows | No Comments »

Ahsay have no support for native restore to Exchange recovery group, but here is a workaround of that problems. First create a recovery storagegroup new-storagegroup -LogFolderPath F:\Backup\Restore\Logs -Name ExchangeRestore -SystemFolderPath F:\Backup\Restore\Data -Recovery Then create a empty database new-mailboxdatabase -mailboxdatabasetorecover "Mailbox Database" -storagegroup ExchangeRestore -edbfilepath ...