tag:blogger.com,1999:blog-10113675.post4324550796825389769..comments2023-10-20T10:58:23.215-04:00Comments on Tech Stories: Truncating your transaction log.Esteban Pachecohttp://www.blogger.com/profile/13637053045278905458noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-10113675.post-33342795196477211872008-01-04T09:47:00.000-05:002008-01-04T09:47:00.000-05:00This comment has been removed by a blog administrator.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-10113675.post-25365181453468840462008-01-02T01:53:00.000-05:002008-01-02T01:53:00.000-05:00For those amongst us who have been wondering: "wha...For those amongst us who have been wondering: "what SQL DBMS is he talking about?": It is MS SQL Server.<BR/><BR/>See MSDN for more info:<BR/><A HREF="http://msdn2.microsoft.com/en-us/library/aa258281.aspx" REL="nofollow">Transact-SQL Reference</A>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-10113675.post-44045514116157134132008-01-01T23:28:00.000-05:002008-01-01T23:28:00.000-05:00looks like your blog chewed up your commands..BACK...looks like your blog chewed up your commands..<BR/><BR/>BACKUP LOG [databasename] TO DISK = '[backupfile]'<BR/><BR/>DBCC SHRINKFILE ([filename], [targetsize]) WITH NO_INFOMSGSAnonymousnoreply@blogger.com