How to backup MS SQL database

The 2.0.x discussion forum has been locked; this will remain read-only. The 3.0.x discussion forum has been renamed phpBB Discussion.
Locked
tplowe
Registered User
Posts: 40
Joined: Mon May 09, 2005 3:50 am

How to backup MS SQL database

Post 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.
MarkTheDaemon
Former Team Member
Posts: 2770
Joined: Thu Oct 20, 2005 2:42 am
Location: United Kingdom
Name: Mark Barnes

Post by MarkTheDaemon »

Not sure;

I mainly work with MySQL


Mark
tplowe
Registered User
Posts: 40
Joined: Mon May 09, 2005 3:50 am

Post by tplowe »

Yes, if I was on MySQL I could use phpAdmin.
rakeshdx
Registered User
Posts: 4
Joined: Tue Oct 18, 2005 8:55 pm

Post by rakeshdx »

mysql is the best and most of all its FREE.... you can shift the databases from MSsql to MYSQL if you want..
who_cares
Registered User
Posts: 5106
Joined: Fri Jan 14, 2005 11:04 pm
Location: ATL
Contact:

Post 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?
tplowe
Registered User
Posts: 40
Joined: Mon May 09, 2005 3:50 am

Post 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.
Locked

Return to “2.0.x Discussion”