Lunarpages Web Hosting Forum

Author Topic: Backup MSSQL database  (Read 3063 times)

Offline VideoGuy

  • Spacescooter Operator
  • *****
  • Posts: 45
Backup MSSQL database
« on: February 02, 2007, 07:15:39 PM »
I think I read in another thread where MyLittleAdmin could be used to upload and backup MSSQL databases. Where is the backup stored? If I select "file", what should I enter for the location? Can I download the backup to my local PC, modify it using SQL Server Express and then restore it to the LP server? If this is possible with MyLittleAdmin, I couldn't figure it out. Any help would be appreciated.

Thanks,
Ed

Offline perestrelka

  • Master Jedi
  • *****
  • Posts: 1397
Re: Backup MSSQL database
« Reply #1 on: February 02, 2007, 09:26:09 PM »
Hello,

Yes, it is possible to backup MSSQL database to your local PC using MyLittleAdmin. To do so, please follow these instructions:

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.

I hope this helps.
Kind Regards,
Vlad Artamonov

Offline VideoGuy

  • Spacescooter Operator
  • *****
  • Posts: 45
Re: Backup MSSQL database
« Reply #2 on: February 03, 2007, 04:50:54 AM »
What would be the steps to restore that file, or more importantly, to upload a new database that was created locally. Is that possible now or do we still have to upload to a folder and submit a support ticket to have the database added.

Also, what software do I need to open the .bak file locally?

Thanks for the quick response,
Ed
« Last Edit: February 03, 2007, 05:24:27 AM by VideoGuy »

Lupine1647

  • Guest
Re: Backup MSSQL database
« Reply #3 on: February 03, 2007, 06:05:35 PM »
Hello Ed:

To restore a database using MyLittleAdmin, do the following:


1. Customer must provide their 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

Offline VideoGuy

  • Spacescooter Operator
  • *****
  • Posts: 45
Re: Backup MSSQL database
« Reply #4 on: February 04, 2007, 04:13:17 AM »
Thanks RyanJ, I'll give that a try. I was able to successfully download the backup with the instructions given previously.

Does anyone know what software is required to open the backup file locally?

Thanks,
Ed

Offline boybawang

  • Spacescooter Operator
  • *****
  • Posts: 48
  • Whatever and ever...
Re: Backup MSSQL database
« Reply #5 on: February 05, 2007, 07:37:35 PM »
using enterprise manager or management studion express, create a blank database and use the Restore database feature to restore the bak file on the blank database
Our On-line Pet Community
Need web application solutions? Just send me a message.
Own me!

Offline boybawang

  • Spacescooter Operator
  • *****
  • Posts: 48
  • Whatever and ever...
Restore Feature does not work
« Reply #6 on: February 06, 2007, 05:29:13 AM »
The restore feature does not work because MyLittleAdmin did not include an option to overwrite the existing database
Our On-line Pet Community
Need web application solutions? Just send me a message.
Own me!

Offline VideoGuy

  • Spacescooter Operator
  • *****
  • Posts: 45
Re: Backup MSSQL database
« Reply #7 on: February 06, 2007, 05:33:23 AM »
using enterprise manager or management studion express, create a blank database and use the Restore database feature to restore the bak file on the blank database
I tried that but it fails with this message:

Quote
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Restore failed for Server 'xxxx\SQLEXPRESS'.  (Microsoft.SqlServer.Express.Smo)

System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'results' database. (Microsoft.SqlServer.Express.Smo)
------------------------------
In my test, I just created a new database that was empty but with the same name as the backup. Should I first create all the tables that the backup contains, or should it work without doing that?

Thanks for the help,
Ed

Offline VideoGuy

  • Spacescooter Operator
  • *****
  • Posts: 45
Re: Restore Feature does not work
« Reply #8 on: February 06, 2007, 05:36:53 AM »
The restore feature does not work because MyLittleAdmin did not include an option to overwrite the existing database

I guess we were writing at the same time.

So are you saying that there is no user controlled restore available through MyLittleAdmin? If so, do we then have to rely on LP backup/restore services?

Thanks,
Ed

Offline VideoGuy

  • Spacescooter Operator
  • *****
  • Posts: 45
Re: Backup MSSQL database
« Reply #9 on: February 06, 2007, 05:42:12 AM »
Update to my previous post re: unable to restore.

I tried again, this time checking the "overwrite existing database" box and it worked. Doesn't do much good though if we can't restore it to the LP server.

Offline boybawang

  • Spacescooter Operator
  • *****
  • Posts: 48
  • Whatever and ever...
Re: Backup MSSQL database
« Reply #10 on: February 06, 2007, 05:42:53 AM »
Yes, the only option is to rely on LP :D
I've tried everything, I just cannot copy my local db to the live one  :cry:
Our On-line Pet Community
Need web application solutions? Just send me a message.
Own me!

Offline boybawang

  • Spacescooter Operator
  • *****
  • Posts: 48
  • Whatever and ever...
Re: Backup MSSQL database
« Reply #11 on: February 06, 2007, 05:45:21 AM »
hmm, what did you use Restore Wizard or Restore Wizard(Web Hosting)?
Because Restore Wizard(Web Hosting) does not have an overwrite option, at least on my panel
Our On-line Pet Community
Need web application solutions? Just send me a message.
Own me!

Offline VideoGuy

  • Spacescooter Operator
  • *****
  • Posts: 45
Re: Backup MSSQL database
« Reply #12 on: February 06, 2007, 05:51:23 AM »
I was restoring a LP backup on my local machine using Management Studio Express. I haven't tried doing a restore through MyLittleAdmin yet. I guess it doesn't surprise me that they disable that option since they won't allow remote connections.

Offline boybawang

  • Spacescooter Operator
  • *****
  • Posts: 48
  • Whatever and ever...
Re: Backup MSSQL database
« Reply #13 on: February 06, 2007, 05:59:17 AM »
Yeh, I agree. The restore feature would not do any good if it did not have an "overwrite existing db"  option
Our On-line Pet Community
Need web application solutions? Just send me a message.
Own me!