Backup msql2008

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
dx33
Posts: 2
Joined: Wed 26 Jan 2011 11:17

Backup msql2008

Post by dx33 » Tue 29 Jul 2014 14:54

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
Devart Team
Posts: 1057
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Backup msql2008

Post by azyk » Wed 30 Jul 2014 14:37

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

Post Reply