database backup

• jac_bin

  Newbie

  Points: 4

  More actions

  September 17, 2002 at 4:28 am

  #79705

  how can I backup sql server database from my application.

• Prakash Heda

  SSCertifiable

  Points: 5539

  More actions

  September 17, 2002 at 4:44 am

  #436643

  Check: BACKUP, BACKUP (described) in BOL

  Prakash

  Prakash Heda
  Lead DBA Team - www.sqlfeatures.com
  Video sessions on Performance Tuning and SQL 2012 HA

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  September 17, 2002 at 7:45 am

  #436654

  Send a T-SQL string similar to this one to your server:

  Backup [your database] to disk='c:/mssql/backups/your database.bak'

  Gregory Larsen, DBA

  If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

  Gregory A. Larsen, MVP