{"id":42,"date":"2014-01-02T21:35:32","date_gmt":"2014-01-02T13:35:32","guid":{"rendered":"http:\/\/suherman.asia\/w2\/?p=42"},"modified":"2014-01-02T21:35:32","modified_gmt":"2014-01-02T13:35:32","slug":"introduction-to-database-snapshot-2","status":"publish","type":"post","link":"https:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html","title":{"rendered":"Introduction to Database Snapshot (2)"},"content":{"rendered":"

Bagian 1<\/a>.<\/p>\n

Setelah kita mencoba bagaimana membuat sebuah database Snapshot disini<\/a>, selanjutnya kita akan mencoba untuk melihat apa yang terjadi apabila di database source terjadi aktivitas transaksi.<\/p>\n

pertama kita coba ambil sample misalkan table Production.Product<\/p>\n

\n
\n
SELECT<\/span> ProductID,Name FROM<\/span> AdventureWorks.Production.Product<\/pre>\n
<\/p>\n
ORDER<\/span> BY<\/span> ProductID<\/pre>\n
<\/p>\n
GO<\/span><\/pre>\n
<\/p>\n
SELECT<\/span> ProductID,Name FROM<\/span> Snapshot_AW.Production.Product<\/pre>\n
<\/p>\n
ORDER<\/span> BY<\/span> ProductID<\/pre>\n
<\/p>\n
GO<\/pre>\n
<\/div>\n<\/div>\n
dan hasilnya adalah sebagai berikut :<\/p>\n
\"image\"<\/a><\/p>\n
Nah sekarang saya akan coba mengupdate tabel Adventureworks.Production.Product<\/p>\n
\n
\n
update<\/span> AdventureWorks.Production.Product set<\/span> Name='Crankam'<\/span><\/pre>\n
<\/p>\n
where<\/span> ProductID=2<\/pre>\n
<\/div>\n<\/div>\n
Lalu setelah itu kembali lihat kondisi 2 tabel tersebut :<\/p>\n
\n
\n
SELECT<\/span> ProductID,Name FROM<\/span> AdventureWorks.Production.Product<\/pre>\n
<\/p>\n
ORDER<\/span> BY<\/span> ProductID<\/pre>\n
<\/p>\n
GO<\/span><\/pre>\n
<\/p>\n
 <\/pre>\n
<\/p>\n
SELECT<\/span> ProductID,Name FROM<\/span> Snapshot_AW.Production.Product<\/pre>\n
<\/p>\n
ORDER<\/span> BY<\/span> ProductID<\/pre>\n
<\/p>\n
GO<\/pre>\n
<\/div>\n<\/div>\n
Tampak bahwa tidak ada perubahan pada tabel Snapshot_AW.Production.Product<\/p>\n
\"image\"<\/a><\/p>\n
Namun bila diperhatikan pada file C:\\SS_AW.ss1 Size on Disk nya bertambah dari 128 Kb menjadi 960 Kb.<\/p>\n
\"image\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Bagian 1. Setelah kita mencoba bagaimana membuat sebuah database Snapshot disini, selanjutnya kita akan mencoba untuk melihat apa yang terjadi apabila di database source terjadi aktivitas transaksi. pertama kita coba ambil sample misalkan table Production.Product SELECT ProductID,Name FROM AdventureWorks.Production.Product ORDER BY ProductID GO SELECT ProductID,Name FROM Snapshot_AW.Production.Product ORDER BY ProductID \u2026<\/p>\n
 Continue reading<\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[16],"class_list":["post-42","post","type-post","status-publish","format-standard","hentry","category-sql-server","tag-database-snapshot"],"yoast_head":"\nIntroduction to Database Snapshot (2) - Suherman Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Introduction to Database Snapshot (2) - Suherman Blog\" \/>\n<meta property=\"og:description\" content=\"Bagian 1. Setelah kita mencoba bagaimana membuat sebuah database Snapshot disini, selanjutnya kita akan mencoba untuk melihat apa yang terjadi apabila di database source terjadi aktivitas transaksi. pertama kita coba ambil sample misalkan table Production.Product SELECT ProductID,Name FROM AdventureWorks.Production.Product ORDER BY ProductID GO SELECT ProductID,Name FROM Snapshot_AW.Production.Product ORDER BY ProductID \u2026 Continue reading\" \/>\n<meta property=\"og:url\" content=\"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html\" \/>\n<meta property=\"og:site_name\" content=\"Suherman Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/emantin34\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/emantin34\" \/>\n<meta property=\"article:published_time\" content=\"2014-01-02T13:35:32+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/image_5F00_thumb_5F00_02646353.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html#article\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html\"},\"author\":{\"name\":\"admin\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"headline\":\"Introduction to Database Snapshot (2)\",\"datePublished\":\"2014-01-02T13:35:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html\"},\"wordCount\":91,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"image\":{\"@id\":\"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html#primaryimage\"},\"thumbnailUrl\":\"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/image_5F00_thumb_5F00_02646353.png\",\"keywords\":[\"Database Snapshot\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html\",\"url\":\"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html\",\"name\":\"Introduction to Database Snapshot (2) - Suherman Blog\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html#primaryimage\"},\"image\":{\"@id\":\"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html#primaryimage\"},\"thumbnailUrl\":\"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/image_5F00_thumb_5F00_02646353.png\",\"datePublished\":\"2014-01-02T13:35:32+00:00\",\"breadcrumb\":{\"@id\":\"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html#primaryimage\",\"url\":\"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/image_5F00_thumb_5F00_02646353.png\",\"contentUrl\":\"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/image_5F00_thumb_5F00_02646353.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/suherman.asia\/w2\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Introduction to Database Snapshot (2)\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/suherman.asia\/w2\/#website\",\"url\":\"http:\/\/suherman.asia\/w2\/\",\"name\":\"Suherman Blog\",\"description\":\"Just Another Geek Site\",\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/suherman.asia\/w2\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g\",\"caption\":\"admin\"},\"logo\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/\"},\"sameAs\":[\"http:\/\/suherman.asia\",\"https:\/\/www.facebook.com\/emantin34\",\"https:\/\/x.com\/emantin34\"],\"url\":\"https:\/\/suherman.asia\/w2\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Introduction to Database Snapshot (2) - Suherman Blog","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":"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html","og_locale":"en_US","og_type":"article","og_title":"Introduction to Database Snapshot (2) - Suherman Blog","og_description":"Bagian 1. Setelah kita mencoba bagaimana membuat sebuah database Snapshot disini, selanjutnya kita akan mencoba untuk melihat apa yang terjadi apabila di database source terjadi aktivitas transaksi. pertama kita coba ambil sample misalkan table Production.Product SELECT ProductID,Name FROM AdventureWorks.Production.Product ORDER BY ProductID GO SELECT ProductID,Name FROM Snapshot_AW.Production.Product ORDER BY ProductID \u2026 Continue reading","og_url":"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html","og_site_name":"Suherman Blog","article_publisher":"https:\/\/www.facebook.com\/emantin34","article_author":"https:\/\/www.facebook.com\/emantin34","article_published_time":"2014-01-02T13:35:32+00:00","og_image":[{"url":"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/image_5F00_thumb_5F00_02646353.png","type":"","width":"","height":""}],"author":"admin","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html#article","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html"},"author":{"name":"admin","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"headline":"Introduction to Database Snapshot (2)","datePublished":"2014-01-02T13:35:32+00:00","mainEntityOfPage":{"@id":"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html"},"wordCount":91,"commentCount":0,"publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"image":{"@id":"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html#primaryimage"},"thumbnailUrl":"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/image_5F00_thumb_5F00_02646353.png","keywords":["Database Snapshot"],"articleSection":["SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html#respond"]}]},{"@type":"WebPage","@id":"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html","url":"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html","name":"Introduction to Database Snapshot (2) - Suherman Blog","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/#website"},"primaryImageOfPage":{"@id":"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html#primaryimage"},"image":{"@id":"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html#primaryimage"},"thumbnailUrl":"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/image_5F00_thumb_5F00_02646353.png","datePublished":"2014-01-02T13:35:32+00:00","breadcrumb":{"@id":"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html#primaryimage","url":"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/image_5F00_thumb_5F00_02646353.png","contentUrl":"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/image_5F00_thumb_5F00_02646353.png"},{"@type":"BreadcrumbList","@id":"http:\/\/suherman.asia\/w2\/introduction-to-database-snapshot-2.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/suherman.asia\/w2"},{"@type":"ListItem","position":2,"name":"Introduction to Database Snapshot (2)"}]},{"@type":"WebSite","@id":"http:\/\/suherman.asia\/w2\/#website","url":"http:\/\/suherman.asia\/w2\/","name":"Suherman Blog","description":"Just Another Geek Site","publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/suherman.asia\/w2\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g","caption":"admin"},"logo":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/"},"sameAs":["http:\/\/suherman.asia","https:\/\/www.facebook.com\/emantin34","https:\/\/x.com\/emantin34"],"url":"https:\/\/suherman.asia\/w2\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/42","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/comments?post=42"}],"version-history":[{"count":1,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/42\/revisions"}],"predecessor-version":[{"id":43,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/42\/revisions\/43"}],"wp:attachment":[{"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/media?parent=42"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/categories?post=42"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/tags?post=42"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}