{"id":6747,"date":"2019-03-19T14:47:49","date_gmt":"2019-03-19T14:47:49","guid":{"rendered":"https:\/\/ittutorial.org\/?p=6747"},"modified":"2019-11-28T06:58:41","modified_gmt":"2019-11-28T06:58:41","slug":"sql-server-parallel-backup-restore-1","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/sql-server-parallel-backup-restore-1\/","title":{"rendered":"SQL Server Parallel Backup Restore -1"},"content":{"rendered":"<p>Hi,<\/p>\n<p>You need parallel backup and restore in SQL Server to do fastly.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2793\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2012\/10\/backup.jpg\" alt=\"\" width=\"400\" height=\"243\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2012\/10\/backup.jpg 400w, https:\/\/ittutorial.org\/wp-content\/uploads\/2012\/10\/backup-300x182.jpg 300w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/p>\n<p><!--more--><\/p>\n\n<p>&nbsp;<\/p>\n<p>You can take SQL Server backup 8 parallel with following script. Change database name and path according to your environment.<\/p>\n<p>You should specify parallel count according to your CPU count. I have 8 CPU, so I have taken 8 parallel backup.<\/p>\n<p>I have also used compression, if you have enough free space you don&#8217;t need using compression.<\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<pre>BACKUP DATABASE [DEVECI] TO \r\nDISK = N'Z:\\Full_01.bak', \r\nDISK = N'Z:\\Full_02.bak', \r\nDISK = N'Z:\\Full_03.bak', \r\nDISK = N'Z:\\Full_04.bak', \r\nDISK = N'Z:\\Full_05.bak', \r\nDISK = N'Z:\\Full_06.bak', \r\nDISK = N'Z:\\Full_07.bak', \r\nDISK = N'Z:\\Full_08.bak' \r\nWITH NOFORMAT, NOINIT, NAME = N'DEVECI-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10\r\nGO<\/pre>\n<p>&nbsp;<\/p>\n<p>I will tell parallel restore in the next post.<\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #ff0000;\">Do you want to learn Microsoft SQL Server DBA Tutorials for Beginners, then read the following articles.<\/span><\/h4>\n<p><a href=\"https:\/\/ittutorial.org\/sql-server-tutorials-microsoft-database-for-beginners\/\">https:\/\/ittutorial.org\/sql-server-tutorials-microsoft-database-for-beginners\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, You need parallel backup and restore in SQL Server to do fastly.<\/p>\n","protected":false},"author":1,"featured_media":2793,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3828,2227,3827],"tags":[1028,1031,2651,1515,1577,1600,1610,2231,1620,2372,2374,1621,2373,2652,2375,2649,2648,2650,2230,2229],"class_list":["post-6747","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-sql-scripts","category-sql-server-2","category-sql-server-dba-scripts","tag-mehmet-deveci","tag-mehmet-salih-deveci","tag-parallel-backup-sql-server","tag-salih-deveci","tag-sql-server","tag-sql-server-2012","tag-sql-server-2014","tag-sql-server-2019","tag-sql-server-backup","tag-sql-server-backup-check","tag-sql-server-backup-monitor","tag-sql-server-backup-restore","tag-sql-server-backups","tag-sql-server-fast-backup","tag-sql-server-monitor-backup","tag-sql-server-parallel-backup","tag-sql-server-parallel-backup-restore","tag-sql-server-parallel-restore","tag-sql-server-useful-query","tag-sql-server-useful-script"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2012\/10\/backup.jpg","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6747","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=6747"}],"version-history":[{"count":2,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6747\/revisions"}],"predecessor-version":[{"id":12943,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6747\/revisions\/12943"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/2793"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=6747"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=6747"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=6747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}