RESTORE

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
maciejw
Posts: 11
Joined: Sun 20 Mar 2005 10:37
Location: Poland
Contact:

RESTORE

Post by maciejw » Wed 08 Jun 2005 07:36

How can I implement database RESTORE funcionality using SDAC components ?

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Thu 09 Jun 2005 12:39

It is enough to execute RESTORE command in commom way by TMSSQL or TMSQuery.

Javan_Soft
Posts: 15
Joined: Wed 15 Jun 2005 09:43

Post by Javan_Soft » Wed 15 Jun 2005 12:01

It is enough to execute RESTORE command in commom way by TMSSQL or TMSQuery.
how?

and what about backup

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Wed 15 Jun 2005 14:06

> how?

According to RESTORE command syntax a query is generated as it said in documentation for MS SQL Server. Then write it in SQL property and execute using Execute method.

> and what about backup

Just as RESTORE.

Javan_Soft
Posts: 15
Joined: Wed 15 Jun 2005 09:43

Post by Javan_Soft » Sat 02 Jul 2005 04:57

Tanx For Help

Post Reply