{"id":69,"date":"2017-09-18T23:00:29","date_gmt":"2017-09-18T23:00:29","guid":{"rendered":"http:\/\/www.manualsqlserver.com\/?p=69"},"modified":"2020-05-19T04:27:04","modified_gmt":"2020-05-19T04:27:04","slug":"bases-de-datos-del-sistema","status":"publish","type":"post","link":"https:\/\/manualsqlserver.com\/?p=69","title":{"rendered":"Bases de datos del Sistema"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_ServiciosSQLBasesSistema.png\" alt=\"\" class=\"wp-image-1100\" width=\"204\" height=\"250\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_ServiciosSQLBasesSistema.png 300w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_ServiciosSQLBasesSistema-245x300.png 245w\" sizes=\"auto, (max-width: 204px) 100vw, 204px\" \/><\/figure>\n\n\n\n<p>Las bases de datos del Sistema que tiene SQL Server son: Master, msdb, Model y TempDB<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>Para acceder a las bases de datos del sistema se despliega el nodo \u00abBases de datos del sistema\u00bb del Explorador de objetos de SQL Server.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_ServiciosSQLBasesSistema01.png\" alt=\"\" class=\"wp-image-1101\" width=\"449\" height=\"243\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_ServiciosSQLBasesSistema01.png 349w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_ServiciosSQLBasesSistema01-300x162.png 300w\" sizes=\"auto, (max-width: 449px) 100vw, 449px\" \/><\/figure><\/div>\n\n\n\n<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\n<ins class=\"adsbygoogle\"\n     style=\"display:block; text-align:center;\"\n     data-ad-layout=\"in-article\"\n     data-ad-format=\"fluid\"\n     data-ad-client=\"ca-pub-2636008503986218\"\n     data-ad-slot=\"1902193434\"><\/ins>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n\n\n\n<ul class=\"wp-block-list\"><li>Base de datos Master<\/li><\/ul>\n\n\n\n<p>Base de datos que registra toda la informaci\u00f3n del sistema para una instancia de SQL Server. La base de datos master es \u00fanica en la instancia de SQL Server, en esta base de datos se puede consultar la existencia de todos los objetos de todas las bases de datos creadas o adjuntadas en la instancia.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Base de datos msdb<\/li><\/ul>\n\n\n\n<p>La utiliza el Agente SQL Server para programar alertas y trabajos. El agente SQL permite realizar los trabajos&nbsp;que ejecutan tareas, generalmente de aplicaciones para Inteligencia de Negocios y Toma de Decisiones.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Base de datos model<\/li><\/ul>\n\n\n\n<p>Se utiliza como plantilla o&nbsp; modelo para todas las bases de datos creadas en la instancia de SQL Server con la instrucci\u00f3n Create Table sin especificar los valores y caracter\u00edsticas para cada par\u00e1metro de Base de datos. Las modificaciones hechas a la base de datos&nbsp;<strong>model<\/strong>, como el tama\u00f1o de la base de datos, la intercalaci\u00f3n, el modelo de recuperaci\u00f3n y otras opciones, se aplicar\u00e1n a las bases de datos que se creen con posterioridad.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Base de datos tempdb<\/li><\/ul>\n\n\n\n<p>\u00c1rea de trabajo que contiene objetos temporales o conjuntos de resultados intermedios.<br><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br><ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-8212748961777604\" data-ad-slot=\"1807313726\"><\/ins><br><script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Las bases de datos del Sistema que tiene SQL Server son: Master, msdb, Model y TempDB<\/p><p><a class=\"more-link btn\" href=\"https:\/\/manualsqlserver.com\/?p=69\">Seguir leyendo<\/a><\/p>\n","protected":false},"author":1,"featured_media":1100,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[81,82,83,53,58],"class_list":["post-69","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-crearbd","tag-master","tag-model","tag-msdb","tag-sqlserver","tag-tempdb","nodate","item-wrap"],"_links":{"self":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/69","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=69"}],"version-history":[{"count":1,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/69\/revisions"}],"predecessor-version":[{"id":1103,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/69\/revisions\/1103"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/media\/1100"}],"wp:attachment":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=69"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=69"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=69"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}