{"id":19,"date":"2008-03-25T10:01:00","date_gmt":"2008-03-25T09:01:00","guid":{"rendered":"https:\/\/iddlesblog.wordpress.com\/2008\/03\/25\/flushing-sql-transaction-logs\/"},"modified":"2008-03-25T10:01:00","modified_gmt":"2008-03-25T09:01:00","slug":"flushing-sql-transaction-logs","status":"publish","type":"post","link":"https:\/\/iddles.co.uk\/index.php\/2008\/03\/25\/flushing-sql-transaction-logs\/","title":{"rendered":"Flushing SQL Transaction Logs"},"content":{"rendered":"

Can never remember the syntax so here is is as a reminder:
\nMake the database current then run
\n<\/p>\n

DBCC<\/em><\/p><\/blockquote>\n

<\/font><\/span><\/p>\n

\u00a0<\/p><\/blockquote>\n

<\/span><\/p>\n

SHRINKFILE<\/span>(<\/span>‘Foo_LOG’<\/span>,<\/span>1<\/span>)\u00a0
\n<\/font><\/em><\/span>\u00a0
\n<\/em><\/span><\/em>BACKUP<\/em>
\n<\/font><\/span>\u00a0
\n<\/span>
\n <\/span>LOG Foo<\/span>\u00a0<\/span>WITH<\/span> TRUNCATE_ONLY \u00a0
\n<\/font><\/em><\/span>\u00a0
\n<\/em><\/span><\/em>DBCC<\/em>
\n<\/font><\/span>\u00a0
\n<\/span>
\n SHRINKFILE<\/span>(<\/span>‘Foo_LOG’<\/span>,<\/span>1<\/span>)\u00a0
\n<\/font><\/em><\/span>\u00a0
\n<\/em><\/span><\/em>go<\/em>
\n\u00a0
\n<\/font><\/span>\u00a0
\n<\/span><\/p><\/blockquote>\n

\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

Can never remember the syntax so here is is as a reminder: Make the database current then run DBCC \u00a0 SHRINKFILE(‘Foo_LOG’,1)\u00a0 \u00a0 BACKUP \u00a0 LOG Foo\u00a0WITH TRUNCATE_ONLY \u00a0 \u00a0 DBCC \u00a0 SHRINKFILE(‘Foo_LOG’,1)\u00a0 \u00a0 go \u00a0 \u00a0<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"categories":[17],"tags":[33,49,51],"class_list":["post-19","post","type-post","status-publish","format-standard","hentry","category-windows","tag-flush","tag-sql-server","tag-transaction-log","post-preview"],"_links":{"self":[{"href":"https:\/\/iddles.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/19","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/iddles.co.uk\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/iddles.co.uk\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/iddles.co.uk\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/iddles.co.uk\/index.php\/wp-json\/wp\/v2\/comments?post=19"}],"version-history":[{"count":0,"href":"https:\/\/iddles.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/19\/revisions"}],"wp:attachment":[{"href":"https:\/\/iddles.co.uk\/index.php\/wp-json\/wp\/v2\/media?parent=19"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/iddles.co.uk\/index.php\/wp-json\/wp\/v2\/categories?post=19"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/iddles.co.uk\/index.php\/wp-json\/wp\/v2\/tags?post=19"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}