Page 1 of 1
How to backup MS SQL database
Posted: Thu Oct 20, 2005 4:11 am
I need to back up my database to a local drive but the server doesn't seem to want to allow this. I'm on Ready Host MS SQL server. I've tried some evaluation software but nothing seems to work.
I've heard I can try Microsoft SQL 2000 Devolper Editon.
Posted: Thu Oct 20, 2005 5:13 am
I mainly work with MySQL
Posted: Thu Oct 20, 2005 12:58 pm
Yes, if I was on MySQL I could use phpAdmin.
Posted: Thu Oct 20, 2005 1:40 pm
mysql is the best and most of all its FREE.... you can shift the databases from MSsql to MYSQL if you want..
Posted: Thu Oct 20, 2005 3:20 pm
do you have anything similar to phpmyadmin, where you could export the db?
and have you tried the backup option in the ACP?
Posted: Thu Oct 20, 2005 7:53 pm
When I try the backup option in the ACP I get this message "Sorry, but database backups are not currently supported for your database system." I think it is the MS 2000 SQL DB at Ready Host that causes this problem. I think the only way to back it up to my local drivve is with "Microsoft® SQL Server™ 2000 Developer Edition" which can be purchased pretty cheaply. I just wondered if anyone had tried it or if something else would do the job.
From the lack of replys here it doesn't seem that many people know the answer.