{"id":96,"date":"2017-09-18T21:15:14","date_gmt":"2017-09-18T21:15:14","guid":{"rendered":"http:\/\/www.manualsqlserver.com\/?p=96"},"modified":"2020-05-20T04:22:31","modified_gmt":"2020-05-20T04:22:31","slug":"create-database-instantaneas","status":"publish","type":"post","link":"https:\/\/manualsqlserver.com\/?p=96","title":{"rendered":"Create Database &#8211; Instant\u00e1neas de base de datos SQL Server"},"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_ServiciosSQLInstantanea.png\" alt=\"\" class=\"wp-image-1281\" width=\"203\" height=\"203\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_ServiciosSQLInstantanea.png 300w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/05\/ManualSQL_ServiciosSQLInstantanea-150x150.png 150w\" sizes=\"auto, (max-width: 203px) 100vw, 203px\" \/><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\"><strong>Instant\u00e1neas de base de datos<\/strong><\/h1>\n\n\n\n<p>Una instant\u00e1nea de base de datos en SQL Server es una vista est\u00e1tica de s\u00f3lo lectura de una base de datos denominada <em>base de datos de origen<\/em>. Las\u00a0instant\u00e1neas de base de datos siempre reside en la misma instancia de servidor que la base de datos de origen.\u00a0Pueden existir varias instant\u00e1neas de una base de datos.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p><strong>Ventajas de las instant\u00e1neas<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Se pueden usar para informes.<\/li><li>Contienen datos hist\u00f3ricos para informes.<\/li><li>Regresar a un determinado punto la base de datos para corregir errores administrativos.<\/li><li>Se pueden usar para efectos de auditoria, dar acceso al contenido de la base de datos en un momento determinado pero en modo s\u00f3lo lectura.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Ejercicios<\/h3>\n\n\n\n<p>Para que los ejercicio funcionen, primero crear las bases de datos de acuerdo a los ejercicios de <a href=\"http:\/\/www.manualsqlserver.com\/?p=91\">adjuntar una base de datos.<\/a><\/p>\n\n\n\n<p><strong>1.- &nbsp;Para crear una instant\u00e1nea de Aventura (Base de datos AdventureWorks ubicada en C:\\Sistemas)<\/strong><\/p>\n\n\n\n<p>Create Database AventuraFinalEjercicio<br>on primary<br>(Name=&#8217;AdventureWorks_Data&#8217;, FileName=&#8217;C:\\Sistemas\\AdventureFoto.ss&#8217;)<br>as snapshot of Aventura<br>go<\/p>\n\n\n\n<p><strong>2.- Usando Northwind, crear una instant\u00e1nea. Se crear\u00e1 VientosFoto en la carpeta Respaldo de la unidad C:<\/strong><\/p>\n\n\n\n<p>use Northwind<br>go<br>xp_create_subdir &#8216;C:\\Respaldo&#8217;<br>go<br>Create database VientosFoto<br>on (name=&#8217;Northwind&#8217;,<br>Filename=&#8217;C:\\Respaldo\\Viento01.mdf&#8217;)<br>as snapshot of Northwind<br>go<\/p>\n\n\n\n<p>Note que en ambos ejercicios se ha utilizado la cl\u00e1usula <strong>As snapshot of<\/strong><\/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>&nbsp;<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=\"5919795031\"><\/ins><br><script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Instant\u00e1neas de base de datos Una instant\u00e1nea de base de datos en SQL Server es una vista est\u00e1tica de s\u00f3lo lectura de una base de datos denominada base de datos de origen. Las\u00a0instant\u00e1neas de base de datos siempre reside en la misma instancia de servidor que la base de datos de origen.\u00a0Pueden existir varias instant\u00e1neas &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/manualsqlserver.com\/?p=96\">Seguir leyendo<\/a><\/p>\n","protected":false},"author":1,"featured_media":1281,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[53],"class_list":["post-96","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-crearbd","tag-sqlserver","nodate","item-wrap"],"_links":{"self":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/96","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=96"}],"version-history":[{"count":1,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/96\/revisions"}],"predecessor-version":[{"id":1283,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/96\/revisions\/1283"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/media\/1281"}],"wp:attachment":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=96"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=96"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=96"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}