SQL Desktop Engine 8.0

• cdun2

  SSCertifiable

  Points: 7893

  More actions

  February 24, 2003 at 2:03 pm

  #64573

  Hello,

  I have been looking for something I thought I once saw in BOL about backups and Recovery Models supported by the Desktop Engine, but I cannot seem to locate this information again.

  I need to set up a backup scheme for a server running Desktop Engine and need to know what the Recovery Model limitations are and backup limitations.

  Thanks.

  CSDunn

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  February 24, 2003 at 2:26 pm

  #449641

  1. Create SQL Script to backup the database

  2. Create a batch program to call OSQL.exe that will run the script created on step1.

  3. Schedule the batch program in system with AT command or job scheduler.

  MSDE supports up to 2GB in database size.

  Edited by - Allen_Cui on 02/24/2003 2:28:15 PM