SQLDMO like objects.

neilmcse

I have a home made vb app that uses direct calls to the SQLDMO.Backup objects. Is there something similar I can use with SQLBackup? What objects/methods/properties are available as nothing readily appears in the help files? Any help would be greatly appreciated so I don't have to rebuild my app from the ground up.

specs:
SQLBackup 4.2.0.425
SQL Server 2000 sp4
Windows 2000 Advanced Server sp3 (32bit)
4gb RAM
Quad 900Mhz P3 processors

Neil MacMurchy
Sr. DBA

petey

SQL Backup does not expose its functionality via an Automation Object. You would need to use the extended stored procedures to run any backup or restore commands, perhaps via the ADODB connection/recordset objects.

neilmcse

blast. Thanks anyway

*let the rewrites begin!*

N