{"id":538,"date":"2017-09-18T20:40:51","date_gmt":"2017-09-18T20:40:51","guid":{"rendered":"http:\/\/www.manualsqlserver.com\/?p=538"},"modified":"2020-05-20T17:22:45","modified_gmt":"2020-05-20T17:22:45","slug":"crear-modificar-y-adjuntar-base-de-datos","status":"publish","type":"post","link":"https:\/\/manualsqlserver.com\/?p=538","title":{"rendered":"Crear, Modificar y Adjuntar Base de datos"},"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_ServiciosSQLCreateDatabase-1.png\" alt=\"\" class=\"wp-image-1299\" width=\"328\" height=\"192\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Base de datos &#8211; ejercicios<\/strong><\/h2>\n\n\n\n<p>En este art\u00edculo presentamos varios ejercicios con bases de datos, c\u00f3mo crear bases de datos, modificar y adjuntar una base de datos previamente separada.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p><strong>&nbsp;1. Crear una BD llamada Logistica<\/strong><\/p>\n\n\n\n<p>Create DataBase Logistica<br>go<\/p>\n\n\n\n<p>&#8212; Importante: La instrucci\u00f3n anterior crea la BD &nbsp;en la misma carpeta donde se encuentran las BD del Sistema<\/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<p><strong>&nbsp;2. Crear BD Costos ubicada en D:\\Seminario, con dos archivos Costos.mdf y Costos.ldf<\/strong><\/p>\n\n\n\n<p>create database costos<br>on primary<br>(Name= &#8216;Costos01&#8242;, Filename=&#8217;D:\\Seminario\\Costos.mdf&#8217;,<br>Size= 4Mb, MaxSize= 30MB, FileGrowth=10%)<br>log on<br>(Name=&#8217;Costos02ldf&#8217;, Filename=&#8217;D:\\Seminario\\Costos.ldf&#8217;,<br>Size= 4Mb, MaxSize= 30MB, FileGrowth=10%)<br>go<\/p>\n\n\n\n<p><strong>&nbsp;3. Crear BD llamada Sistemas con 4 archivos<\/strong><\/p>\n\n\n\n<p>xp_create_subdir &#8216;D:\\Respaldo&#8217;<br>go<br>Create DataBase Sistemas<br>on<br>(Name=&#8217;SistemasData01&#8242;, Filename=&#8217;D:\\Respaldo\\SistemasD01.mdf&#8217;,<br>Size= 40Mb, MaxSize= 30GB, FileGrowth=50%),<br>(Name=&#8217;SistemasData02&#8242;, Filename=&#8217;D:\\Respaldo\\SistemasD02.ndf&#8217;,<br>Size= 40Mb, MaxSize= 30GB, FileGrowth=20%)<br>log on<br>(Name=&#8217;SistemasLog01&#8242;, Filename=&#8217;D:\\Respaldo\\SistemasL01.ldf&#8217;,<br>Size= 40Mb, MaxSize= 30GB, FileGrowth=30%),<br>(Name=&#8217;SistemasLog02&#8242;, Filename=&#8217;D:\\Respaldo\\SistemasL02.ldf&#8217;,<br>Size= 40Mb, MaxSize= 30GB, FileGrowth=60%)<br>go<\/p>\n\n\n\n<p><strong>&nbsp;4. Crear una BD llamada Empresa con 2 archivos en Primary, dos archivos en el Filegroup Seguridad y dos en &nbsp;Recursos ademas de dos archivos Log.<\/strong><\/p>\n\n\n\n<p>Create DataBase Empresa<br>on Primary<br>(Name= &#8216;EmpresaData01&#8242;, FileName=&#8217;F:\\SeminarioB\\EmpresaData01.mdf&#8217;),<br>(Name= &#8216;EmpresaData02&#8242;, FileName=&#8217;F:\\SeminarioB\\EmpresaData02.ndf&#8217;),<br>Filegroup Seguridad<br>(Name= &#8216;EmpresaData03&#8242;, FileName=&#8217;F:\\SeminarioB\\EmpresaData03.ndf&#8217;),<br>(Name= &#8216;EmpresaData04&#8242;, FileName=&#8217;F:\\SeminarioB\\EmpresaData04.ndf&#8217;),<br>Filegroup Recursos<br>(Name= &#8216;EmpresaData05&#8242;, FileName=&#8217;F:\\SeminarioB\\EmpresaData05.ndf&#8217;),<br>(Name= &#8216;EmpresaData06&#8242;, FileName=&#8217;F:\\SeminarioB\\EmpresaData06.ndf&#8217;)<br>Log on<br>(Name= &#8216;EmpresaLog01&#8242;, FileName=&#8217;F:\\SeminarioB\\EmpresaLog01.ldf&#8217;),<br>(Name= &#8216;EmpresaLog02&#8242;, FileName=&#8217;F:\\SeminarioB\\EmpresaLog02.ldf&#8217;)<br>go<\/p>\n\n\n\n<p><strong>&nbsp;5. Crear una base de datos Vientos en base al archivo NORTHWND.MDF<\/strong><\/p>\n\n\n\n<p>Create DataBase Vientos on<br>(Filename= &#8216;F:\\ParaAdjuntar\\NORTHWND.MDF&#8217;)<br><strong>for attach<\/strong><br>go<\/p>\n\n\n\n<p>&nbsp;<strong>6. Crear BD Libreria con Pubs.mdf que se encuentra en D:\\ParaAdjuntar\\<\/strong><\/p>\n\n\n\n<p>Create DataBase Libreria\u00a0on<br>(FileName= &#8216;D:\\ParaAdjuntar\\Pubs.mdf&#8217;)<br><strong>for attach<\/strong><br>go<\/p>\n\n\n\n<p><strong>&nbsp;7. Crear BD Aventura con AdventureWorks_Data.mdf que se encuentra en D:\\ParaAdjuntar\\<\/strong><\/p>\n\n\n\n<p>Create DataBase Aventura\u00a0on<br>(FileName= &#8216;F:\\ParaAdjuntar\\AdventureWorks_Data.mdf&#8217;)<br><strong>for attach<\/strong><br>go<\/p>\n\n\n\n<p><strong>&nbsp;8. Crear una instantanea de la BD Costos<\/strong><\/p>\n\n\n\n<p>Create DataBase FotoCostos20110408_2053\u00a0on<br>(Name=&#8217;Costos01&#8242;, Filename =&#8217;F:\\SeminarioB\\CostosFoto.mdf&#8217;)<br><strong>As snapshot of Costos<\/strong><br>go<\/p>\n\n\n\n<p><strong>&nbsp;9. &nbsp;Crear una instantanea de BD Sistemas llamada SistemasFoto &nbsp;&nbsp;La BD sistemas tiene un mdf y un ndf<\/strong><\/p>\n\n\n\n<p>Create DataBase SistemasFoto<br>on<br>(Name=&#8217;SistemasData01&#8242;, Filename=&#8217;F:\\SeminarioB\\SistemasFoto01.mdf&#8217;),<br>(Name=&#8217;SistemasData02&#8242;, Filename=&#8217;F:\\SeminarioB\\SistemasFoto02.ndf&#8217;)<br>As snapshot of Sistemas<br>go<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>MODIFICACION DE UNA BASE DE DATOS<\/strong><br><strong> ALTER DATABASE&nbsp;<\/strong><\/h3>\n\n\n\n<p>Ver Modificaci\u00f3n de base de datos para <a href=\"http:\/\/www.manualsqlserver.com\/?p=103\">Grupos <\/a>y para <a href=\"http:\/\/www.manualsqlserver.com\/?p=106\">Archivos de base de datos<\/a><\/p>\n\n\n\n<p><strong>&nbsp;10. Cambiar el nombre l\u00f3gico de un archivo<\/strong><\/p>\n\n\n\n<p>ALTER DATABASE&nbsp;costos&nbsp; MODIFY FILE<br>(NAME=&#8217;Costos01&#8242;, NEWNAME=&#8217;CostosData01&#8242;)<br>GO<\/p>\n\n\n\n<p><strong>&nbsp;11. Agregar un Filegroup<\/strong><\/p>\n\n\n\n<p>ALTER DATABASE [costos] ADD FILEGROUP [NuevoGrupo]<br>GO<\/p>\n\n\n\n<p><strong>12. \u00a0Agregar un archivo secundario (ndf) llamado AgregadoCostos a BD Costos en el Filegroup creado<\/strong><\/p>\n\n\n\n<p>ALTER DATABASE costos&nbsp;ADD FILE ( NAME = &#8216;Agregado&#8217;,<br>FILENAME = &#8216;F:\\SeminarioB\\AgregadoCostos.ndf&#8217; ,<br>SIZE = 6144KB , FILEGROWTH = 2048KB )<br>TO FILEGROUP NuevoGrupo<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>Base de datos &#8211; ejercicios En este art\u00edculo presentamos varios ejercicios con bases de datos, c\u00f3mo crear bases de datos, modificar y adjuntar una base de datos previamente separada.<\/p><p><a class=\"more-link btn\" href=\"https:\/\/manualsqlserver.com\/?p=538\">Seguir leyendo<\/a><\/p>\n","protected":false},"author":1,"featured_media":1299,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,3],"tags":[98,15,101,111],"class_list":["post-538","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-crearbd","category-instala","tag-alter-database","tag-create-database","tag-filegroup","tag-grupos-de-archivos","nodate","item-wrap"],"_links":{"self":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/538","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=538"}],"version-history":[{"count":1,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/538\/revisions"}],"predecessor-version":[{"id":1301,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/538\/revisions\/1301"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/media\/1299"}],"wp:attachment":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=538"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=538"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=538"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}