{"id":218,"date":"2013-04-29T12:34:13","date_gmt":"2013-04-29T18:34:13","guid":{"rendered":"http:\/\/s1095387061.online-home.ca\/?p=218"},"modified":"2013-04-30T12:35:16","modified_gmt":"2013-04-30T18:35:16","slug":"mssql-tips-tip-8","status":"publish","type":"post","link":"https:\/\/databaserefresh.com\/blog\/mssql-tips-tip-8\/","title":{"rendered":"MSSQL Tips: Tip #8 \u2013 Using Policy Based Management to check number of SQL Server data and log files"},"content":{"rendered":"

In this tip I explain how to make sure that you have only one database transaction log file and more than one data file using policy based management.<\/p>\n

Please read this MSSQL Tip: “Using Policy Based Management for checking SQL Server database file extensions<\/a>“.<\/p>\n

Check out all of my tips here: http:\/\/www.mssqltips.com\/sqlserverauthor\/94\/svetlana-golovko\/<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

In this tip I explain how to make sure that you have only one database transaction log file and more than one data file using policy based management. Please read this MSSQL Tip: “Using Policy Based Management for checking SQL … Continue reading →<\/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,"footnotes":""},"categories":[12,4,30],"tags":[50,49,42,48,39],"class_list":["post-218","post","type-post","status-publish","format-standard","hentry","category-dba_checks","category-sql_server_config","category-tips-sql_server","tag-best-practice","tag-db-files","tag-mssqltips","tag-policies","tag-policy-based-management"],"_links":{"self":[{"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/posts\/218","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/comments?post=218"}],"version-history":[{"count":4,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/posts\/218\/revisions"}],"predecessor-version":[{"id":221,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/posts\/218\/revisions\/221"}],"wp:attachment":[{"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/media?parent=218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/categories?post=218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/tags?post=218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}