标题: remote backup [打印本页] 作者: oramind 时间: 2002-01-09 04:02 标题: remote backup i know i\'ve asked this before on oracle forum i think, but still didn\'t give up.
is it possible to do a remote backup?
details:
box A: sql 7 server.
box B: sql 7 client.
running query analyzer from box B, connecting to box A via internet.
is it possible to backup a database from box A to local file system on box B, without netbeui and sharing folders from box B?
i am looking for something like export in oracle. any trick?作者: xmmhacker 时间: 2002-01-09 12:17
Ok, u can run the backup database DDL statment in SS Query.
And u can also run the xp_cmdshell \'dir c:\\\' to see the fold in SERVER B. 作者: oramind 时间: 2002-01-12 03:51
but directories are related to box A, not box B, unless i share directories from box B?作者: snowhite2000 时间: 2002-01-12 06:25
why didn\'t you use ENTERPRISE MANAGER. You can backup any database to locally hard disk or network hard disk. You may need to map your B server\'s hard disk driver to A server.
otherwise, you have to use third party software via name pipe.
