{"id":3540,"date":"2019-08-06T02:57:14","date_gmt":"2019-08-06T02:57:14","guid":{"rendered":"https:\/\/litextension.com\/faq\/docs\/shopping-cart-questions\/nopcommerce\/create-a-full-database-backup-sql-server\/"},"modified":"2024-12-31T04:08:19","modified_gmt":"2024-12-31T04:08:19","slug":"create-a-full-database-backup-sql-server","status":"publish","type":"docs","link":"https:\/\/litextension.com\/faq\/docs\/migration-process\/migration-preparation\/create-a-full-database-backup-sql-server\/","title":{"rendered":"How to create a full database backup (SQL Server)?"},"content":{"rendered":"\n<p>Creating a full database backup in SQL Server is essential for preserving your data and ensuring you have a reliable restore point in case of system failure, corruption, or migration. A full backup includes all the data and transaction logs, making it a comprehensive safeguard for your database. Follow the steps below to create a full backup quickly and securely.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"a-full-back-up-to-disk-to-default-location\">Full Backup to Disk (Default Location)<\/h2>\n\n\n\n<p>In this example, the&nbsp;<code>SQLTestDB<\/code>&nbsp;database will be backed up to disk at the default backup location. A backup of<code>SQLTestDB<\/code>&nbsp;has never been taken.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>In\u00a0Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.<\/li>\n\n\n\n<li>Expand\u00a0Databases, right-click\u00a0<code>SQLTestDB<\/code>, point to\u00a0Tasks > Back Up.<\/li>\n\n\n\n<li>Select\u00a0OK.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/media\/quickstart-backup-restore-database\/backup-db-ssms.png?view=sql-server-2017\" alt=\"Create a Full Database Backup (SQL Server)\"\/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\">Export Data from a Remote Server to a Local Server<\/h3>\n\n\n\n<p>Another approach involves exporting data from a remote server to a local server using SQL Server tools. For a step-by-step video guide on this method, check out this video tutorial:<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"entry-content-asset\"><iframe loading=\"lazy\" title=\"Export data from Remote server to local server using SQL server\" width=\"835\" height=\"470\" src=\"https:\/\/www.youtube.com\/embed\/CDr_KlCZm2Q?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/div>\n<\/div><\/figure>\n\n\n\n<p>In case you have any other questions, please reach out to us via:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/litextension.zendesk.com\/hc\/en-us\/signin?return_to=https%3A%2F%2Flitextension.zendesk.com%2Fhc%2Fen-us%2Frequests\" target=\"_blank\" rel=\"noopener\">Ticket system<\/a> (highly recommended)<\/li>\n\n\n\n<li>Email us at <a href=\"mailto:contact@litextension.com\" target=\"_blank\" rel=\"noopener\">contact@litextension.com<\/a><\/li>\n<\/ul>\n","protected":false},"author":1,"featured_media":0,"parent":6184,"menu_order":19,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_tag":[4192,4193],"class_list":["post-3540","docs","type-docs","status-publish","hentry","doc_tag-create-a-full-database-backup","doc_tag-sql-server"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/3540","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/comments?post=3540"}],"version-history":[{"count":10,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/3540\/revisions"}],"predecessor-version":[{"id":7096,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/3540\/revisions\/7096"}],"up":[{"embeddable":true,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/6184"}],"prev":[{"title":"How can I add LitExtension IPs to whitelist?","link":"https:\/\/litextension.com\/faq\/docs\/migration-process\/migration-preparation\/how-can-i-add-litextension-ips-to-white-list\/","href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/263"}],"wp:attachment":[{"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/media?parent=3540"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/doc_tag?post=3540"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}