{"id":1086,"date":"2012-07-27T18:47:20","date_gmt":"2012-07-27T16:47:20","guid":{"rendered":"http:\/\/www.servernet.dk\/?p=1086"},"modified":"2012-07-27T18:53:25","modified_gmt":"2012-07-27T16:53:25","slug":"how-to-truncate-and-shrink-transaction-log-file-in-sql-server-2008-r2","status":"publish","type":"post","link":"http:\/\/www.servernet.dk\/?p=1086","title":{"rendered":"How to truncate and shrink Transaction Log file in SQL Server 2008 R2"},"content":{"rendered":"<address><span style=\"color: #0000ff;\">select <\/span>name,recovery_model_desc <span style=\"color: #0000ff;\">from<\/span> <span style=\"color: #339966;\">sys.databases<\/span><\/address>\n<address><span style=\"color: #0000ff;\">GO<\/span><\/address>\n<address><span style=\"color: #0000ff;\">Alter database<\/span> <span style=\"color: #ff0000;\">DATABASENAME<\/span> <span style=\"color: #0000ff;\">Set Recovery simple<\/span><\/address>\n<address><span style=\"color: #0000ff;\">GO<\/span><\/address>\n<address><span style=\"color: #000000;\"><span style=\"color: #0000ff;\">Declare\u00a0<\/span><span style=\"font-size: small;\">@LogFileLogicalName <\/span><span style=\"color: #0000ff; font-size: small;\"><span style=\"font-size: small;\">sysname<\/span><\/span><\/span><\/address>\n<address><span style=\"color: #000000;\"><span style=\"color: #0000ff;\">select<\/span> <span style=\"font-size: small;\">@LogFileLogicalName<\/span><span style=\"font-size: small;\"><span style=\"font-size: small;\">=<\/span><\/span><\/span>Name <span style=\"color: #000000;\"><span style=\"font-size: small;\"><span style=\"font-size: small;\"><span style=\"color: #0000ff;\">from<\/span> <\/span><\/span><span style=\"color: #339966;\"><span style=\"font-size: small;\"><span style=\"font-size: small;\">sys<\/span><\/span><span style=\"font-size: small;\"><span style=\"font-size: small;\">.<\/span><\/span><span style=\"font-size: small;\"><span style=\"font-size: small;\">database_files <\/span><\/span><\/span><span style=\"font-size: small;\"><span style=\"font-size: small;\"><span style=\"color: #0000ff;\">where<\/span> <\/span><\/span><span style=\"color: #0000ff; font-size: small;\"><span style=\"font-size: small;\">Type<\/span><\/span><span style=\"font-size: small;\"><span style=\"font-size: small;\">=<\/span><\/span><span style=\"font-size: small;\">1<\/span><\/span><\/address>\n<address><span style=\"color: #0000ff;\">print\u00a0<\/span><span style=\"font-size: small;\">@LogFileLogicalName<\/span><\/address>\n<address><span style=\"color: #0000ff;\">DBCC<\/span> <span style=\"font-size: small;\">Shrinkfile<\/span><span style=\"color: #808080; font-size: small;\"><span style=\"color: #808080; font-size: small;\">(<\/span><\/span><span style=\"font-size: small;\">@LogFileLogicalName<\/span><span style=\"color: #808080; font-size: small;\"><span style=\"color: #808080; font-size: small;\">,<\/span><\/span><span style=\"font-size: small;\">100<\/span><span style=\"color: #808080; font-size: small;\"><span style=\"color: #808080; font-size: small;\">)<\/span><\/span><\/address>\n<address>\u00a0<\/address>\n<address>\u00a0<\/address>\n","protected":false},"excerpt":{"rendered":"<p>select name,recovery_model_desc from sys.databases GO Alter database DATABASENAME Set Recovery simple GO Declare\u00a0@LogFileLogicalName sysname select @LogFileLogicalName=Name from sys.database_files where Type=1 print\u00a0@LogFileLogicalName DBCC Shrinkfile(@LogFileLogicalName,100) \u00a0 \u00a0<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[204],"tags":[290],"class_list":["post-1086","post","type-post","status-publish","format-standard","hentry","category-microsoft-sql","tag-sql-2008-log"],"_links":{"self":[{"href":"http:\/\/www.servernet.dk\/index.php?rest_route=\/wp\/v2\/posts\/1086","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.servernet.dk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.servernet.dk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.servernet.dk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.servernet.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1086"}],"version-history":[{"count":7,"href":"http:\/\/www.servernet.dk\/index.php?rest_route=\/wp\/v2\/posts\/1086\/revisions"}],"predecessor-version":[{"id":1089,"href":"http:\/\/www.servernet.dk\/index.php?rest_route=\/wp\/v2\/posts\/1086\/revisions\/1089"}],"wp:attachment":[{"href":"http:\/\/www.servernet.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1086"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.servernet.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1086"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.servernet.dk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1086"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}