Yes, we do this also. Works good for us too.

Nathan

        -----Original Message-----
        From:   Michael Bartl [SMTP:michael.bartl AT ZENTRALE.ADAC DOT DE]
        Sent:   Monday, September 13, 1999 9:23 AM
        To:     ADSM-L AT VM.MARIST DOT EDU
        Subject:        AW: Backing up SMS server

        Matt,
        as an SMS server i based on an MSSQL database your task is to backup
such an
        MSSQL database. 
        Now this database is usually very small so it doen't make much sense
to use
        the ADSMConnect agent for MS SQL databases. Instead simply use the
builtin
        function of the SQL server to online dump the database into files.
Exclude
        the database devices (usually the files in ?:\mssql\data\...\*) from
your
        backup and save the daily created dumps instead. Be sure to also
export the
        exact layout of the MASTER table as you have to recreate all devices
prior
        to being able to restore them later.

        Regards,
        Michael

        -----Ursprüngliche Nachricht-----
        Von: Miller, Matthew A CPC31 [mailto:Matthew.Miller AT CIGNA DOT COM]
        Gesendet am: Montag, 13. September 1999 15:43
        An: ADSM-L AT VM.MARIST DOT EDU
        Betreff: Backing up SMS server

        Are there any special requirements, (agent code or other) to use
ADSM in
        backing up an SMS server?

        Thanks for all advice
        Matt