Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jake Shelton
Yak Posting Veteran
74 Posts |
 Posted - 2012-04-01 : 17:42:17
|
| Hi all,Recently we had some issued that involved us backing up a DB locally, copying the .bak files across a WAN to a secondary data-centre, then restoring, each process being manual.What I'd like to do is to encapsulate the three steps into a single procedure, however on a couple of occasions the restore has failed to copy the .bak files across successfully (about 35gb in size).Two questions; in your experience is it feasible to centralise the three into one procedure?Secondly, am I correct in assuming SQL hands the copy step to Windows? If so, I'm mystified as to why manual copies (in Explorer) succeed every time, but not always when handled by SQL Server. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-04-02 : 15:41:04
|
| Don't restore over the WAN. Copy the file, then restore locally. |
 |
|
|
|
|
|
Cross-Wan restores failing