{"id":5117,"date":"2019-03-21T08:56:18","date_gmt":"2019-03-21T08:56:18","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=5117"},"modified":"2019-03-22T12:05:41","modified_gmt":"2019-03-22T12:05:41","slug":"how-to-backup-an-sql-server-database","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-backup-an-sql-server-database\/","title":{"rendered":"How to Backup an SQL Server Database?"},"content":{"rendered":"

To cope up with the data loss situations like hardware failure, network intrusions, human errors, natural calamities, etc. you should always take a backup for your SQL database.<\/p>\n

Microsoft Server Management Studio Express is a free and open source graphical management tool that can be used to manage your SQL database.<\/p>\n

To back up your SQL database using Microsoft SQL server management Studio Express you should make sure that:<\/p>\n

1) You must have direct access to the local server desktop.<\/p>\n

2) You must have Microsoft SQL Server Management Studio Express installed and running on the server prior to the export.<\/p>\n

The backup file that you download needs .bak file extension. If the database is stored on the shared servers, then the backups get generated on the server itself. You may contact your windows support team to get the copy of the backup.<\/p>\n

Method 1 –<\/strong><\/h3>\n

Steps to follow to take a backup of the SQL server database :<\/p>\n

\u00a0<\/strong>Step 1:<\/strong> First, of all, you will need to configure the Microsoft Server Management Studio on your local machine.<\/p>\n

Step 2:<\/strong> Open your Microsoft SQL Server Management Studio, Standard or Express edition whatever you prefer.<\/p>\n

Step 3:<\/strong> Enter your database Username and Password to login to your MS SQL server database.<\/p>\n

Step 4:<\/strong> Expand the database.<\/p>\n

Step 5:<\/strong> Right click on the database you want to take backup. Database -> Tasks -> Back Up<\/p>\n

\"image<\/a><\/p>\n

Step 6:<\/strong> The Back Up Database window will appear on your screen. Now select the following options on it :<\/p>\n

    \n
  1. Backup type: Full<\/strong><\/li>\n
  2. Under Destination -> Backup to : Disk<\/strong><\/li>\n<\/ol>\n

    \"image<\/a><\/p>\n

    Step 7:<\/strong> Click Add<\/strong>. Now you can see the following window that will appear on your screen. Select the desired path and file name for the database backup file.<\/p>\n

    Step 8:<\/strong> Select the destination folder where you like to store the backup. Enter the File name with .bak<\/strong> extension<\/p>\n

    \"image<\/a><\/p>\n

    Important:<\/strong> Make sure that you place your MS SQL database in the .bak file under the MSSQL backup folder.<\/strong><\/p>\n

    Step 9:<\/strong> Click on OK<\/strong> to finish your backup. Once done with this, the message will appear showing your successful completion of database backup process. The confirmation window will show you the message that \u201c The backup of database \u2018yourdatabasename\u2019 completed successfully\u201d.<\/strong><\/p>\n

    \"image<\/a><\/p>\n

    Hurray!<\/p>\n

    Your backup is completed.<\/p>\n

    Related:<\/strong>\u00a0A Complete Guide to SQL Injection<\/a><\/p>\n

    Method 2 –<\/strong><\/h3>\n

    The BACKUP DATABASE allows you to take the complete backup of your database and files, differential, etc. backups. This depends on the option that you like to use.<\/p>\n

    Let\u2019s see the commands to be used to take a backup, and can be used in Windows Cloud VPS and Windows Dedicated Server.<\/p>\n

    To Create a full backup to disk<\/strong><\/h3>\n

    BACKUP DATABASE –<\/strong> Give the database name with this command.<\/p>\n

    TO DISK \u2013<\/strong> It specifies that the backup would be written to the disk. Specify the location and file.<\/p>\n

    \"image<\/a><\/p>\n

    To Create a differential backup<\/strong><\/h3>\n

    \u00a0<\/strong>In this command, you just need to add \u201cWITH DIFFERENTIAL\u201d<\/strong> option as shown below.<\/p>\n

    \"image<\/a><\/p>\n

    That\u2019s it.<\/p>\n

    Taking backup is very easy by just using these two commands.<\/p>\n","protected":false},"excerpt":{"rendered":"

    To cope up with the data loss situations like hardware failure, network intrusions, human errors, natural calamities, etc. you should always take a backup for your SQL database. Microsoft Server Management Studio Express is a free and open source graphical management tool that can be used to manage your SQL database. To back up your […]<\/p>\n","protected":false},"author":18,"featured_media":5137,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[230],"tags":[606,605],"class_list":["post-5117","post","type-post","status-publish","format-standard","has-post-thumbnail","placeholder-for-hentry","category-database","tag-sql-backup","tag-sql-database"],"yoast_head":"\nHow to Backup an SQL Server Database? - Web Hosting FAQs by MilesWeb<\/title>\n<meta name=\"description\" content=\"This article guides you on how to take the backup of your SQL server database.\" \/>\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.milesweb.co.uk\/hosting-faqs\/how-to-backup-an-sql-server-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Backup an SQL Server Database? - Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"og:description\" content=\"This article guides you on how to take the backup of your SQL server database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-backup-an-sql-server-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-21T08:56:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-03-22T12:05:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/03\/How-to-backup.png\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"445\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Sonam Wagh\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sonam Wagh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-backup-an-sql-server-database\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-backup-an-sql-server-database\/\",\"name\":\"How to Backup an SQL Server Database? - Web Hosting FAQs by MilesWeb\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-backup-an-sql-server-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-backup-an-sql-server-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/03\/How-to-backup.png\",\"datePublished\":\"2019-03-21T08:56:18+00:00\",\"dateModified\":\"2019-03-22T12:05:41+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4\"},\"description\":\"This article guides you on how to take the backup of your SQL server database.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-backup-an-sql-server-database\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-backup-an-sql-server-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-backup-an-sql-server-database\/#primaryimage\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/03\/How-to-backup.png\",\"contentUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/03\/How-to-backup.png\",\"width\":800,\"height\":445,\"caption\":\"How to backup\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-backup-an-sql-server-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Backup an SQL Server Database?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4\",\"name\":\"Sonam Wagh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9cb2cf6ae11d7625ef6417ef8e84ba25?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9cb2cf6ae11d7625ef6417ef8e84ba25?s=96&d=blank&r=g\",\"caption\":\"Sonam Wagh\"},\"description\":\"With an interest in doing something creative daily, Sonam works as a Digital Marketing Executive. She likes to write technical blogs related to web hosting, digital marketing, and other IT topics. She also likes to spend her leisure time on social media to find different strategies for client engagement.\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/sonam\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Backup an SQL Server Database? - Web Hosting FAQs by MilesWeb","description":"This article guides you on how to take the backup of your SQL server database.","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.milesweb.co.uk\/hosting-faqs\/how-to-backup-an-sql-server-database\/","og_locale":"en_GB","og_type":"article","og_title":"How to Backup an SQL Server Database? - Web Hosting FAQs by MilesWeb","og_description":"This article guides you on how to take the backup of your SQL server database.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-backup-an-sql-server-database\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2019-03-21T08:56:18+00:00","article_modified_time":"2019-03-22T12:05:41+00:00","og_image":[{"width":800,"height":445,"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/03\/How-to-backup.png","type":"image\/png"}],"author":"Sonam Wagh","twitter_misc":{"Written by":"Sonam Wagh","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-backup-an-sql-server-database\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-backup-an-sql-server-database\/","name":"How to Backup an SQL Server Database? - Web Hosting FAQs by MilesWeb","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-backup-an-sql-server-database\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-backup-an-sql-server-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/03\/How-to-backup.png","datePublished":"2019-03-21T08:56:18+00:00","dateModified":"2019-03-22T12:05:41+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4"},"description":"This article guides you on how to take the backup of your SQL server database.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-backup-an-sql-server-database\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-backup-an-sql-server-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-backup-an-sql-server-database\/#primaryimage","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/03\/How-to-backup.png","contentUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/03\/How-to-backup.png","width":800,"height":445,"caption":"How to backup"},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-backup-an-sql-server-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How to Backup an SQL Server Database?"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4","name":"Sonam Wagh","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9cb2cf6ae11d7625ef6417ef8e84ba25?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9cb2cf6ae11d7625ef6417ef8e84ba25?s=96&d=blank&r=g","caption":"Sonam Wagh"},"description":"With an interest in doing something creative daily, Sonam works as a Digital Marketing Executive. She likes to write technical blogs related to web hosting, digital marketing, and other IT topics. She also likes to spend her leisure time on social media to find different strategies for client engagement.","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/sonam\/"}]}},"views":796,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/5117","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=5117"}],"version-history":[{"count":5,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/5117\/revisions"}],"predecessor-version":[{"id":5138,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/5117\/revisions\/5138"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media\/5137"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=5117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=5117"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=5117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}