Thanks Mohammed, I'll try that.
I disabled log shipping but cant back up the database because its in a warm standby stat and it "can't be backed up until the entire load...
I've got to copy a 600GB database.
I'm not able to restore the backup, (created by data protector which I've got to sort out with HP - and the good...
ok, thanks again
your solution worked perfectly, once I deciphered your reference to $$_cmdshell.
So why did you use '$$'?
thanks Mohammed, I'll give that a go.
I need some help to improve an automated refresh I've got.
I need a copy of an operational database that has extra indexes, so I've got a script...
Separate names with a comma.