Backup msql2008

[dx33]

Hi,
How to create a full backup of my database with the component.
I have trying The dump and is not the ideal solution for me.
Thank you in advance for your answers.

[azyk]

You can create a full database backup using the TMSConnection SDAC component by executing the BACKUP DATABASE T-SQL command. For example:

Code: Select all

MSConnection.ExecSQL('BACKUP DATABASE ....');

More details about the BACKUP DATABASE T-SQL command can be found at MSDN:
http://msdn.microsoft.com/en-us/library ... lProcedure