I am using MySQL Administrator to remotely back up my MySQL databases, which works well. What is the best way to back up a MSSQL database, I have tried using Microsoft SQL Server Management Studio Express but it does not seem to allow you to do a remote backup. What do other people use? Regards
It's probably easiest if you use the export feature in sqlwebadmin. The backup feature in SQL Server itself is no good for you because we have to disable it for security reasons, and even if we didn't disable it, all it would do is make a backup onto the servers hard disk - where you would have no way to get to it. The best way is probably to setup SQL Server on your PC (SQL Server Express is free) and copy the data between them using Management Studio as a backup. Hope this helps
Just to add to this I'm curiouse how others are working between their dev, testing and live environments. How are people comparing data on each and moving changes across. I know there are tools out there that allow you to do this but can anybody tell me what they use if anybody does this at all. I keep adding so much to live that my dev/testing and live are always out of synch, I have to start a fresh it would be good to add everything in testing and then move it live.
this looks like it will do the trick. http://weblogs.asp.net/scottgu/arch...e-to-a-remote-hosting-environment-part-1.aspx
Highly recommend this tool been using it to back my databases local and on the csnewmedia server, seems to work like a treat - what I've wanted for ages you can back-up the entire database including data. Does give some exception when using membership and roles but over all pretty good. I'd like to know what other people think?
