Chaps,

I want to offer my users a backup routine from my application, which may or may not be on the same machine as SQL Server Express. My users are not SQL Server literate and as such I want to protect them from it as much as I can.

I have a routine from a while ago, that allows the application I have written to backup the SQL Server Express database that it uses. This routine was written for an application that ran on the same machine as SQL Server Express.

Is there any routine built into SF, that will undertake backup and possibly restore? If not, can you advise how I get the Microfour.Strataframe.DBEngine.SQL.SQLServerInfo structure populated? It has everything in it that I need to modify my existing application.

 Your advice, as always is appreciated.

regards

Geoff Hirst

Hi Geoff,

Sorry I can not offer any help on this one, but I am very interested in the results of this thread since I have an application that will be use by independent customers with MS-SQL-EXPRESS and a backup solution would be very good to have.

Edhy Rijo

I'm not sure either, but I'd lookup how to run a backup/restore in SQL Books online. I know it can be done via a script. The tricky part is likely that you'd need to specify a device to backup to that was relative to the machine SQL Server is located on. Once you know what the script is you can easily run it via a BO or just straight ADO.net.



The SF team uses SQL Management Objects (SMO) for the DDT, which allows for normal .NET programing to do these sorts of things. I'd investigate that also. Hopefully Ben or Trent will pipe in here and provide more specific info.