To create split backup files with SQL Server Management Studio, perform the following steps:

  1. Open the Object Explorer, expand the Databases node, and right click on the database that needs to be backed up. From the dropdown menu select "Tasks," and click on the Backup… option.

  2. In the General tab, specify the database that is used for the backup and the backup type (full or differential). To specify multiple backup paths, click the Add… button.



3. Set the backup destination by typing the path and the backup filename, or browse for the backup folder by using the browse button located on the right-hand side of the screen. Click "OK," when done. Repeat the step until all destinations are set. The list of backup paths is displayed on the bottom of the page.




4. By clicking the OK button, the backup process starts. The success message is displayed when the backup process completes. 


 

  

To restore the database from split backup files with SQL Server Management Studio, complete the following steps:

  1. Open the object explorer, right click on "Databases" node, and select )Restore Database."

  2. In the General tab, mark Device radio button, and browse for the backup files using the browse button on the right.

 

   3. In Select backup devices window, click "Add."


4. Browse for the backup files in the folder tree, or enter the backup path and file name manually. Click "OK," when done. Repeat the step until all of the backup files are listed, and click "OK" when finished. 



5. T program loads all file paths, and displays the name, type and the destination of the database that is about to be restored. To complete the restore process, click "OK."