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 |
|
Jaybee from his castle
Yak Posting Veteran
64 Posts |
 Posted - 2006-05-11 : 07:54:05
|
| ...see the network drive? It's not offering me any choice as to network location!!Thanks in advance,Jaybee. |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-11 : 08:13:57
|
| Generally a bad idea to do to that way - better to backup locally and then move/copy the file to the LAN location.Your backup is probably being run by the SQL Service account - and that will have certain local, and network, permissions - so worth checking that that account has permissions for your target UNC.Kristen |
 |
|
|
Jaybee from his castle
Yak Posting Veteran
64 Posts |
Posted - 2006-05-11 : 09:52:57
|
quote:
Originally posted by Kristen
Generally a bad idea to do to that way - better to backup locally and then move/copy the file to the LAN location.Your backup is probably being run by the SQL Service account - and that will have certain local, and network, permissions - so worth checking that that account has permissions for your target UNC.Kristen
Hi Kristen,I've heard the same thing according to other answers on other boards, is there a way to automate the copy process??CheersJaybee. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-05-11 : 10:02:53
|
| You can use the ROBOCOPY.EXE command from XP_CMDSHELL. You can find ROBOCOPY witrh GOOGLE, it is a resource kit command.The thing it gives you is the ability to mirror a directory, and to automatically retry if there is a network problem.CODO ERGO SUM |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2006-05-11 : 14:12:34
|
| Robocopy - The ONLY way to copy large files and sync directories. I'm a BIG beliver in it.At a command prompt, do robocopy /?|more (assuming you've got robocopy installed). There are a LOT of command line options.You may want to look at Tara's script here and add come robocopy magic to it.http://weblogs.sqlteam.com/tarad/archive/2004/08/04/1876.aspxMichael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>Opinions expressed in this post are not necessarily those of TeleVox Software, inc. All information is provided "AS IS" with no warranties and confers no rights. |
|
|
|
DMcCallie
Yak Posting Veteran
62 Posts |
Posted - 2006-05-12 : 10:31:32
|
| Use UNC pathing to point to the location and name of your backup file. This also works for restores across the LAN...DeWayne |
|
|
|
|
|
|
|
|
Want to back up over LAN - how do I get SQL to...