Post reply

Automate restore

  • May 31, 2021 at 2:41 pm

    #3890250

    Any one help to automate the restore of a database  from one server to another server through sql job

  • June 1, 2021 at 7:36 am

    #3890429

    Hi,

    if you like powershell, take a lock at:

    https://docs.dbatools.io/#Copy-DbaDatabase

    It is simple and easy to use.

    If you had to use SQL jobs, just give us more informations.

    SQL Server Versions,

    etc....

    Kind regards,

    Andreas

  • June 1, 2021 at 2:35 pm

    #3890591

    SQL Edition is enterprise and version should be 2012.

  • June 1, 2021 at 7:36 pm

    #3890695

    Create a job, which copies the backup file to the destination server. Then script out the restore process, and put that as the next job step.

    After the restore, you may have to drop and then add back SQL Logins and permissions for that database.

    If you provide more details, and the problems you're having, you might get more specific replies.

  • June 2, 2021 at 12:11 am

    #3890789

    You have been working with SQL Server for at least 12 years and 8 months according to your profile.  With that, you should know what I'm going to say... it's time to...

    TRY

    😀

    No.. I'm not trying to be mean or snarky and if it comes across that way, I apologize.  It'll help your career... TRY.

     

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

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

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