SQL Server programmatic backups

Egdif

Delphi Developer

Mon, 22 Sep 2003 18:25:49 GMT

SQL Server programmatic backups

How can I invoke the SQL Server backup engine programmatically within a
Delphi app. Ideally, I'd like to backup a database on a web server to a
local server overnight. If this is not possible, has anyone used DTS to
transfer data between two SQL Server's, or maybe programatically invoking
the replication services?

Guidance most gratefully received,
Ben Fidge

ben.fi...@stylusnet.com

NewsJ

Delphi Developer

Mon, 22 Sep 2003 21:04:14 GMT

Re:SQL Server programmatic backups

Quote

"Egdif" <ben.fi...@stylusnet.com> wrote in message

news:hMXy6.29437$NS2.59906@NewsReader...

Quote

> How can I invoke the SQL Server backup engine programmatically within a
> Delphi app. Ideally, I'd like to backup a database on a web server to a
> local server overnight. If this is not possible, has anyone used DTS to
> transfer data between two SQL Server's, or maybe programatically invoking
> the replication services?

I use SQL Anywhere/Delphi combination to do backup
and reload of DB so if you think it can help you just say...

Mario

Quote

> Guidance most gratefully received,
> Ben Fidge

> ben.fi...@stylusnet.com

William Or

Delphi Developer

Tue, 23 Sep 2003 21:14:45 GMT

Re:SQL Server programmatic backups

Have a look at the article on SQL Server DMO on www.delphizine.com (go to
features and search for DMO) It describes using the SQL Server COM
interfaces to implement custom management functions.

Quote

Egdif wrote in message ...
>How can I invoke the SQL Server backup engine programmatically within a
>Delphi app. Ideally, I'd like to backup a database on a web server to a
>local server overnight. If this is not possible, has anyone used DTS to
>transfer data between two SQL Server's, or maybe programatically invoking
>the replication services?

>Guidance most gratefully received,
>Ben Fidge

>ben.fi...@stylusnet.com

Other Threads

1. backup on MS SQL Server 7.0 to tape

2. How to start and wait for a SQL Server backup from Delphi

3. MS SQL Server BACKUP & RESTORE

4. Seagate Backup Exec Agent for MS SQL Server

5. Transportable Backup with SQL-Server

6. Programmatic update of MS SQL database over internet

7. Connection between SQL Server 7.0 on win98 and SQL Server 7.0 on Win2000 advanced server

8. SQL 6.5 Backup into SQL 7.0

9. SQL Server 6.5 x SQL Server 7

10. How do I connect to a remote SQL server running SQL Server 7