Web Hosting Forum | Lunarpages
News: November 3, 2008 - Enter Your URL in to WIN the November Site of the Month Award!
 
*
Welcome, Guest. Please login or register.
Did you miss your activation email?
November 18, 2008, 07:56:57 AM


Login with username, password and session length


Pages: [1]   Go Down
  Print  
Author Topic: Restoring Sql Server DB from backup  (Read 125 times)
stephen2d
Newbie
*
Offline Offline

Posts: 3


« on: October 07, 2008, 03:04:53 PM »

Hi guys,

I am in the process of moving my site to Lunarpages, which includes moving our existing Sql Server DB.
I got a decent hosting plan here, got the guys from the support team to create a testing subdomain (I want to make sure everything is working fine before I hit the switch for good), but have hit the trouble in moving my database across - which is the heart of the website!

I went to plesk, clicked on Create new database and checked the "restore from back up" option and entered all appropriate details. The BAK file is quite big, so I made sure the "Loading in progress" was ticking, went to bed and in the morning found the "Log in " page of the Plesk on the screen, no database created - no other message displayed. Just like nothing has happened.

So - please help. How on earth do I move my DB across? Is there any other way? Should I create an empty DB and somehow FTP my BAK file and restore it from LP's local drive (if that is possible) or any other way??
Logged
katrina1
Support Supervisor
Über Jedi
*****
Offline Offline

Posts: 2074



WWW
« Reply #1 on: October 07, 2008, 11:46:50 PM »

You need to use MyLittleAdmin to restore the database. What server are you on or what is your primary domain name? How big is the file you are restoring?
Logged

Hey, Rocky! Look. Nothing up my sleeve... presto a rabbit!

Lunarpages Web Hosting

Lunarpages Forums

Lunarpapages Affiliate Program
stephen2d
Newbie
*
Offline Offline

Posts: 3


« Reply #2 on: October 08, 2008, 01:09:31 AM »

I am using Plesk to upload BAK file and restore from there. The BAK file is around 85 megs. I just realised that my session times-out before the upload is done. I will try using MyLittleAdmin, but not sure if this will fix it.

Can I make sessions longer at least?
Logged
stephen2d
Newbie
*
Offline Offline

Posts: 3


« Reply #3 on: October 17, 2008, 03:26:28 AM »

BTW, this has been resolved. Left it all night and worked nicely in MyLittleAdmin
Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.6 | SMF © 2006-2008, Simple Machines LLC

Valid XHTML 1.0! Valid CSS! Dilber MC Theme by HarzeM