Automate on demand backups

  • 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

  • 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

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

  • 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

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

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