In: IT| Microsoft| SQL Server| Software
14 Jan 2010
- Use the SQL Query Analyzer
BACKUP LOG XXX WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE(XXX_log, 10)
GO
- (replace XXX with the database name)

Thomas Maurer.
Born in 1986. live in Diegten. Switzerland. work as a System Administrator in Allschwil(Switzerland). interested in in Apple, IT, TV, Movies, Design and Art.