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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Cross-Wan restores failing

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.
Go to Top of Page
   

- Advertisement -