Description :
This feature allows you to export the tables of the MSSQL database.
Required Information :
* Your website's hosting control panel user name and password
* Database username and password
* Your ip should be allowed in firewall.
Procedure :
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
 |
 |
 |
