{"id":88,"date":"2017-09-18T21:40:20","date_gmt":"2017-09-18T21:40:20","guid":{"rendered":"http:\/\/www.manualsqlserver.com\/?p=88"},"modified":"2020-05-20T03:50:52","modified_gmt":"2020-05-20T03:50:52","slug":"create-database-ejemplos","status":"publish","type":"post","link":"https:\/\/manualsqlserver.com\/?p=88","title":{"rendered":"Create Database &#8211; ejemplos"},"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_ServiciosSQLCreateDatabaseEjercicios1-1.png\" alt=\"\" class=\"wp-image-1263\" width=\"323\" height=\"323\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_ServiciosSQLCreateDatabaseEjercicios1-1.png 300w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_ServiciosSQLCreateDatabaseEjercicios1-1-150x150.png 150w\" sizes=\"auto, (max-width: 323px) 100vw, 323px\" \/><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\"><strong>Creando Bases de datos en SQL Server<\/strong><\/h1>\n\n\n\n<p>Las bases de datos en SQL Server deben estar ubicadas en carpetas con seguridad local y separadas en varios discos para optimizar el acceso a los datos. (<a href=\"http:\/\/www.manualsqlserver.com\/?p=82\">Ver Create Database<\/a>)<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>Las bases de datos del usuario deber\u00edan estar separadas de las bases de datos del sistema, es necesario planear correctamente la ubicaci\u00f3n de los archivos de base de datos para que puedan soportar la escalabilidad de la misma. Para mejor informaci\u00f3n ver <a href=\"http:\/\/www.manualsqlserver.com\/?p=78\">Grupos de archivos<\/a> y <a href=\"http:\/\/www.manualsqlserver.com\/?p=75\">Archivos de base de datos<\/a><\/p>\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<h2 class=\"wp-block-heading\">Ejercicios<\/h2>\n\n\n\n<p><strong>1.- \u00a0EmpresaDB distribuida en varios discos.<\/strong><\/p>\n\n\n\n<p>xp_create_subdir &#8216;C:\\BasesContable&#8217;<br>go<br>xp_create_subdir &#8216;D:\\RRHH\\Bases&#8217;<br>go<br>xp_create_subdir &#8216;E:\\BasesFinanzas&#8217;<br>go<br>Create database EmpresaBD<br>on Primary<br>(Name= &#8216;EmpresaBD01&#8242;, Filename=&#8217;D:\\RRHH\\Bases\\EmpresaBD01.mdf&#8217;,<br>Size= 10MB, Maxsize= 30GB, Filegrowth=10MB),<br>Filegroup CONTABILIDAD<br>(Name= &#8216;EmpresaBD02&#8242;, Filename=&#8217;C:\\BasesContable\\EmpresaBD02.ndf&#8217;),<br>Filegroup VENTAS<br>(Name= &#8216;Ventas1&#8242;, Filename=&#8217;E:\\BasesFinanzas\\Ventas1.ndf&#8217;,<br>Size= 30MB, Maxsize= 20GB, Filegrowth=30%)<br>log on<br>(Name= &#8216;EmpresaT1&#8242;, Filename=&#8217;C:\\BasesContable\\EmpresaT1.ldf&#8217;)<br>go<\/p>\n\n\n\n<p><strong>2.- Las extensiones de los archivos pueden ser diferentes a las que reconoce el sistema operativo para los archivos primario, secundarios y de transacciones.<\/strong><\/p>\n\n\n\n<p>xp_create_subdir &#8216;C:\\BasesContable&#8217;<br>go<br>xp_create_subdir &#8216;D:\\RRHH\\Bases&#8217;<br>go<br>xp_create_subdir &#8216;E:\\BasesFinanzas&#8217;<br>go<br>Create database Lab<br>on Primary<br>(Name= &#8216;Lab01&#8242;, Filename=&#8217;D:\\RRHH\\Bases\\Lab01.bmp&#8217;),<br>Filegroup VENTASLab<br>(Name= &#8216;V1&#8242;, Filename=&#8217;E:\\BasesFinanzas\\V1.xlsx&#8217;)<br>log on<br>(Name= &#8216;Foto&#8217;, Filename=&#8217;C:\\BasesContable\\Foto.gif&#8217;)<br>go<\/p>\n\n\n\n<p>Note que los archivos tienen extensiones de archivos bmp, xlsx y gif<\/p>\n\n\n\n<p><strong>3.- \u00a0Dos ejemplos m\u00e1s. Note que de preferencia se debe ejecutar la instrucci\u00f3n que crea las carpetas.<\/strong><\/p>\n\n\n\n<p>xp_create_subdir &#8216;C:\\Bases&#8217;<br>go<br>xp_create_subdir &#8216;D:\\Sistemas\\Contable&#8217;<br>go<br>xp_create_subdir &#8216;E:\\Bancos&#8217;<br>go<br>Create database Fabrica<br>on Primary<br>(Name=&#8217;F01&#8242;, filename = &#8216;E:\\Bancos\\F01.mdf&#8217;,<br>Size = 10MB, MaxSize = 200 MB, Filegrowth = 20MB),<br>Filegroup FINANZAS<br>(Name=&#8217;Finanzas01&#8242;, filename = &#8216;C:\\Bases\\Finanzas01.ndf&#8217;),<br>(Name=&#8217;Finanzas02&#8242;, filename = &#8216;D:\\Sistemas\\Finanzas02.ndf&#8217;,<br>Size = 100MB, MaxSize = 2GB, Filegrowth = 20MB),<br>Filegroup VENTAS<br>(Name=&#8217;Ventas01&#8242;, filename = &#8216;D:\\Sistemas\\Ventas01.ndf&#8217;)<br>log on<br>(Name=&#8217;Transacciones01&#8242;, filename = &#8216;D:\\Sistemas\\Contable\\Transacciones01.ldf&#8217;)<br>go<\/p>\n\n\n\n<p>Las extensiones de los archivos pueden ser cualquiera<\/p>\n\n\n\n<p>Create database Lotes<br>on Primary<br>(Name=&#8217;Lotes01&#8242;, filename = &#8216;C:\\Bases\\Lotes01.jpg&#8217;),<br>Filegroup CUENTAS<br>(Name=&#8217;Nenas&#8217;, filename = &#8216;C:\\Bases\\Nenas.mp4&#8217;)<br>log on<br>(Name=&#8217;Claves&#8217;, filename = &#8216;C:\\Bases\\Claves.docx&#8217;)<br>go<\/p>\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","protected":false},"excerpt":{"rendered":"<p>Creando Bases de datos en SQL Server Las bases de datos en SQL Server deben estar ubicadas en carpetas con seguridad local y separadas en varios discos para optimizar el acceso a los datos. (Ver Create Database)<\/p><p><a class=\"more-link btn\" href=\"https:\/\/manualsqlserver.com\/?p=88\">Seguir leyendo<\/a><\/p>\n","protected":false},"author":1,"featured_media":1263,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[107,15],"class_list":["post-88","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-crearbd","tag-base-de-datos-sql-server","tag-create-database","nodate","item-wrap"],"_links":{"self":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/88","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=88"}],"version-history":[{"count":1,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/88\/revisions"}],"predecessor-version":[{"id":1264,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/88\/revisions\/1264"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/media\/1263"}],"wp:attachment":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=88"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=88"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=88"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}