SQL backup/restore Schedule Job

Posted on 2012-09-10
Last Modified: 2012-09-25
I need help creating a scheduled backup job for SQL and a restore job as well.

Here is the name of the database that needs backed up Service.  I need that backed up then once backed up I need it to Delete ServiceTR database and then do a restore of Service database as ServiceTR.  Any help would be great.
Question by:HB-IT
    LVL 25

    Accepted Solution


    Author Comment

    can you express it how I need it done not sending me a link to some other answer.  That does not work for me.

    I need a backup of Service
    Delete ServiceTR
    Restore Service as ServiceTR
    this all needs to be a schedule job.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    Many developers have database experience, but are new to PostgreSQL. It has some truly inspiring capabilities. I have several years' experience with Microsoft's SQL Server. When I began working with MySQL, I wanted a quick-reference to MySQL (htt…
    Viewers will learn how the fundamental information of how to create a table.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now