1and1 Help Centre Categories

print article

Export an MSSQL Database

For Windows packages

Learn how to export the data from your MSSQL database to your computer.

If you want to export your MSSQL database, just follow the step-by-step instructions below.

Step 1
Log in to your 1&1 Control Panel and select the relevant package.
Step 2
Click on MSSQL Administration in the Hosting panel.
MSSQL Administration
MS SQL Administration

Step 3
Click Export from the Import/Export section of the page. Import/Export page
Import/Export page
Step 4
Select or enter the required information for the export.
Field Explanation Recommended
Database Select the database to export -
Directory Select the folder where the export file should be saved in your webspace /db
File name A name for the export file A file name including the date or database name
Format of backup file Select whether to compress the backup file or not .bak (not zipped)
Export page
Export page
Step 5
View the details on the confirmation page. If they are correct, click Export to export the data. Confirm Export page
Confirm Export page

You are taken back to the Export page. At the bottom you can view the status of any pending exports. Export Progress page

Export Progress page

To check the Export status at a later time, simply click follow steps 1 & 2 again to return to the Export Progress page.

For additional information, you may want to reference: