Hi everyone,

I have a little problem with my overpriced hosting comany in that they seem to not want to give me a database backup of my DNN installation (despite many 'support tickets' etc). Maybe they've figured out that I want to transfer away :)

So I thought I'd be clever with my FTP access and 'moved' certain parts of the DNN installation out the way, and uploaded a .NET 2 application called SQLWebAdmin onto my server for a short while and was able to run it and download an export file.

Trouble is, when I try to import this into my local SQLExpress2008 using SSMS there are multiple errors in 'The conversion of a varchar data type to a datetime data type resulted in an out-of-range value' and then 'The ALTER TABLE statement conflicted with the FOREIGN KEY constraint xxxx' ; when I run SQLWebAdmin locally (can browse 2008 OK after installing the 2005 compatibility pack) and select the export file to import, the app seems to crash with "The connection to the server was reset while the page was loading" as soon as I press the Import button. there seems to be a disclaimer that any DB created or modified outside SQLWebAdmin may not import properly - maybe this is the problem.

Anyway thats where I am at the moment and wondered if anyone had either:

1. solved these problems with SQLWebAdmin before

or

2. Can suggest something more reliable (and free) that I can upload onto my hosting filesystem and use to create a backup of my DNN database. I don;t think I can remotely connect using SSMS which of course would be ideal, though I havent tried, not sure how I would go about finding if this is enabled, and how I'd connect.

Any suggestions to get me out of this situation very much appreciated...thanks

Rob