{"id":1162,"date":"2018-04-04T08:52:05","date_gmt":"2018-04-04T08:52:05","guid":{"rendered":"http:\/\/www.toponecrm.com\/blog\/?p=1162"},"modified":"2018-04-04T08:52:18","modified_gmt":"2018-04-04T08:52:18","slug":"sql-server-easy-way-to-backup-sql-table","status":"publish","type":"post","link":"https:\/\/toponecrm.com\/blog\/uncategorized\/sql-server-easy-way-to-backup-sql-table\/","title":{"rendered":"SQL Server:  easy way to backup SQL table"},"content":{"rendered":"<blockquote>\n<pre>Select *\r\n into copy\r\n from source<\/pre>\n<p>but it doesn\u2019t recreate indexes.<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Select * into copy from source but it doesn\u2019t recreate indexes.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_price":"","_stock":"","_tribe_ticket_header":"","_tribe_default_ticket_provider":"","_tribe_ticket_capacity":"0","_ticket_start_date":"","_ticket_end_date":"","_tribe_ticket_show_description":"","_tribe_ticket_show_not_going":false,"_tribe_ticket_use_global_stock":"","_tribe_ticket_global_stock_level":"","_global_stock_mode":"","_global_stock_cap":"","_tribe_rsvp_for_event":"","_tribe_ticket_going_count":"","_tribe_ticket_not_going_count":"","_tribe_tickets_list":[],"_tribe_ticket_has_attendee_info_fields":false},"categories":[1],"tags":[],"ticketed":false,"_links":{"self":[{"href":"https:\/\/toponecrm.com\/blog\/wp-json\/wp\/v2\/posts\/1162"}],"collection":[{"href":"https:\/\/toponecrm.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/toponecrm.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/toponecrm.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/toponecrm.com\/blog\/wp-json\/wp\/v2\/comments?post=1162"}],"version-history":[{"count":2,"href":"https:\/\/toponecrm.com\/blog\/wp-json\/wp\/v2\/posts\/1162\/revisions"}],"predecessor-version":[{"id":1164,"href":"https:\/\/toponecrm.com\/blog\/wp-json\/wp\/v2\/posts\/1162\/revisions\/1164"}],"wp:attachment":[{"href":"https:\/\/toponecrm.com\/blog\/wp-json\/wp\/v2\/media?parent=1162"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/toponecrm.com\/blog\/wp-json\/wp\/v2\/categories?post=1162"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/toponecrm.com\/blog\/wp-json\/wp\/v2\/tags?post=1162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}