{"id":7,"date":"2013-08-09T13:03:38","date_gmt":"2013-08-09T13:03:38","guid":{"rendered":"http:\/\/sourceblog.org\/wordpress\/?p=7"},"modified":"2013-12-05T11:56:35","modified_gmt":"2013-12-05T10:56:35","slug":"verkleinerung-der-datenbanklogdateien","status":"publish","type":"post","link":"https:\/\/sourceblog.org\/wordpress\/2013\/08\/verkleinerung-der-datenbanklogdateien\/","title":{"rendered":"Verkleinerung einer Datenbanklogdateien"},"content":{"rendered":"<p>In manchen F\u00e4llen ist es notwendig die Datenbanklogdateien einer Datenbank im SharePoint zu verkleinern.<\/p>\n<p>Dies kann mittels eines kleinen Scriptes erfolgen, welches im Microsoft SQL Server Management Studio ausgef\u00fchrt wird.<\/p>\n<p>Als erstes w\u00e4hlt man die entsprechende Datenbank aus.<\/p>\n<address style=\"padding-left: 30px;\">use\u00a0<span style=\"color: #ff0000;\">Datenbankname<\/span><\/address>\n<address style=\"padding-left: 30px;\">go<\/address>\n<p>Anschlie\u00dfend sollte das Recovery-Modell dieser Datenbank auf simple gesetzt werden.<\/p>\n<address style=\"padding-left: 30px;\"><em>ALTER DATABASE\u00a0<span style=\"color: #ff0000;\">Datenbankname<\/span><\/em><\/address>\n<address style=\"padding-left: 30px;\"><em>SET RECOVERY SIMPLE<\/em><\/address>\n<address style=\"padding-left: 30px;\">go<\/address>\n<p>Nun kann die Log-Datei verkleinert werden<\/p>\n<address style=\"padding-left: 30px;\"><em>\u00a0DBCC SHRINKFILE(\u00a0<span style=\"color: #ff0000;\">Datenbankname_log<\/span>,\u00a0<span style=\"color: #ff0000;\">Gr\u00f6\u00dfe<\/span>)<\/em><\/address>\n<address style=\"padding-left: 30px;\"><em>go<\/em><\/address>\n<p>Abschlie\u00dfend sollte man das Recovery-Modell wieder auf \u00a0Full setzen.<\/p>\n<address style=\"padding-left: 30px;\"><em>ALTER DATABASE\u00a0<span style=\"color: #ff0000;\">Datenbankname<\/span><\/em><\/address>\n<address style=\"padding-left: 30px;\"><em>SET RECOVERY FULL<\/em><\/address>\n<address style=\"padding-left: 30px;\">go<\/address>\n","protected":false},"excerpt":{"rendered":"<p>In manchen F\u00e4llen ist es notwendig die Datenbanklogdateien einer Datenbank im SharePoint zu verkleinern. Dies kann mittels eines kleinen Scriptes erfolgen, welches im Microsoft SQL Server Management Studio ausgef\u00fchrt wird. Als erstes w\u00e4hlt man die entsprechende Datenbank aus. use\u00a0Datenbankname go &hellip; <a href=\"https:\/\/sourceblog.org\/wordpress\/2013\/08\/verkleinerung-der-datenbanklogdateien\/\">Weiterlesen <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[3],"tags":[11,9,10,36],"class_list":["post-7","post","type-post","status-publish","format-standard","hentry","category-sp","tag-bereinigen","tag-datenbanken","tag-log","tag-sp"],"_links":{"self":[{"href":"https:\/\/sourceblog.org\/wordpress\/wp-json\/wp\/v2\/posts\/7","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sourceblog.org\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sourceblog.org\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sourceblog.org\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sourceblog.org\/wordpress\/wp-json\/wp\/v2\/comments?post=7"}],"version-history":[{"count":8,"href":"https:\/\/sourceblog.org\/wordpress\/wp-json\/wp\/v2\/posts\/7\/revisions"}],"predecessor-version":[{"id":83,"href":"https:\/\/sourceblog.org\/wordpress\/wp-json\/wp\/v2\/posts\/7\/revisions\/83"}],"wp:attachment":[{"href":"https:\/\/sourceblog.org\/wordpress\/wp-json\/wp\/v2\/media?parent=7"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sourceblog.org\/wordpress\/wp-json\/wp\/v2\/categories?post=7"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sourceblog.org\/wordpress\/wp-json\/wp\/v2\/tags?post=7"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}