{"id":1199,"date":"2025-10-10T08:00:00","date_gmt":"2025-10-10T13:00:00","guid":{"rendered":"https:\/\/www.sqltabletalk.com\/?p=1199"},"modified":"2025-10-09T22:49:45","modified_gmt":"2025-10-10T03:49:45","slug":"sql-server-2022-auto-seeding-vs-manual-seeding","status":"publish","type":"post","link":"https:\/\/www.sqltabletalk.com\/?p=1199","title":{"rendered":"Auto Seeding vs. Manual Seeding for AG Secondary Replicas in SQL Server"},"content":{"rendered":"<h3>Introduction<\/h3>\n<p>When you add a database to an Always On availability group (AG), the first goal is to place a transactionally consistent copy on each secondary replica so data movement can begin. SQL Server 2022 supports two methods for this: <strong>automatic seeding<\/strong> and <strong>manual seeding<\/strong>. This post explains what technically happens in each case, why automatic seeding is convenient, and why it may not be ideal for very large databases (VLDBs).<\/p>\n<h3>How Automatic Seeding Works<\/h3>\n<p>With automatic seeding, SQL Server performs a streaming backup and restore over the AG\u2019s database mirroring endpoints. The primary replica takes a virtual device interface (VDI) backup of the database and streams it directly to the secondary, where it is restored automatically. This eliminates the need to create and manage backup files.<\/p>\n<p>To allow the AG to create the database on the secondary, you must grant it permission:<\/p>\n<pre><code>ALTER AVAILABILITY GROUP [AGName] GRANT CREATE ANY DATABASE;<\/code><\/pre>\n<p>You then enable automatic seeding by setting the seeding mode:<\/p>\n<pre><code>ALTER AVAILABILITY GROUP [AGName]\n  MODIFY REPLICA ON 'SecondaryServer'\n  WITH (SEEDING_MODE = AUTOMATIC);<\/code><\/pre>\n<p>During automatic seeding, the following occurs:<\/p>\n<ul>\n<li>The database backup is streamed through the AG endpoint.<\/li>\n<li>The transaction log on the primary cannot be truncated until seeding finishes.<\/li>\n<li>The process runs single-threaded, limiting throughput when seeding multiple databases.<\/li>\n<li>Compression is optional and enabled via <strong>trace flag 9567<\/strong>, reducing bandwidth use but increasing CPU load.<\/li>\n<li>File paths are taken from the replica\u2019s defaults; they do not need to match across replicas, but they must exist.<\/li>\n<\/ul>\n<p>Progress can be monitored using the DMVs <code>sys.dm_hadr_automatic_seeding<\/code> and <code>sys.dm_hadr_physical_seeding_stats<\/code>.<\/p>\n<h3>How Manual Seeding Works<\/h3>\n<p>Manual seeding follows the traditional backup and restore workflow:<\/p>\n<ol>\n<li>Take a <strong>full<\/strong> and <strong>log<\/strong> backup of the primary database.<\/li>\n<li>Copy the backups to each secondary.<\/li>\n<li>Restore them using <code>WITH NORECOVERY<\/code>, optionally specifying <code>WITH MOVE<\/code> if file paths differ.<\/li>\n<li>Join the database to the AG using SSMS or T-SQL to begin synchronization.<\/li>\n<\/ol>\n<p>Manual seeding can also be performed using the <strong>Add Database<\/strong> wizard:<\/p>\n<ul>\n<li><strong>Full<\/strong>: SQL Server performs the backup, copy, and restore automatically via a shared network path.<\/li>\n<li><strong>Join only<\/strong>: You prepare the database manually and simply attach it to the AG.<\/li>\n<\/ul>\n<p>Manual seeding allows:<\/p>\n<ul>\n<li>Use of <strong>backup compression<\/strong>, which typically reduces backup size and I\/O at the cost of CPU.<\/li>\n<li>Precise control over file layout and placement.<\/li>\n<li>Scheduling of backups and restores during maintenance windows to minimize impact.<\/li>\n<\/ul>\n<h3>Why Automatic Seeding Is Convenient<\/h3>\n<p>Automatic seeding removes the operational complexity of managing backups and restores. It requires minimal setup, works for both new and existing AGs, and can be combined with manual seeding if needed. It\u2019s ideal for small to medium databases on high-speed, reliable networks where the simplicity outweighs the performance trade-offs.<\/p>\n<h3>Why It\u2019s Not Ideal for Very Large Databases<\/h3>\n<p>Automatic seeding introduces performance and management limitations that become significant for VLDBs:<\/p>\n<ul>\n<li>The streaming process is limited by network throughput. A multi-terabyte database can take many hours over a 1 Gbps link.<\/li>\n<li>Transaction logs on the primary cannot truncate during seeding, leading to potential log growth.<\/li>\n<li>The single-threaded implementation restricts concurrency when seeding multiple databases.<\/li>\n<li>Compression requires <strong>trace flag 9567<\/strong>, which increases CPU usage on the primary.<\/li>\n<li>There is less control over file placement, which is important in large environments with multiple data files or custom storage layouts.<\/li>\n<\/ul>\n<p>Manual seeding avoids these problems by allowing you to use compressed backups, control timing, and carefully manage file placement.<\/p>\n<h3>Choosing the Right Method<\/h3>\n<p>Automatic seeding works best for smaller databases and straightforward configurations where convenience is the main goal. Manual seeding is the better choice for VLDBs, for environments with complex storage layouts, or when you need to control CPU, bandwidth, and timing. Some organizations use a hybrid approach\u2014pre-restoring a recent full backup manually, then letting automatic seeding catch up with the delta.<\/p>\n<h3>Conclusion<\/h3>\n<p>Both methods are supported in SQL Server 2022. Automatic seeding provides an elegant, low-maintenance option for routine deployments, while manual seeding remains essential for large or performance-sensitive databases. The choice depends on your operational needs, database size, and infrastructure.<\/p>\n<h3>Documentation References<\/h3>\n<ul>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/database-engine\/availability-groups\/windows\/automatic-seeding-secondary-replicas?view=sql-server-ver17\">Use automatic seeding to initialize a secondary replica<\/a><\/li>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/database-engine\/availability-groups\/windows\/manually-prepare-a-secondary-database-for-an-availability-group-sql-server?view=sql-server-ver17\">Manually prepare a secondary database for an availability group<\/a><\/li>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/database-engine\/availability-groups\/windows\/availability-group-add-a-database?view=sql-server-ver17\">Add a database to an availability group (Wizard)<\/a><\/li>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/database-engine\/availability-groups\/windows\/tune-compression-for-availability-group?view=sql-server-ver17\">Tune compression for availability groups (trace flag 9567)<\/a><\/li>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/backup-compression-sql-server?view=sql-server-ver17\">Backup compression (SQL Server)<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>This post explains the technical differences between automatic seeding and manual seeding for secondary replicas in SQL Server 2022 Always On availability groups. It describes how automatic seeding uses the AG transport layer to stream a virtual backup directly to the secondary, while manual seeding relies on traditional backup and restore operations. The discussion includes configuration details, compression options, and monitoring techniques. We also cover the pros and cons of both approaches.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[36,12,182,5,40],"tags":[191,646,648,645,42,647,39,119,459],"class_list":["post-1199","post","type-post","status-publish","format-standard","hentry","category-availability-groups","category-internals","category-migration","category-performance","category-sql-server-2022","tag-always-on-availability-groups","tag-automatic-seeding","tag-database-replication","tag-database-seeding","tag-high-availability","tag-manual-seeding","tag-performance-tuning","tag-sql-server-2022","tag-sql-server-administration"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Auto Seeding vs. Manual Seeding for AG Secondary Replicas in SQL Server - SQL Table Talk<\/title>\n<meta name=\"description\" content=\"This post explains the technical differences between automatic seeding and manual seeding for secondary replicas in SQL Server 2022 Always On availability groups. It describes how automatic seeding uses the AG transport layer to stream a virtual backup directly to the secondary, while manual seeding relies on traditional backup and restore operations. The discussion includes configuration details, compression options, and monitoring techniques. We also cover the pros and cons of both approaches.\" \/>\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.sqltabletalk.com\/?p=1199\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Auto Seeding vs. Manual Seeding for AG Secondary Replicas in SQL Server - SQL Table Talk\" \/>\n<meta property=\"og:description\" content=\"This post explains the technical differences between automatic seeding and manual seeding for secondary replicas in SQL Server 2022 Always On availability groups. It describes how automatic seeding uses the AG transport layer to stream a virtual backup directly to the secondary, while manual seeding relies on traditional backup and restore operations. The discussion includes configuration details, compression options, and monitoring techniques. We also cover the pros and cons of both approaches.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqltabletalk.com\/?p=1199\" \/>\n<meta property=\"og:site_name\" content=\"SQL Table Talk\" \/>\n<meta property=\"article:published_time\" content=\"2025-10-10T13:00:00+00:00\" \/>\n<meta name=\"author\" content=\"Stephen Planck\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stephen Planck\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=1199#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=1199\"},\"author\":{\"name\":\"Stephen Planck\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\"},\"headline\":\"Auto Seeding vs. Manual Seeding for AG Secondary Replicas in SQL Server\",\"datePublished\":\"2025-10-10T13:00:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=1199\"},\"wordCount\":686,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\"},\"keywords\":[\"Always On Availability Groups\",\"Automatic Seeding\",\"Database Replication\",\"Database Seeding\",\"High Availability\",\"Manual Seeding\",\"performance tuning\",\"SQL Server 2022\",\"SQL Server Administration\"],\"articleSection\":[\"Availability Groups\",\"Internals\",\"Migration\",\"Performance\",\"SQL Server 2022\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.sqltabletalk.com\/?p=1199#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=1199\",\"url\":\"https:\/\/www.sqltabletalk.com\/?p=1199\",\"name\":\"Auto Seeding vs. Manual Seeding for AG Secondary Replicas in SQL Server - SQL Table Talk\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#website\"},\"datePublished\":\"2025-10-10T13:00:00+00:00\",\"description\":\"This post explains the technical differences between automatic seeding and manual seeding for secondary replicas in SQL Server 2022 Always On availability groups. It describes how automatic seeding uses the AG transport layer to stream a virtual backup directly to the secondary, while manual seeding relies on traditional backup and restore operations. The discussion includes configuration details, compression options, and monitoring techniques. We also cover the pros and cons of both approaches.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=1199#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqltabletalk.com\/?p=1199\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=1199#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqltabletalk.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Auto Seeding vs. Manual Seeding for AG Secondary Replicas in SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#website\",\"url\":\"https:\/\/www.sqltabletalk.com\/\",\"name\":\"SQL Table Talk\",\"description\":\"Breaking Down SQL Server, One Post at a Time.\",\"publisher\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqltabletalk.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\",\"name\":\"Stephen Planck\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g\",\"caption\":\"Stephen Planck\"},\"logo\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/dexterwiki.com\",\"https:\/\/www.linkedin.com\/in\/stephen-planck-4611b692?trk=people-guest_people_search-card&challengeId=AQErf8gbBmcVMwAAAYsyIsxO-0UvU8z7cHrBpZoo_n3xt9qEKpRN5B_jd_LmAMu-OfeArkQ7GDjobJ2uRoQQV35EQdh_rR6kxA&submissionId=09de7067-c335-8e17-40b8-8dc32b60ed6c&challengeSource=AgEcUCw35zpPmAAAAYsyI4vAWhJTV7Nt4vZYKc3V1qiDBpCkKgUvtlOBgYXcE84&challegeType=AgE_wZiTT09IAQAAAYsyI4vDmNvbZIYe6XHju5V2bXVvM3IVxnJslgY&memberId=AgESFTkUShzs_gAAAYsyI4vGYk0Gic1uc5kB6cKOABA26Gw&recognizeDevice=AgHdSZyUSI5CEwAAAYsyI4vKd_koF9JgpsCJShT8QfbK1QMiv8SI\",\"https:\/\/www.youtube.com\/linuxmate\"],\"url\":\"https:\/\/www.sqltabletalk.com\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Auto Seeding vs. Manual Seeding for AG Secondary Replicas in SQL Server - SQL Table Talk","description":"This post explains the technical differences between automatic seeding and manual seeding for secondary replicas in SQL Server 2022 Always On availability groups. It describes how automatic seeding uses the AG transport layer to stream a virtual backup directly to the secondary, while manual seeding relies on traditional backup and restore operations. The discussion includes configuration details, compression options, and monitoring techniques. We also cover the pros and cons of both approaches.","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.sqltabletalk.com\/?p=1199","og_locale":"en_US","og_type":"article","og_title":"Auto Seeding vs. Manual Seeding for AG Secondary Replicas in SQL Server - SQL Table Talk","og_description":"This post explains the technical differences between automatic seeding and manual seeding for secondary replicas in SQL Server 2022 Always On availability groups. It describes how automatic seeding uses the AG transport layer to stream a virtual backup directly to the secondary, while manual seeding relies on traditional backup and restore operations. The discussion includes configuration details, compression options, and monitoring techniques. We also cover the pros and cons of both approaches.","og_url":"https:\/\/www.sqltabletalk.com\/?p=1199","og_site_name":"SQL Table Talk","article_published_time":"2025-10-10T13:00:00+00:00","author":"Stephen Planck","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Stephen Planck","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqltabletalk.com\/?p=1199#article","isPartOf":{"@id":"https:\/\/www.sqltabletalk.com\/?p=1199"},"author":{"name":"Stephen Planck","@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0"},"headline":"Auto Seeding vs. Manual Seeding for AG Secondary Replicas in SQL Server","datePublished":"2025-10-10T13:00:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqltabletalk.com\/?p=1199"},"wordCount":686,"commentCount":0,"publisher":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0"},"keywords":["Always On Availability Groups","Automatic Seeding","Database Replication","Database Seeding","High Availability","Manual Seeding","performance tuning","SQL Server 2022","SQL Server Administration"],"articleSection":["Availability Groups","Internals","Migration","Performance","SQL Server 2022"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqltabletalk.com\/?p=1199#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqltabletalk.com\/?p=1199","url":"https:\/\/www.sqltabletalk.com\/?p=1199","name":"Auto Seeding vs. Manual Seeding for AG Secondary Replicas in SQL Server - SQL Table Talk","isPartOf":{"@id":"https:\/\/www.sqltabletalk.com\/#website"},"datePublished":"2025-10-10T13:00:00+00:00","description":"This post explains the technical differences between automatic seeding and manual seeding for secondary replicas in SQL Server 2022 Always On availability groups. It describes how automatic seeding uses the AG transport layer to stream a virtual backup directly to the secondary, while manual seeding relies on traditional backup and restore operations. The discussion includes configuration details, compression options, and monitoring techniques. We also cover the pros and cons of both approaches.","breadcrumb":{"@id":"https:\/\/www.sqltabletalk.com\/?p=1199#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqltabletalk.com\/?p=1199"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqltabletalk.com\/?p=1199#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqltabletalk.com\/"},{"@type":"ListItem","position":2,"name":"Auto Seeding vs. Manual Seeding for AG Secondary Replicas in SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.sqltabletalk.com\/#website","url":"https:\/\/www.sqltabletalk.com\/","name":"SQL Table Talk","description":"Breaking Down SQL Server, One Post at a Time.","publisher":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqltabletalk.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0","name":"Stephen Planck","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g","caption":"Stephen Planck"},"logo":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/dexterwiki.com","https:\/\/www.linkedin.com\/in\/stephen-planck-4611b692?trk=people-guest_people_search-card&challengeId=AQErf8gbBmcVMwAAAYsyIsxO-0UvU8z7cHrBpZoo_n3xt9qEKpRN5B_jd_LmAMu-OfeArkQ7GDjobJ2uRoQQV35EQdh_rR6kxA&submissionId=09de7067-c335-8e17-40b8-8dc32b60ed6c&challengeSource=AgEcUCw35zpPmAAAAYsyI4vAWhJTV7Nt4vZYKc3V1qiDBpCkKgUvtlOBgYXcE84&challegeType=AgE_wZiTT09IAQAAAYsyI4vDmNvbZIYe6XHju5V2bXVvM3IVxnJslgY&memberId=AgESFTkUShzs_gAAAYsyI4vGYk0Gic1uc5kB6cKOABA26Gw&recognizeDevice=AgHdSZyUSI5CEwAAAYsyI4vKd_koF9JgpsCJShT8QfbK1QMiv8SI","https:\/\/www.youtube.com\/linuxmate"],"url":"https:\/\/www.sqltabletalk.com\/?author=1"}]}},"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/1199","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1199"}],"version-history":[{"count":2,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/1199\/revisions"}],"predecessor-version":[{"id":1201,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/1199\/revisions\/1201"}],"wp:attachment":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1199"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1199"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}