Backup routine

Question

How can you write a routine for a user to backup an SQL DB that has a dbo extension?

Bechir Bejaoui · Answer

Its depends of the situation. I mean the nature of the application and the platform where it is installed. All that I can say in this generic situation is that you can add an Installer class to your project before creating a deployment projet for it. In that installer you can add custom program to allow user add parameters during the installation like credentials. Of Corse, this is necessary only when the application needs parameters to be set in oder to process correctly http://msdn.microsoft.com/en-us/library/system.configuration.install.installer.aspx

David Alderman · Answer

Thanks. The problem is I'm building this program so I can market and sell it. So would this work on another person's computer if they installed my program?

Bechir Bejaoui · Answer

Hi david, If you want to create a routine like backup data base or do any other task periodically, then you have to use a scheduled job, Of Corse If you have the right pemission to start the sql server agent. If you open an SQL instance using Sql server management studio Under the Sql server agent node you will find some folders, you are concerned by the first one which is Jobs. You right click it and you select new job. A dialog box will appear, you have to define a a job step http://msdn.microsoft.com/en-us/library/ms187910.aspx that holds an SQL statment and you define a schedule to that job inorder to be peiodically fired http://msdn.microsoft.com/en-us/library/ms191439.aspx