{"id":188,"date":"2017-04-27T17:10:00","date_gmt":"2017-04-27T17:10:00","guid":{"rendered":"https:\/\/www.mainmind.com\/blog\/?p=188"},"modified":"2020-07-27T07:30:34","modified_gmt":"2020-07-27T07:30:34","slug":"tamano-de-base-de-datos-y-log-en-sql-server","status":"publish","type":"post","link":"https:\/\/www.mainmind.com\/blog\/tamano-de-base-de-datos-y-log-en-sql-server\/","title":{"rendered":"Tama\u00f1o de Base de datos y log en SQL Server"},"content":{"rendered":"<p>Desde las <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/system-catalog-views\/sys-databases-transact-sql\" target=\"_blank\" rel=\"noopener noreferrer\">bases de datos del sistema<\/a> podemos extraer todo tipo de informaci\u00f3n, para localizar dentro de una BBDD de una instancia concreta de SQL podemos extraer con una consulta la informaci\u00f3n de los tama\u00f1os que ocupan:<\/p>\n<pre class=\"brush:sql;auto-links:false;toolbar:false\" contenteditable=\"false\">with mf\nas\n(\n    select database_id, type, size * 8.0 \/ 1024 size\n    from sys.master_files\n)\nselect \n    name, db.is_auto_shrink_on, \n    (select sum(size) from mf where type = 0 and mf.database_id = db.database_id) DatosMB,\n    (select sum(size) from mf where type = 1 and mf.database_id = db.database_id) LogMB\nfrom sys.databases db<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Desde las bases de datos del sistema podemos extraer todo tipo de informaci\u00f3n, para localizar dentro de una BBDD de una instancia concreta de SQL podemos extraer con una consulta la informaci\u00f3n de los tama\u00f1os que ocupan: with mf as ( select database_id, type, size * 8.0 \/ 1024 size from sys.master_files ) select name, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[386,388,389,178,387],"class_list":["post-188","post","type-post","status-publish","format-standard","hentry","category-bases-de-datos","tag-base-de-datos","tag-log","tag-registros","tag-sql-server","tag-tamano"],"_links":{"self":[{"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/posts\/188","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/comments?post=188"}],"version-history":[{"count":0,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/posts\/188\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/media?parent=188"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/categories?post=188"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/tags?post=188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}