Investigate the SQL-DMO (Distributed Management objects)

This is the API that  Enterprise manager itsself uses to manage databases

There is is a "Backup" obejct that will allow you to backup a SQL server
database in about 5 lines of code

Cheers
Matt
----- Original Message -----
From: "Richard Landi" <rslandi@a...>
To: "professional vb" <pro_vb@p...>
Sent: Wednesday, March 12, 2003 10:29 PM
Subject: [pro_vb] Re: Sample Coding


> > Hi all,
>
> does anyone have a sample coding in VB6
> which backup SQL Server database ?
>
> i do not allow user to use SQL Server Enterprise manager,
> so i decided to make an option to backup/restore the database
> in my current client/server application.
>
> TQ in advance.
>
> Hey There,
>
> I think I can get you what you want.
> Assuming SQL Server is installed on your machine, there is some sample
> code at:
> C:\Program Files
> \Microsoft SQL Server\80\Tools\Devtools\Samples\Sqldmo\Vb\BackRestEvents
>
> I hope this helps.
>
> Richard
>
>