Need help in automating SQL Server Backup...!!! RRS feed

  • Question

  • Hi,
    I need help in setting up an automated backup for the sql server database. The scenario is as follwing:

    We have 2 sql servers: 1 development server & 1 production server. Now, we need to automatically trigger a backup process in the production server whenever an upload of table/stored procedure/udf is initiated by the local server to the production, prior to upload.

    Thanks in advance...

    Friday, May 20, 2005 11:43 AM


  • Have you looked at using SQL Server Agent and/or DTS/Integration Services to form a worklow?
    Friday, May 20, 2005 8:11 PM

All replies