is it possible to backup sql server db with vb.net script????

• Morne-211576

  SSC Veteran

  Points: 217

  More actions

  September 28, 2005 at 6:31 am

  #87851

  let me correct my self. i want to backup my sql db from within my vb program, so the sql to backup you db is ROLLBACK, dono.

  what wil the syntaq be to make a backup of the db and is is possible if the db is active(open).

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  September 28, 2005 at 6:46 am

  #593630

  ?!?!?!? IF I understand the question "I want to have VB.Net manage SQL backups" THEN the answer is Yes you can.

  WHY you want to is another matter.

  Research SQL-DMO for more information in BOL.

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net