Keith Devens .com - Weblog: Backing up a Microsoft SQL Server database from a shared host?

Saturday, August 28, 2004

Backing up a Microsoft SQL Server database from a shared host?

How the heck do you grab a backup of a Microsoft SQL Server database? All I want is an SQL export of all the tables (schemas and data) in the database, like I can get with phpMyAdmin's SQL export feature.

The host I'm trying to get this off of doesn't provide any kind of control panel for this, and the only way I can really access the server is through FTP and ASP. Why is this so hard? (Why anyone would choose to host on a Windows host -- besides ignorance -- is beyond me.)

Permalink | 1 Comment | Tags: Programming | id 5355

19:35 (utc-4)

Comments

There's a couple:

Nobody was ever fired for buying ~~IBM~~ Microsoft.
Sometimes, you don't have a choice: i.e. mise (me, that is: that's your first word of irish and is the emphatic form of mé, meaning, um, 'me').
Sometimes that's the company policy: see above.
Sometimes it's all you know.
And the rest, you actually like Windows.

∴ Keith Gaughan | 30-Aug-2004 6:59pm est | http://talideon.com/ | #5402

Feel free to post a comment below. Please see my comment policy.

Formatting Rules (No HTML):

**bold**, *italic*, _underlined_, --strikeout--
"text"="url" creates a link, and URLs are auto-highlighted
Blockquote: Like e-mail, begin paragraph with > (greater-than sign)
Lists: begin paragraph with *,-, or + (unordered), or # (ordered)
Code block: ?!code:language=perl|php|sql|javascript|etc.{\n}...{\n}?!/code

RSS feed RSS feed for Keith's Weblog
Atom feed Atom feed for Keith's Weblog
Weblog archive
Recent comments
on 3 posts