USE <databasename>
GO
DBCC SHRINKFILE(‘<logfilename-logical name>’, 1)
BACKUP LOG <databasename> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(‘<logfilename-logical name>’, 1)
GO
USE <databasename>
GO
DBCC SHRINKFILE(‘<logfilename-logical name>’, 1)
BACKUP LOG <databasename> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(‘<logfilename-logical name>’, 1)
GO
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.
Post updated look here: http://kennethdalbjerg.dk/2011/02/04/backup-of-exchange-2010-with-ahsay