Automate restore

Question

Post reply

Automate restore

ramyours2003

SSChampion

Points: 12268
More actions
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

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

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

andreas.kreuzberg SSCertifiable Points: 6191 More actions · Answer 1

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

ramyours2003 SSChampion Points: 12268 More actions · Answer 2

SQL Edition is enterprise and version should be 2012.

homebrew01 SSC Guru Points: 55548 More actions · Answer 3

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.

Jeff Moden SSC Guru Points: 1004324 More actions · Answer 4

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)