Automate on demand backups

• sbligh

  Valued Member

  Points: 50

  More actions

  September 4, 2003 at 8:58 am

  #160757

  I have am trying to figure out a way to automate on demand backups in SQL Server without using Enterprise Manager. I want to have an application owner be able to run their own backups when they need to, but I don't want to give them any SQL Server tools. Is there any easy way to do this?

  Thank you,

  Susan

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738337

  More actions

  September 4, 2003 at 10:11 am

  #472613

  I'd build a table and have them insert a value in there. You can then check this table with some job that will run backups.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  http://www.dkranch.net

• robinhc

  SSCommitted

  Points: 1617

  More actions

  September 16, 2003 at 3:43 pm

  #474517

  Work out the TSQL for the backup and put it in a stored procedure that the user can run with little app?

• philcart

  SSC-Forever

  Points: 47797

  More actions

  September 16, 2003 at 5:00 pm

  #474527

  Setup an on-demand job in SQL Agent. Then just have the user app execute sp_start_job to run the job.

  Hope this helps

  Phill Carter

  --------------------

  Colt 45 - the original point and click interface

  --------------------
  Colt 45 - the original point and click interface