|
Hi Everyone,
I have 2 servers running SQL Server 2014 which are in different location. Server 1 does not see Server 2 and vice versa. I have a shared drive where both servers can access. On server 1, I have created a backup job and the backup file is saved locally. I need to move the backup to the shared drive. And then, on Server 2, take the backup file and restore it. I need to automate the process.
Any help and solution is greatly appreciated.
Sal
|
|
|
|
|
Better don your asbestos suit. 
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
You are asking this in the wrong section. If I were you, I'd move it pretty sharpish.
BTW, have you bothered to try and figure out a solution on your own before asking other people to do your work for you?
|
|
|
|
|
Why would he want to do that?
He's far too important to get involved in mere implementation tasks!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
You need to post this question in the Database section, click the "click here to ask your programming questions" red highlighted link at the top of the page.
New version: WinHeist Version 2.2.2 Beta I told my psychiatrist that I was hearing voices in my head. He said you don't have a psychiatrist!
|
|
|
|
|
Member 12908552 wrote: Server 1 does not see Server 2
Well, if Server 2 is free, I have a client that would like to ask her out.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
I'm in the home stretch, the finale, the wrap-up...
Less than 4 hours before I take 3+ weeks vacation. I won't grace this office again until 10 Jan 2017.
How should I spend my last few hours here?
In this present crisis, government is not the solution to our problem; government is the problem. ~ Ronald Reagan
|
|
|
|
|
A) Gloating?
B) Spree killing marketing dweebs? (Otherwise known as Pest Control)
C) Eating?
D) Writing CP articles?
Or ... E) Doing documentation so you can pick it up again more easily in the New Year?*
* yes, yes - it was the joke entry
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Not to worry... our service department found something to keep me occupied.  
In this present crisis, government is not the solution to our problem; government is the problem. ~ Ronald Reagan
|
|
|
|
|
|
I'm down to the last hour... I'll. Try. To. Stick. It. Out.
In this present crisis, government is not the solution to our problem; government is the problem. ~ Ronald Reagan
|
|
|
|
|
|
I'm thinking that only works in Colorado where the snow is puffy and light.
Here in Ohio we have the heavy wet stuff that cannot be moved without major horse-power. 
|
|
|
|
|
raddevus wrote: that only works in Colorado where the snow is puffy and light.Here in Ohio we have the heavy wet stuff
Hmm... Obligatory oatmeal reference[^].
|
|
|
|
|
Seriously, it's -40 F and there's at least 4 feet of snow on the ground, by which I mean we have about 1 inch of snow and it's about 25 Fahrenheit. 
|
|
|
|
|
raddevus wrote: Here in Ohio we have the heavy wet stuff that cannot be moved without major horse-power.
Where in Ohio are you located?
|
|
|
|
|
southern Ohio so it's not as bad as Cleveland area.
|
|
|
|
|
Interesting, I am in central Ohio - not as bad as Cleveland obviously.
|
|
|
|
|
Ohio, the best state out of the 50.
Interesting that there is a CPer here in Ohio, I thought they were all across the pond or up in Canada. 
|
|
|
|
|
There's Gary Wheeler as well, he's in Dayton. Gary, Smitha (my wife), and I had a meetup a couple of years ago in Columbus. We should probably do another one next summer. Maybe there're more of us here, lurking, and occasionally coming out to post something vastly intelligent as Ohioians tend to do 
|
|
|
|
|
Nish Nishant wrote: occasionally coming out to post something vastly intelligent
Would it be rude of me to say that you're entitled to your opinion here?  
|
|
|
|
|
Hey!
|
|
|
|
|
Only 1 place snow belongs: in photographs.
Sin tack ear lol
Pressing the any key may be continuate
|
|
|
|
|
I have a steep sloped driveway. I can see it getting me down but not sure about back up. Maybe a Segway with some large tires.
John
|
|
|
|
|
You're in luck![^]
In this present crisis, government is not the solution to our problem; government is the problem. ~ Ronald Reagan
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
