{"id":3258,"date":"2022-04-18T09:54:56","date_gmt":"2022-04-18T02:54:56","guid":{"rendered":"https:\/\/www.sqlservertutorial.net\/?page_id=3258"},"modified":"2022-04-18T09:58:38","modified_gmt":"2022-04-18T02:58:38","slug":"sql-server-database-snapshot","status":"publish","type":"page","link":"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-database-snapshot\/","title":{"rendered":"SQL Server Database Snapshot"},"content":{"rendered":"\n<p><strong>Summary<\/strong>: in this tutorial, you&#8217;ll learn about SQL Server database snapshots and how to create a database snapshot using T-SQL.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id='introduction-to-the-sql-server-database-snapshot'>Introduction to the SQL Server Database Snapshot <a href=\"#introduction-to-the-sql-server-database-snapshot\" class=\"anchor\" id=\"introduction-to-the-sql-server-database-snapshot\" title=\"Anchor for Introduction to the SQL Server Database Snapshot\">#<\/a><\/h2>\n\n\n\n<p>A database snapshot is a read-only, static view of a database in an SQL Server instance. The database from which you create a snapshot is called a source database.<\/p>\n\n\n\n<p>The database snapshot captures the state of the source database at the moment of the snapshot&#8217;s creation.<\/p>\n\n\n\n<p>When you create a snapshot of a source database, the snapshot is empty:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"548\" height=\"334\" src=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/SQL-Server-Database-snapshot-creation-time.png\" alt=\"\" class=\"wp-image-3261\" srcset=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/SQL-Server-Database-snapshot-creation-time.png 548w, https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/SQL-Server-Database-snapshot-creation-time-300x183.png 300w\" sizes=\"auto, (max-width: 548px) 100vw, 548px\" \/><\/figure>\n\n\n\n<p>However, when you modify the source database, SQL Server copies the changes to the snapshot.  In other words, the size of the snapshot grows as you make changes to the source database:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"537\" height=\"318\" src=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/SQL-Server-Database-snapshot-modification-of-the-source-database.png\" alt=\"\" class=\"wp-image-3262\" srcset=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/SQL-Server-Database-snapshot-modification-of-the-source-database.png 537w, https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/SQL-Server-Database-snapshot-modification-of-the-source-database-300x178.png 300w\" sizes=\"auto, (max-width: 537px) 100vw, 537px\" \/><\/figure>\n\n\n\n<p>A database can have multiple snapshots that persist until you explicitly drop them.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id='sql-server-database-snapshot-features'>SQL Server database snapshot features <a href=\"#sql-server-database-snapshot-features\" class=\"anchor\" id=\"sql-server-database-snapshot-features\" title=\"Anchor for SQL Server database snapshot features\">#<\/a><\/h2>\n\n\n\n<p>Here&#8217;s are the database snapshot features:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Database snapshots are dependent on the source databases. If the source databases are corrupted, the snapshots will be inaccessible. <\/li><li>Database snapshots reside on the same SQL Server instance as the source database.<\/li><li>Database snapshots operate at the data-page level. Before you make a change to a page of a source database, SQL Server copies it from the source database to the snapshot. As the result, the snapshot preserves the records of the source database as they existed when the snapshot was created.<\/li><\/ul>\n\n\n\n<p>It&#8217;s important to note that database snapshots cannot help protect against disk errors or other types of corruption. In other words, snapshots are not substitutes for <a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-backup-types\/\">backups<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id='creating-a-database-snapshot'>Creating a database snapshot <a href=\"#creating-a-database-snapshot\" class=\"anchor\" id=\"creating-a-database-snapshot\" title=\"Anchor for Creating a database snapshot\">#<\/a><\/h2>\n\n\n\n<p>Let&#8217;s take a look at an example of creating a database snapshot.<\/p>\n\n\n\n<p>First, <a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-basics\/sql-server-create-database\/\">create a new database<\/a> called <code>HR<\/code> with one table <code>Employees<\/code>:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">DATABASE<\/span> HR;\nGO\n\n<span class=\"hljs-keyword\">USE<\/span> HR;\n\n<span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">TABLE<\/span> Employees (\n  <span class=\"hljs-keyword\">Id<\/span> <span class=\"hljs-built_in\">int<\/span> <span class=\"hljs-keyword\">IDENTITY<\/span> PRIMARY <span class=\"hljs-keyword\">KEY<\/span>,\n  FirstName <span class=\"hljs-built_in\">varchar<\/span>(<span class=\"hljs-number\">50<\/span>) <span class=\"hljs-keyword\">NOT<\/span> <span class=\"hljs-literal\">NULL<\/span>,\n  LastName <span class=\"hljs-built_in\">varchar<\/span>(<span class=\"hljs-number\">50<\/span>) <span class=\"hljs-keyword\">NOT<\/span> <span class=\"hljs-literal\">NULL<\/span>\n);\n\n<span class=\"hljs-keyword\">INSERT<\/span> <span class=\"hljs-keyword\">INTO<\/span> Employees (FirstName, LastName)\n  <span class=\"hljs-keyword\">VALUES<\/span> (<span class=\"hljs-string\">'John'<\/span>, <span class=\"hljs-string\">'Doe'<\/span>),\n  (<span class=\"hljs-string\">'Jane'<\/span>, <span class=\"hljs-string\">'Doe'<\/span>);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Second, use the <code>CREATE DATABASE ... AS SNAPSHOT<\/code> to create a snapshot of the <code>HR<\/code> database:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">DATABASE<\/span> HR_Snapshots \n<span class=\"hljs-keyword\">ON<\/span> ( <span class=\"hljs-keyword\">NAME<\/span> = HR, FILENAME = <span class=\"hljs-string\">'D:\\snapshots\\hr.ss'<\/span>)  \n<span class=\"hljs-keyword\">AS<\/span> <span class=\"hljs-keyword\">SNAPSHOT<\/span> <span class=\"hljs-keyword\">OF<\/span> HR; <\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p class=\"note\">Note that the <code>D:\\snapshots<\/code> folder must exist so that the above command can execute successfully.<\/p>\n\n\n\n<p>To view the database snapshot on SSMS, you expand the <strong>Databases &gt; Database Snapshots: <\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"398\" height=\"119\" src=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/SQL-Server-Database-snapshot.png\" alt=\"\" class=\"wp-image-3263\" srcset=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/SQL-Server-Database-snapshot.png 398w, https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/SQL-Server-Database-snapshot-300x90.png 300w\" sizes=\"auto, (max-width: 398px) 100vw, 398px\" \/><\/figure>\n\n\n\n<p>Third, <a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-basics\/sql-server-delete\/\">delete a row<\/a> with id 1 from the <code>Employees<\/code> table of the HR database:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DELETE<\/span> <span class=\"hljs-keyword\">FROM<\/span> Employees \n<span class=\"hljs-keyword\">WHERE<\/span> <span class=\"hljs-keyword\">Id<\/span> = <span class=\"hljs-number\">1<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Fourth, <a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-basics\/sql-server-select\/\">query data<\/a> from the <code>Employees<\/code> table:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> * <span class=\"hljs-keyword\">FROM<\/span> Employees;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Output:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"222\" height=\"47\" src=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/SQL-Server-Database-snapshot-querying-data-from-the-source-database.png\" alt=\"\" class=\"wp-image-3265\"\/><\/figure>\n\n\n\n<p>Fifth, query data from the <code>Employees<\/code> of the <code>HR_Snapshots<\/code> database:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">USE<\/span> HR_Snapshots;\n\n<span class=\"hljs-keyword\">SELECT<\/span> * <span class=\"hljs-keyword\">FROM<\/span> Employees;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Output:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"222\" height=\"72\" src=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/SQL-Server-Database-snapshot-querying.png\" alt=\"\" class=\"wp-image-3264\"\/><\/figure>\n\n\n\n<p>The output shows the data of the Employees table at the time we created the snapshot of the HR database.<\/p>\n\n\n\n<p>Sixth, restore the <code>HR<\/code> database from the <code>HR_Snapshots<\/code> database:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-6\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">USE<\/span> <span class=\"hljs-keyword\">master<\/span>;\n\n<span class=\"hljs-keyword\">RESTORE<\/span> <span class=\"hljs-keyword\">DATABASE<\/span> HR\n<span class=\"hljs-keyword\">FROM<\/span> DATABASE_SNAPSHOT=<span class=\"hljs-string\">'HR_Snapshots'<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Seventh, query data from the <code>Employees<\/code> table of the <code>HR<\/code> database:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-7\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">USE<\/span> HR;\n\n<span class=\"hljs-keyword\">SELECT<\/span> * <span class=\"hljs-keyword\">FROM<\/span> Employees;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-7\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Output:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"222\" height=\"72\" src=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/SQL-Server-Database-snapshot-querying.png\" alt=\"\" class=\"wp-image-3264\"\/><\/figure>\n\n\n\n<p>The output shows that the table has been recovered from the snapshot.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id='why-database-snapshots'>Why Database Snapshots <a href=\"#why-database-snapshots\" class=\"anchor\" id=\"why-database-snapshots\" title=\"Anchor for Why Database Snapshots\">#<\/a><\/h2>\n\n\n\n<p>Database snapshots can be useful for managing a test database. Before running a test, you can create a snapshot on the test database. After each test run, you can use the database snapshot to quickly revert the database to its original state. <\/p>\n\n\n\n<p>Database snapshots safeguard data against administrative error. Before doing a major update to the database, you can create a snapshot. If you make a mistake, you can use the snapshot to recover the database by reverting the database to the snapshot. Reverting may be much faster than restoring from a backup.<\/p>\n\n\n\n<p>Database snapshots can be used for reporting purposes. For example, you can create a snapshot of a database at month-end, and keep updating the source database with the new transactions. Since the snapshot stores the data at the time you created the snapshot, you can create the month-end reports by querying the snapshot.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id='summary'>Summary <a href=\"#summary\" class=\"anchor\" id=\"summary\" title=\"Anchor for Summary\">#<\/a><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>A database snapshot is a read-only, static view of a database.<\/li><li>Use the <code>CREATE DATABASE ... AS SNAPSHOT<\/code> statement to create a database snapshot.<\/li><li>Use the <code>RESTORE DATABASE ... FROM DATABASE_SNAPSHOT<\/code> to restore a database from a snapshot.<\/li><\/ul>\n<div class=\"helpful-block-content\" data-title=\"\">\n\t<header>\n\t\t<div class=\"wth-question\">Was this tutorial helpful?<\/div>\n\t\t<div class=\"wth-thumbs\">\n\t\t\t<button\n\t\t\t\tdata-post=\"3258\"\n\t\t\t\tdata-post-url=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-database-snapshot\/\"\n\t\t\t\tdata-post-title=\"SQL Server Database Snapshot\"\n\t\t\t\tdata-response=\"1\"\n\t\t\t\tclass=\"wth-btn-rounded wth-yes-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t\tclass=\"feather feather-thumbs-up block w-full h-full\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M14 9V5a3 3 0 0 0-3-3l-4 9v11h11.28a2 2 0 0 0 2-1.7l1.38-9a2 2 0 0 0-2-2.3zM7 22H4a2 2 0 0 1-2-2v-7a2 2 0 0 1 2-2h3\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t<button\n\t\t\t\tdata-response=\"0\"\n\t\t\t\tdata-post=\"3258\"\n\t\t\t\tdata-post-url=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-database-snapshot\/\"\n\t\t\t\tdata-post-title=\"SQL Server Database Snapshot\"\n\t\t\t\tclass=\"wth-btn-rounded wth-no-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M10 15v4a3 3 0 0 0 3 3l4-9V2H5.72a2 2 0 0 0-2 1.7l-1.38 9a2 2 0 0 0 2 2.3zm7-13h2.67A2.31 2.31 0 0 1 22 4v7a2.31 2.31 0 0 1-2.33 2H17\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t<div class=\"wth-form hidden\">\n\t\t<div class=\"wth-form-wrapper\">\n\t\t\t<div class=\"wth-title\"><\/div>\n\t\t\t\n\t\t\t<textarea class=\"wth-message\"><\/textarea>\n\n\t\t\t<button class=\"btn btn-primary wth-btn-submit\">Send<\/button>\n\t\t\t<button class=\"btn wth-btn-cancel\">Cancel<\/button>\n\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Summary: in this tutorial, you&#8217;ll learn about SQL Server database snapshots and how to create a database snapshot using T-SQL. Introduction to the SQL Server Database Snapshot # A database snapshot is a read-only, static view of a database in an SQL Server instance. The database from which you create a snapshot is called a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":2903,"menu_order":23,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-3258","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server Database Snapshot<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-database-snapshot\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Database Snapshot\" \/>\n<meta property=\"og:description\" content=\"Summary: in this tutorial, you&#8217;ll learn about SQL Server database snapshots and how to create a database snapshot using T-SQL. Introduction to the SQL Server Database Snapshot # A database snapshot is a read-only, static view of a database in an SQL Server instance. The database from which you create a snapshot is called a [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-database-snapshot\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Server Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-18T02:58:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/SQL-Server-Database-snapshot-creation-time.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/sql-server-administration\\\/sql-server-database-snapshot\\\/\",\"url\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/sql-server-administration\\\/sql-server-database-snapshot\\\/\",\"name\":\"SQL Server Database Snapshot\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/sql-server-administration\\\/sql-server-database-snapshot\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/sql-server-administration\\\/sql-server-database-snapshot\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/wp-content\\\/uploads\\\/SQL-Server-Database-snapshot-creation-time.png\",\"datePublished\":\"2022-04-18T02:54:56+00:00\",\"dateModified\":\"2022-04-18T02:58:38+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/sql-server-administration\\\/sql-server-database-snapshot\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlservertutorial.net\\\/sql-server-administration\\\/sql-server-database-snapshot\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/sql-server-administration\\\/sql-server-database-snapshot\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/wp-content\\\/uploads\\\/SQL-Server-Database-snapshot-creation-time.png\",\"contentUrl\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/wp-content\\\/uploads\\\/SQL-Server-Database-snapshot-creation-time.png\",\"width\":548,\"height\":334},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/sql-server-administration\\\/sql-server-database-snapshot\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Administration\",\"item\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/sql-server-administration\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SQL Server Database Snapshot\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/#website\",\"url\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/\",\"name\":\"SQL Server Tutorial\",\"description\":\"The Practical SQL Server Tutorial\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server Database Snapshot","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-database-snapshot\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Database Snapshot","og_description":"Summary: in this tutorial, you&#8217;ll learn about SQL Server database snapshots and how to create a database snapshot using T-SQL. Introduction to the SQL Server Database Snapshot # A database snapshot is a read-only, static view of a database in an SQL Server instance. The database from which you create a snapshot is called a [&hellip;]","og_url":"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-database-snapshot\/","og_site_name":"SQL Server Tutorial","article_modified_time":"2022-04-18T02:58:38+00:00","og_image":[{"url":"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/SQL-Server-Database-snapshot-creation-time.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-database-snapshot\/","url":"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-database-snapshot\/","name":"SQL Server Database Snapshot","isPartOf":{"@id":"https:\/\/www.sqlservertutorial.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-database-snapshot\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-database-snapshot\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/SQL-Server-Database-snapshot-creation-time.png","datePublished":"2022-04-18T02:54:56+00:00","dateModified":"2022-04-18T02:58:38+00:00","breadcrumb":{"@id":"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-database-snapshot\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-database-snapshot\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-database-snapshot\/#primaryimage","url":"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/SQL-Server-Database-snapshot-creation-time.png","contentUrl":"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/SQL-Server-Database-snapshot-creation-time.png","width":548,"height":334},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-database-snapshot\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlservertutorial.net\/"},{"@type":"ListItem","position":2,"name":"SQL Server Administration","item":"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/"},{"@type":"ListItem","position":3,"name":"SQL Server Database Snapshot"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlservertutorial.net\/#website","url":"https:\/\/www.sqlservertutorial.net\/","name":"SQL Server Tutorial","description":"The Practical SQL Server Tutorial","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlservertutorial.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages\/3258","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/comments?post=3258"}],"version-history":[{"count":5,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages\/3258\/revisions"}],"predecessor-version":[{"id":3268,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages\/3258\/revisions\/3268"}],"up":[{"embeddable":true,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages\/2903"}],"wp:attachment":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/media?parent=3258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}