Exporting and Importing MSSQL Databases over a Network Share

While SMSS doesn’t contain this function natively, we are going to show you a work around!

This is both how you backup an MSSQL database and how you move a database between two servers.

When creating an MSSQL backup, your database will be exported as a .bak file.

Person wearing the Apple Watch Series 10

you might add one or multiple locations for the destination location of your .bak file.

Click OK and your database will be backed up to the selected location.

To import your database, right-choose your server instead of the database, and select Restore Database.

wireless charger

Click Add and you could navigate to the .bak file you wish to restore.

Click OK and your database will be imported to the current SQL server!

Why Can’t I Export Directly to a Mapped Drive?

synology nas

Many venture to manually enter the path to their internet drive.

kindly note that to create these shares, you almost certainly need administrator rights.

it’s possible for you to now export and import backups directly from this location.

You have now setup a data pipe share within SQL that persists even if you close and reopen SSMS.

Run a backup for the database by right-clicking the desired databases and navigating to Tasks > Backup.

Here, you can select options to select options to backup.

Import your database by right-clicking on your server and selecting Restore Database.

Select the file you want to import from, under the Device setting, along with its location destination and any other necessary advanced options.

Selection of the network location where the backup should be stored.

Local drives to select from on the Select Backup Destination menu.

You can directly enter the path to your network share drive on the Select Backup Destination menu.

If a backup cannot find the right path to store the backup, a failure message witll be displayed at final export.

Executing a deletion of of the current network share.