Page 1 of 1

Backup msql2008

Posted: Tue 29 Jul 2014 14:54
by 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.

Re: Backup msql2008

Posted: Wed 30 Jul 2014 14:37
by 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