Options

SQLDMO like objects.

neilmcseneilmcse Posts: 8
edited July 3, 2006 2:19PM in SQL Backup Previous Versions
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
· Share on Twitter

Comments

  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • Options
    neilmcseneilmcse Posts: 8
    blast. Thanks anyway

    *let the rewrites begin!*

    N
    · Share on Twitter
Sign In or Register to comment.