Howto shrink / truncate SQL transaction log file in SQL Server 2005
admin USE <databasename> GO DBCC SHRINKFILE(‘<logfilename-logical name>’, 1) BACKUP LOG <databasename> WITH TRUNCATE_ONLY DBCC SHRINKFILE(‘<logfilename-logical name>’, 1) GO
Windows
Microsoft SQL (MSSQL) query for active session
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…
Ahsay and Exchange 2007 / 2010 document level backup
Post updated look here: http://kennethdalbjerg.dk/2011/02/04/backup-of-exchange-2010-with-ahsay
Export Exchange 2007/2010 tracking log
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…
Network Policy Server problems
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…
Exchange 2007 – Ahsay restore to a recovery group
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…
Vmware ESX 3.5 and Dell openmanage
First you need to install: http://www.vmware.com/download/download.do?downloadGroup=VI-RCLI-U2 This is a vmware Remote CLI tools. Install it on a windows machine. After you install remember to log out and the log in,…
Outlook crash on opening a shared calendar
I have a problems today with an Outlook that keeps crash sometimes when a user is opening a share calendar. I tested it on my test machine and when the…
Delegates (Stedfortræder) problems in outlook
The error messages in Danish: Indstillingerne for stedfortrædere blev ikke gemt korrekt. send på vegne af-liste kunne ikke aktiveres. Du har ikke den nødvendige tilladelse til at udføre denne handling…
Vmware ESXi (ESX) 4.0 and Dell Openmanage SNMP Traps
First you need to install: http://www.vmware.com/downloads/download.do?downloadGroup=VCLI40U1 This is a vmware CLI tools. Install it on a windows machine. After you install remember to log out and the log in, else…