MSDE Backup

  • Have had MSDE installed, new to me! Have been requested to do a backup of the database to Email, to our software supplier.

    Does anyone know how to do this?

    NTWH


    NTWH

  • right click on the database and go to all tasks, then backup db

  • From DOS.

    C:\OSQL.exe -Syourservername -E

    Once you login to SQL Server, Run following statemnet.

    >backup database yourdbname to disk = 'c:\temp\yourdbname_date.bak'

  • sorry,

    I forgot MSDE does not have a SQL interface

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply