tag:blogger.com,1999:blog-10113675.post4324550796825389769..comments2008-01-04T08:35:02.901-08:00Esteban Pachecohttp://www.blogger.com/profile/13637053045278905458noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-10113675.post-25365181453468840462008-01-01T22:53:00.000-08:002008-01-01T22:53:00.000-08:00For 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-01T20:28:00.000-08:002008-01-01T20:28:00.000-08:00looks 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