Truncate log on MS Sql 2005
When the transaztion log is full, you can truncate it by using this query: USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO <TransactionLogName> is the name of the t log without extension and path _____________________________________ Stefano Mazgon