How to backup a database using Delphi?

How to backup a database using Delphi?

Post by Ulisses Oliveir » Sat, 22 Sep 2001 23:17:06



  Hello all there!
  I am developing a little management program, and I would
like to make an easy-way to make a backup of my database
in my own program. I am using the MS SQL Server 7.0 in the
Windows 2000 server of the network, and the clients are
Windows 98. I am programming using Borland Delphi 5.
  My objective: create a menu shortcut using Delphi to
make the operation that in the Enterprise Manager of MSSQL
7.0 is at the Databases general page named as "Backup
Database" (Backup Database - complete). All parameters
(database name, login and password, ...) are weel-known by
the program. For example, I would like there was a command-
line that I could pass to the Enterprise Manager
exceutable.
  Sorry for don't having so much experience to try solve
this by myself, and ever know if it is possible.

  Thanx everybody!

Ulisses Oliveira
Fortaleza - CE - Brazil.

 
 
 

How to backup a database using Delphi?

Post by Andrew J. Kell » Sat, 22 Sep 2001 23:33:54


If you want a command line then use BACKUP. If you want an object interface
use SQL-DMO. Both are well documented in BooksOnLine.

--
Andrew J. Kelly,  SQL Server MVP
TargitInteractive


Quote:>   Hello all there!
>   I am developing a little management program, and I would
> like to make an easy-way to make a backup of my database
> in my own program. I am using the MS SQL Server 7.0 in the
> Windows 2000 server of the network, and the clients are
> Windows 98. I am programming using Borland Delphi 5.
>   My objective: create a menu shortcut using Delphi to
> make the operation that in the Enterprise Manager of MSSQL
> 7.0 is at the Databases general page named as "Backup
> Database" (Backup Database - complete). All parameters
> (database name, login and password, ...) are weel-known by
> the program. For example, I would like there was a command-
> line that I could pass to the Enterprise Manager
> exceutable.
>   Sorry for don't having so much experience to try solve
> this by myself, and ever know if it is possible.

>   Thanx everybody!

> Ulisses Oliveira
> Fortaleza - CE - Brazil.


 
 
 

1. How to backup a database using Delphi?

  Hello all there!
  I am developing a little management program, and I would
like to make an easy-way to make a backup of my database
in my own program. I am using the MS SQL Server 7.0 in the
Windows 2000 server of the network, and the clients are
Windows 98. I am programming using Borland Delphi 5.
  My objective: create a menu shortcut using Delphi to
make the operation that in the Enterprise Manager of MSSQL
7.0 is at the Databases general page named as "Backup
Database" (Backup Database - complete). All parameters
(database name, login and password, ...) are weel-known by
the program. For example, I would like there was a command-
line that I could pass to the Enterprise Manager
exceutable.
  Sorry for don't having so much experience to try solve
this by myself, and ever know if it is possible.

  Thanx everybody!

Ulisses Oliveira
Fortaleza - CE - Brazil.

2. Q: how copy DB data w/2 .NET files?

3. rtrim problem

4. Error Code 11

5. Backup procedure for Delphi/Paradox or Delphi/Interbase

6. newbie filmaker 5.0 and database web publishing

7. Backup DataBase with Delphi 3.0

8. InterBase Database Backup from Delphi

9. Database backup / database File Backup

10. How to connect SQL 2000 Server Database when using Delphi

11. Database components using DB-Library for Delphi 2 and 3