Pace Infonet Web Solutions provides best cheap affordable and reliable windows web hosting in mumbai, windows web hosting in india, windows web hosting in baroda pune delhi ahmedabad, .net web hosting in mumbai, .net web hosting in india delhi, .net web hosting in baroda ahmedabad pune delhi, linux web hosting in ahmedabad baroda pune mumbai delhi, windows vps hosting in mumbai india baroda delhi, linux vps hosting in mumbai india baroda ahmedabad pune delhi, email hosting services in mumbai pune baroda delhi and all over india.

Welcome to Pace Infonet Web Solutions where you can find the best web hosting in india mumbai delhi pune ahmedabad baroda web hosting windows web hosting in mumbai cheap and affordabe web hosting in ahmedabad pune baroda delhi mumbai india web hosting .net web hosting in baroda pune delhi mumbai ahmedabad, windows vps hosting in mumbai delhi pune ahmedabad baroda pune india, linux vps hosting in mumbai ahmedabad baroda india delhi pune and business email hosting in mumbai ahmedabad delhi baroda pune india is also available. Also when compared to godaddy and bigrock our web hosting plans are reliable and affordable than bigrock and godaddy.

Restore MS SQL Server Database in Parallels Plesk panel


When you are hosting a dynamic web application, you may need to use an MS SQL Server database with it. In order to achieve this, you will need to restore your local MS SQL Server Database to the Web Hosting Database Server.

Whether you are hosting for the first time or migrating from another server, Windows Web Hosting with Parallels Plesk Hosting Control Panel makes the task a lot easy. This article will guide you on how you can restore an MS SQL Server Database using Parallels Plesk Hosting Control Panel.

First step will be to prepare a .bak backup file of your local database on your local computer or download the .bak backup file from another hosting server if you are migrating your account from one server to another. Once that is done, please go through below steps to create a New MS SQL Database on Database Server and then restore it.

i. Login to your Plesk account. On the homepage, click on the “Databases” icon from the list.

Restore MS SQL Server

ii. Then click on the “Add New Database” option on the page to get a form. Fill in the Database Name you desire and also create a Database Username and Password. Make sure you select MS SQL in Database Type.

NOTE: You will need to change the Data source/Serve name, Database Name, Database Username and Database Password in your web application’s Connection String as per database created on server.

mssql2008Addnewdatabase

iii. Once database is created, go to Homepage again by clicking on “Websites & Domains” main menu. Now to restore your database, click on the “Backup Manager” icon on Homepage.

mssql2008-Click Back

iv. In Backup Manager, click on “Database Backup Repository” icon from the top horizontal list. From the page that opens, click on the “Upload Backup File” option. This will open a wizard which will allow you to restore your .bak backup file. Please note that it will only accept .bak file, so if you have the backup in .zip format then please extract it first then restore.

ms2008repository

The above wizard will first upload the .bak file to database repository and then prompt you to restore it to a specific database already created on server. You need to make sure that your database .bak backup file is a valid backup file and does not have any strongly typed database names or database usernames of your local database server.

If the above method does not work for you, you can always use the conventional method of executing a published SQL Script via MS SQL Server Management Studio from local computer or MyLittleAdmin available in Plesk panel’s Databases section.

Related Articles:-

Backup MS SQL Server Database from WebsitePanel Account.

3,566 total views, 1 views today

May 18, 2016
1. Click on the Applications / Menu button on the Home Screen of your Android Device 2. Open the 'Email' Application. 3. Select the Account Type as ...
May 17, 2016
When anyone makes a purchase on our website www.paceinfonet.com, they get registered with us and receive a Welcome Email on their registered email address which ...
 

Need Sales Assistance? CALL : 950-95-77-455 / Chat With Expert

Who We Are

An affordable web hosting company in India- Pace Infonet specializes in offering consistent and cost effective web hosting services in Mumbai and cheap web hosting that comprise of Shared, E-Mail, Reseller, VPS, Dedicated and SEO Hosting for both Windows and Linux. We assure the best, reliable hosting environment, thereby delivering your content very rapidly. Pace Infonet Web Solutions also include .NET web hosting, PHP web hosting, shared web hosting, blog web hosting packages and reseller hosting with varying configurations to be chosen. You can avail of the best options out there in the web hosting marketplace. Learn More…

Top

All web hosting, windows vps hosting, linux vps hosting, business email hosting, dedicated servers in mumbai delhi ahmedabad pune baroda india are provided by Pace Infonet Web Solutions at best cheap affordable prices in india navi mumbai mumbai delhi pune baroda ahmedabad and rest of india. In comparison to godaddy and bigrock our web hosting plans are affordable and reliable than godaddy and bigrock.

Login to Client Area

 

Our Billing & Support Center provides an easy and intuitive way to manage your domains & web hosting services, view & Pay your invoices online and raise your queries to our hosting support departments instantly.

Don't remember your password? Use Password Reset Wizard

X