Backups.

When webhosts are less than helpful...

[Gibble]

So, unfortunately, we have a SQL Server 2000 database on a hosting plan, the only access to it is through a stripped down version of myLittleAdmin...with the backup option absent. The Webhosts CP has nothing for backing up the SQL Server database.

Is there a php or asp, or sql script around that will allow me to backup my tables, data, procs, and views?

I'd like to be able to get a copy of this db on my laptop for development purposes.

...I really hate this webhost...

Thanks,
Gibbs.

[physics]

You might be able to use phpMyAdmin for this:
[phpmyadmin.net...]

[FalseDawn]

phpMyAdmin is for MySQL, not SQL server 2000.

A little more info would help. Do you have root access? shared or dedicated?
Really, a hosting account that doesn't provide you with the means to backup a database either through the CP or the command line is not good. There's no reason why backing up a database should be disabled in MyLittleAdmin - I'd ask your host to enable it.
If you can open an interactive SQL prompt, the BACKUP DATABASE command can probably be used as well.

[Gibble]

I eventually recreated all the tables, procs, and views by hand...then found a script called sp_generate_inserts (google for it) to get the data.

[edited by: Gibble at 2:33 pm (utc) on July 25, 2006]