News
: November 3, 2008 -
Enter Your URL in to WIN the November Site of the Month Award!
Home
Help
Search
Calendar
Login
Register
Welcome,
Guest
. Please
login
or
register
.
Did you miss your
activation email?
November 18, 2008, 07:59:26 AM
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
Web Hosting Forum | Lunarpages
>
Lunarpages Web Hosting - Advanced Assistance
>
Web Management
>
Restoring Sql Server DB from backup
Pages: [
1
]
Go Down
« previous
next »
Print
Author
Topic: Restoring Sql Server DB from backup (Read 126 times)
stephen2d
Newbie
Offline
Posts: 3
Restoring Sql Server DB from backup
«
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
Posts: 2074
Re: Restoring Sql Server DB from backup
«
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
Posts: 3
Re: Restoring Sql Server DB from backup
«
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
Posts: 3
Re: Restoring Sql Server DB from backup
«
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
« previous
next »
Jump to:
Please select a destination:
-----------------------------
Lunarpages Web Hosting - Information & Opportunities
-----------------------------
=> Lunarpages Web Hosting - Announcements
=> Lunarpages Web Hosting - Hosting Plans & Site Information
=> Job Opportunities at Lunarpages Web Hosting
=> Lunarpages Web Hosting - Network Information
=> Lunarpages Web Hosting - Server Information
-----------------------------
Lunarpages Web Hosting - Before Signing Up
-----------------------------
=> Lunarpages Web Hosting Plans - Pre-Sales Questions
-----------------------------
Lunarpages Web Hosting - Online Help Desk
-----------------------------
=> Lunarpages - Webhosting Help
=> Lunarpages - Beginner Assistance
=> Lunarpages - How to's
=> E-mail with your Lunarpages Hosting Plan
=> Lunarpages - CPanel Help
=> Lunarpages - LPCP Beta
=> Lunarpages - Ecommerce Hosting
=> Lunarpages - FrontPage
=> Lunarpages - DreamWeaver
=> Lunarpages - Spanish Questions (Preguntas en español)
=> Lunarpages - Message Boards-Forums-Fantastico Scripts
===> Lunarpages - Joomla / Mambo
-----------------------------
Lunarpages Web Hosting - Advanced Assistance
-----------------------------
=> Web Management
=> Lunarpages - Webdesign and HTML
=> Lunarpages - Search Engine Optimization
=> Lunarpages - Animation & Flash
=> Lunarpages - Graphics
=> Lunarpages - Web Hosting, Email & PC Security
=> Lunarpages - Dedicated Web Hosting
===> Lunarpages - cPanel & WHM
===> Lunarpages - General
===> Lunarpages - Plesk
===> Lunarpages - Security
===> Lunarpages - Tutorials
===> Lunarpages - Webmin
=> Lunarpages - Reseller Web Hosting
===> Lunarpages - WHM
=> Lunarpages - VPS Hosting
=> Lunarpages - SharePoint Services (Beta)
-----------------------------
Lunarpages Web Hosting - Coding
-----------------------------
=> Lunarpages - ASP
=> Lunarpages - C++ / PERL / CGI
=> Lunarpages - PHP & MySQL
=> Lunarpages - Java Applets & Javascript
=> Lunarpages - JSP & Servlets
=> Lunarpages - Ruby Hosting
=> Lunarpages - Windows Development & Hosting
-----------------------------
Lunarpages Web Hosting - Entertainment
-----------------------------
=> Lunarpages - Chat & Stuff!
=> Lunarpages - Contests
=> Fun at Lunarpages!!
=> Lunarpages - Online Gaming
-----------------------------
Lunarpages Web Hosting - General
-----------------------------
=> Social Networking
=> Lunarpages Free Web Hosting - Education Program
=> Lunarpages - Affiliate Program
=> Introduce Yourself to the Lunarpages Forum Community!
=> Your Websites & Creations at Lunarpages!
=> Lunarpages Website of the Month
=> Lunarpages - Service and Trade
Loading...