Page 1 of 1

How to backup MS SQL database

Posted: Thu Oct 20, 2005 4:11 am
by tplowe
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.

Any suggestions.

Posted: Thu Oct 20, 2005 5:13 am
by MarkTheDaemon
Not sure;

I mainly work with MySQL


Mark

Posted: Thu Oct 20, 2005 12:58 pm
by tplowe
Yes, if I was on MySQL I could use phpAdmin.

Posted: Thu Oct 20, 2005 1:40 pm
by rakeshdx
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
by who_cares
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
by tplowe
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.