KB-29591: Generating SQL Database backup via E3.

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.

Print Friendly, PDF & Email

Este artigo foi útil? Was this helpful?

Classificação média - Average rating 0 / 5. Count: 0

Deixe seu Comentário

Seu endereço de e-mail não será publicado. Campos marcados com asterisco são obrigatórios *