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 |
|
peera
Starting Member
11 Posts |
 Posted - 2003-11-03 : 15:11:58
|
| Hi,can i use this xp_cmdshell command to copy .BAK files using ip address, if yes a example would be of much help, becoz one of my boxes in dmz.thxpeer |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-03 : 15:32:46
|
| Can you run COPY command to do the work in a cmd window? If yes, then you can use xp_cmdshell. If no, then your firewall is preventing it. EXEC master.dbo.xp_cmdshell 'COPY F:\MSSQL\BACKUP\*.BAK \\SomeServer\SomePath\'Tara |
 |
|
|
|
|
|
xp_cmdshell how to in DMZ