Hi
I am having a few issues at the moement with my DNN site and these problems have made me realise that I need to periodically download my database for backups and for development tasks. I host with IHostASP.net which provide the rather limited online SQL server 2005 enterprise manager. I am currently using SQL server express 2005 and SQL server express management studion locally and need to be able to download my SQL Server 2005 database from IHostASP.net to my local installation of SQL Server Express.
Or at the very least connect via SQL Server Express Management studio to my SQL Server Express database on IhostASP.net. Now I keep reading that I can connect to remote hosts using SQL Express management Studio but I just cant seem to figure out how!
I assume that once I connect via this method I could create a local copy and/or undertake some database management tasks such as shirking the database ect.
Which leads me on to my second problem. My online SQL Server 2005 database appears to be 350mb and the .bak of my local SQL Server Express database that i sent them when they set my site up was only about 25MB. I have since then only had about 100 users signup so I presume that the database needs so work on it. i suspect that the database growth amount is set to large.
Basically, it would be useful for me to be able to work locally, upload my new database once the developement work has been done and change the web.config each time if that makes sense.
Any ideas or tutorials. i have seen a couple that appear to be one way, i.e. how to publish your sql express database to your host but not each way. And does one connect via sql express managment studio to my hosted sql server 2005 database
Thanks for any assitance in advance