How do I Import and Export Data from my MSSQL Database ?

Windows Web Hosting have the easy way of uploading database file in the server using SQL Management Studio . The below process explanation will help users to upload the database in the Web Hosting Server.

Share This Now: [addtoany]

Watch Reseller Hosting Video Tutorial

Procedure

Procedure to Import and Export Data from my MSSQL Database :

Windows Unlimited Reseller Web Hosting comes with Plesk Control Panel . You will be able to import and export the database using SQL management studio . Please follow the below procedure to Import and Export Data using SQL management studio

To import/export the database your ip should been allowed in the firewall

Please note that you can add ips instantly to access your database remotely through “AddSQLIP” option in the plesk panel. To add ip addresses, follow the steps given below;

[1] Login to your plesk control panel.
[2] Click on the domain name you wish to add the ip for sql access from the subscriptions list
[3] Click on Websites and Domains option in your control panel
[4] Click on AddSQLIP button in the control panel
[5] Supply the IP Address and submit
[6] Wait for 15-20 min to get your ip reflected in the firewall

Kindly follow the below procedure to export the back up from the server:

[1] Login to SQL management studio
[2] Click on Database >>Right click on the database>>Tasks>>Export Data
[3] Click on Next
[4] Give the following details

Data Source : Select the data source
Server name: Server ip address
Authentication: Select Use SQL Server Authentication, then enter your database username and password. This is the username and password you chose when you created your
database.
Database: Enter the name of your database from the drop down menu.

[5] Click Next.

You will be asked where to export the database contents to. Select Flat File Destination from the drop down menu and choose a file name and location for your backup.

[6] Click Next.

Select Copy data from one or more tables or views and click Next.

[7] Finally, choose which tables or views you want to export and select how you would like the file to be formatted. Once done click Next.

[8] Click Next, then Finish to export your file. You will receive confirmation that your database content has been backed up.

Please update us the below details in the ticket in order to proceed for database restoration at our end.

Domain name
Database name
Database username
Database backup file name and its path under httpdocs folder

Screen Shots

Refer Screen Shots

Troubleshooting FAQs

MSSQL Troubleshooting FAQs

I am getting error “Login Failed for user” while accessing mssql database ?

Solution :

Kindly reset the database login details and check at your end

[1] Access your control panel at https://www.yourdomain.com:8443/
[2] Click on Subscriptions.
[3] Click on Control panel of that domain and click on website and domains.
[4] Click on Databases
[5] Click on Database name
[6] Click on Database user name
[7] Give new passwrod [ Note : password should be tough which consists of alphanumeric characters ]
[8] Confirm the password
[9] Click on ok

I am getting error A network-related or instance-specific error while accessing SQL Management Studio ?

Solution :

If your ip address is not allowed in server firewall then you will get an error ” A network-related or instance-specific error”. To add ip addresses, follow the steps given below

[1] Login to your plesk control panel
[2] Click on the domain name you wish to add the ip for sql access from the subscriptions list
[3] Click on Websites and Domains option in your control panel
[4] Click on AddSQLIP button in the control panel
[5] Supply the IP Address and submit
[6] Wait for 15-20 min to get your ip reflected in the firewall

Then you can access the database via sql management studio.