Posts Tagged ‘Microsoft SQL Server 2000

var fbShare = {url: ‘http://www.thomasmaurer.ch/2010/01/shrinking-the-transaction-log-in-sql-server-2000/’,size:’small’}

Use the SQL Query Analyzer

BACKUP LOG XXX WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE(XXX_log, 10)
GO

(replace XXX with the database name)


about thomasmaurer.ch

Thomas Maurer

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.

Follow me on twitter

My Tweets

Latest Photos

IMG_0019DSCN0078DSCN0077DSCN0325.JPGDSCN0324.JPGDSCN0323.JPG

Ad