{"id":33,"date":"2013-08-19T12:54:29","date_gmt":"2013-08-19T11:54:29","guid":{"rendered":"http:\/\/sourceblog.org\/wordpress\/?p=33"},"modified":"2014-01-08T07:44:04","modified_gmt":"2014-01-08T06:44:04","slug":"verkleinern-von-log-dateien-vom-sharepoint","status":"publish","type":"post","link":"https:\/\/sourceblog.org\/wordpress\/2013\/08\/verkleinern-von-log-dateien-vom-sharepoint\/","title":{"rendered":"Verkleinern von mehreren Log-Dateien im SharePoint"},"content":{"rendered":"

Das Verkleinern der Log-Dateien der einzelnen SharePoint-Content Datenbanken kann mittels dieses kleinen SQL-Scripts erfolgen<\/span><\/p>\n

Exec sp_msforeachdb ‚
\nBEGIN
\ndeclare @LogFile nvarchar(2000)
\nUSE [?]
\nSelect @LogFile=Name From sys.database_files<\/address>\n
where sys.database_files.type = 1 and sys.database_files.name LIKE “WSS_%“
\nif @LogFile IS NOT NULL
\nBegin
\nPRINT @LogFile
\nEXEC(“ALTER DATABASE [?] SET RECOVERY SIMPLE“)
\nDBCC SHRINKFILE (@LogFile, 1)
\nEXEC(“ALTER DATABASE [?] SET RECOVERY FULL“)
\nEND
\nEND‘
\nGO<\/address>\n
\u00a0<\/address>\n

Hierbei ist zu beachten, dass\u00a0sys.database_files.name LIKE “WSS_%“\u00a0<\/em>nur die Log-Dateien von Content-Datenbanken selektiert, welche mit „WSS_“ beginnen.<\/p>\n

Sollen auch Log-Dateien anderer Datenbanken beachtet werden, muss diese Anweisung entsprechend angepasst werden.<\/p>\n

 <\/p>\n

[Update]<\/p>\n

der Fehler:<\/p>\n

Ein Sortierungskonflikt zwischen ‚Latin1_General_CI_AS_KS_WS‘ und ‚Latin1_General_CI_AS‘ im is not-Vorgang kann nicht aufgel\u00f6st werden.<\/p>\n

kann mit einer Collate Anweisung behoben werden.<\/p>\n","protected":false},"excerpt":{"rendered":"

Das Verkleinern der Log-Dateien der einzelnen SharePoint-Content Datenbanken kann mittels dieses kleinen SQL-Scripts erfolgen Exec sp_msforeachdb ‚ BEGIN declare @LogFile nvarchar(2000) USE [?] Select @LogFile=Name From sys.database_files where sys.database_files.type = 1 and sys.database_files.name LIKE “WSS_%“ if @LogFile IS NOT NULL … Weiterlesen →<\/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,37],"tags":[11,10,36,7],"class_list":["post-33","post","type-post","status-publish","format-standard","hentry","category-sp","category-sql","tag-bereinigen","tag-log","tag-sp","tag-sql"],"_links":{"self":[{"href":"https:\/\/sourceblog.org\/wordpress\/wp-json\/wp\/v2\/posts\/33","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=33"}],"version-history":[{"count":7,"href":"https:\/\/sourceblog.org\/wordpress\/wp-json\/wp\/v2\/posts\/33\/revisions"}],"predecessor-version":[{"id":65,"href":"https:\/\/sourceblog.org\/wordpress\/wp-json\/wp\/v2\/posts\/33\/revisions\/65"}],"wp:attachment":[{"href":"https:\/\/sourceblog.org\/wordpress\/wp-json\/wp\/v2\/media?parent=33"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sourceblog.org\/wordpress\/wp-json\/wp\/v2\/categories?post=33"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sourceblog.org\/wordpress\/wp-json\/wp\/v2\/tags?post=33"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}