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
October 2010
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