Web Hosting Forum | Lunarpages


*
Welcome, Guest. Please login or register.
Did you miss your activation email?



Login with username, password and session length
May 25, 2012, 11:54:50 AM

Pages: [1]   Go Down
  Print  
Author Topic: How do I upload my MSSQL database to the server?  (Read 30218 times)
gooseduck
Space Explorer
***
Offline Offline

Posts: 8


« on: November 19, 2008, 04:53:01 PM »

This is a very basic task. Lunarpages should have a definitive guide for their customers.
Thanks.
Logged
Mitch
Berserker Poster
*****
Offline Offline

Posts: 12837


WWW
« Reply #1 on: November 20, 2008, 06:50:02 AM »

I totally agree, so I did a little work and put this together for you:

http://wiki.lunarpages.com/Restore_MS_SQL_Database

If you run into any issues, contact support@lunarpages.com and they'll be happy to assist.
Logged

New to Web Site Hosting? Check Out the Lunarpages Blog Hosting Guide!


Follow us @lunarpages on Twitter!
Important Threads: Read This Before Posting! | Lunarforums Rules! | Mitch's Link of the Day!
Also, be sure to check out and subscribe to the Lunartics Blog and the Lunarpages Newsletter !

Need Web Hosting Help? Check out the Lunarpages Web Hosting Wiki. It has tons of tips, tutorials and resources!
vks87
Intergalactic Cowboy
*****
Offline Offline

Posts: 63


« Reply #2 on: March 26, 2009, 02:57:16 AM »

Mysql can be 'exported' using phpmyadmin on your local machine and then 'imported' into the one on your server. I am sure there would be similar tools for the other databases, too.

Tell us what DB you are using and we'll help sort it out.  Razz
Logged
MWaqas
Pong! (the videogame) Master
*****
Offline Offline

Posts: 21



« Reply #3 on: February 10, 2011, 06:24:24 AM »

Yeap, the tutorial here http://wiki.lunarpages.com/Restore_MS_SQL_Database is perfect but it depends on the web-server you are hosted on cause different web-servers use different mssql servers; You can login using the following information:
1. Type in your database username and password.   
2. You must choose 'SQL Server Authentication'
3. Choose 'Options' and change the dropdown for 'Network Protocols' to 'TCP/IP'.
Once logged in please follow the Backup instructions below:
Backing up Database:
1. Log in, click on 'Tools'; 'Backup Wizard (Web Hosting)'
2. Select the database from the drop-down menu and choose a name for it where it says 'Set name'
3. Choose 'Backup' to continue
4. Within 5 minutes, it should backup your database and provide you with a link that you can use to download the new backup. It will be in .bak format.
If you find that you can no longer access the database with the user that you have setup, then you will need to login to Plesk, delete the user and set it back up. You will then be able to access it through MyLittleAdmin again.
Restoring Database:
1. Provide your own database backup in .bak format
2. Log in, click on 'Tools'; 'Restore Wizard (Web Hosting)'
3. Select the database from the drop-down menu and choose 'Browse' to upload the .bak file from your local computer
4. Choose 'Restore Database' to continue
5. A warning message will appear indicating the backup file is being uploaded and in the process of restore
6. If the restore is successful, another message will appear indicating restore has finished

If you are still unable to restore your mSSQL database let us know or provide us the backup in .bak format and we will do the rest for you; just reach us at windows@lunarpages.com  Grinning
Logged

Please do let us know if you have any further queries. You can directly contact us by sending an email to windows@lunarpages.com regarding your windows / asp.net hosting account.

Kindest Regards,
-M. Waqas
JSA-I, MCP,  MCTS
windows@lunarpages.com
System Adminsitration Team.
---------------------------------------------------------------------------------------
Shared Windows Support: windows@lunarpages.com
Dedicated Customer Support: dedicated@lunarpages.com
Helplines:
US / Canada 714-521-8150
International 714-521-8150
Membership Forum - http://www.lunarforums.com
Plesk Manual - The 'Help' section in Plesk CP, itself!
----------------------------------------------------------------------------------------
stelly
Newbie
*
Offline Offline

Posts: 1


« Reply #4 on: February 18, 2011, 02:02:19 AM »

No, you will either need to send your hosting company a backup to restore (if they allow this) or use the Database Import/Export Wizard to move your objects and data to the hosting company's server.  If they have the server open for outside access, such as Enterprise Manager or Query Analyzer, you should be able to do it through the transfer objects part of that wizard.



« Last Edit: February 18, 2011, 05:42:39 AM by katrina1 » Logged
MWaqas
Pong! (the videogame) Master
*****
Offline Offline

Posts: 21



« Reply #5 on: February 21, 2011, 07:41:27 AM »

Hello,

We don't allow remote connections to our MSSQL server so you wont be able to connect via Enterprise Manager; the only way you can manage your mSSQL databases is via MyLittleAdmin the tool we provide for the MSSQL database management.
Logged

Please do let us know if you have any further queries. You can directly contact us by sending an email to windows@lunarpages.com regarding your windows / asp.net hosting account.

Kindest Regards,
-M. Waqas
JSA-I, MCP,  MCTS
windows@lunarpages.com
System Adminsitration Team.
---------------------------------------------------------------------------------------
Shared Windows Support: windows@lunarpages.com
Dedicated Customer Support: dedicated@lunarpages.com
Helplines:
US / Canada 714-521-8150
International 714-521-8150
Membership Forum - http://www.lunarforums.com
Plesk Manual - The 'Help' section in Plesk CP, itself!
----------------------------------------------------------------------------------------
zaminur143
Newbie
*
Offline Offline

Posts: 4


« Reply #6 on: March 16, 2011, 10:06:12 PM »

Wow! I can imagine now what a lucky I am to read this post. As I am new here, it was necessary to know about some basic information, Thanks all.
Logged

Zaminur
Corey101
Space Explorer
***
Offline Offline

Posts: 7



WWW
« Reply #7 on: April 20, 2011, 09:05:00 AM »

Okay, I am a newbie!! and glad I made my way here to this post!! and glad for the detailed posts above! I think I can do this ! thanks guys!!
Logged

lonniefilkins
Pong! (the videogame) Master
*****
Offline Offline

Posts: 27


« Reply #8 on: February 24, 2012, 01:22:06 AM »

1) First ensure you are on one of our Plesk servers. Otherwise you should use Enterprise Manager or SQL Management Studio to remotely connect and import your data.
2) Login to your Plesk Control Panel
3) Go to Database option and create new database and user
4) Now create database dump (backup) of your local database. And create .bak file
5) Upload .bak file to /httpdocs folder of your website. (FTP upload)
6) Contact support and request that we restore your database with following details
a. Your domain name
b. .bak file name and path to access that e.g /httpdocs/mybackupfile.bak
c. MS SQL DB name
7) I will confirm the restore of your database when it is complete.


__________________
Ares Download
Logged

jeryjohn
Newbie
*
Offline Offline

Posts: 2


« Reply #9 on: March 05, 2012, 10:54:58 PM »

You can upload using phpmyadmin
Logged
Pages: [1]   Go Up
  Print  
 
Jump to: