{"id":6749,"date":"2019-03-19T14:55:10","date_gmt":"2019-03-19T14:55:10","guid":{"rendered":"https:\/\/ittutorial.org\/?p=6749"},"modified":"2019-11-28T06:56:54","modified_gmt":"2019-11-28T06:56:54","slug":"sql-server-parallel-backup-restore-2","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/sql-server-parallel-backup-restore-2\/","title":{"rendered":"SQL Server Parallel Backup Restore -2"},"content":{"rendered":"

Hi,<\/p>\n

You need parallel backup and restore in SQL Server to do fastly.<\/p>\n

\"\"<\/p>\n

<\/p>\n\n

 <\/p>\n

I have used file sharing from remote server and I have restored SQL Server from backup file sharing of production server.<\/p>\n

If you don’t want to transfer backup files to the test environment, or you don’t have free space on test environment then you can use this method.<\/p>\n

You can restore SQL Server database\u00a0 8 parallel with following script. Change database name and path according to your environment.<\/p>\n

 <\/p>\n

USE [master]\r\nRESTORE DATABASE [DEVECI] FROM  \r\nDISK = N'\\\\192.168.63.63\\z$\\Full_01.bak',  \r\nDISK = N'\\\\192.168.63.63\\z$\\Full_02.bak',  \r\nDISK = N'\\\\192.168.63.63\\z$\\Full_03.bak',  \r\nDISK = N'\\\\192.168.63.63\\z$\\Full_04.bak',  \r\nDISK = N'\\\\192.168.63.63\\z$\\Full_05.bak',  \r\nDISK = N'\\\\192.168.63.63\\z$\\Full_06.bak',  \r\nDISK = N'\\\\192.168.63.63\\z$\\Full_07.bak',  \r\nDISK = N'\\\\192.168.63.63\\z$\\Full_08.bak' \r\nWITH  FILE = 1,  MOVE N'DEVECI' TO N'L:\\OLAP_DATA1\\SQLDATA\\DEVECI.mdf',  MOVE N'DEVECI_2' TO N'L:\\OLAP_DATA2\\SQLDATA\\DEVECI_2.ndf',  MOVE N'DEVECI_log' TO N'L:\\OLAP_LOG1\\SQLLOG\\DEVECI_1.ldf',  MOVE N'DEVECI_log_2' TO N'L:\\OLAP_LOG2\\SQLLOG\\DEVECI_2.ldf',  NORECOVERY,  NOUNLOAD,  STATS = 5\r\nGO<\/pre>\n
 <\/p>\n
or If you transfered backup files, you can restore SQL Server database 8 parallel with following query.<\/p>\n
 <\/p>\n
USE [master]\r\nRESTORE DATABASE [DEVECI] FROM \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 FILE = 1, MOVE N'DEVECI' TO N'L:\\OLAP_DATA1\\SQLDATA\\DEVECI.mdf', MOVE N'DEVECI_2' TO N'L:\\OLAP_DATA2\\SQLDATA\\DEVECI_2.ndf', MOVE N'DEVECI_log' TO N'L:\\OLAP_LOG1\\SQLLOG\\DEVECI_1.ldf', MOVE N'DEVECI_log_2' TO N'L:\\OLAP_LOG2\\SQLLOG\\DEVECI_2.ldf', NORECOVERY, NOUNLOAD, STATS = 5\r\nGO<\/pre>\n
 <\/p>\n\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
Do you want to learn Microsoft SQL Server DBA Tutorials for Beginners, then read the following articles.<\/span><\/h4>\n
https:\/\/ittutorial.org\/sql-server-tutorials-microsoft-database-for-beginners\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
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-6749","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\/6749","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=6749"}],"version-history":[{"count":2,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6749\/revisions"}],"predecessor-version":[{"id":12942,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6749\/revisions\/12942"}],"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=6749"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=6749"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=6749"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}