SQLDMO like objects.

neilmcse · July 3, 2006 11:25AM

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 · July 3, 2006 1:00PM

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 · July 3, 2006 2:19PM

blast. Thanks anyway

*let the rewrites begin!*

N

SQLDMO like objects.

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk