Question:
How can I generate backup for the Database recorded in the SQL Server via E3?
Solution:
To do so, you must access E3Studio, create a Query linked to the Database and edit it with the Backup Database command.
For example (query called Query1 with a backup SQL command to be saved at C:\Backup\test.bak):
BACKUP DATABASE [DatabaseName] TO DISK = ‘c:\Backup\test.bak’
Then, you must create a script to run this Query via Execute() method. For example, the script below is being executed in the Click event of a button that is on screen:
Screen.Item(“Query1”).Execute()
To view the created backup file, you must restore it via SQL Server.