Re: looking for script

nexus987_at_hotmail.com (Michael Green) wrote in message news:<2e5102f0.0208150608.3cfe0b6d_at_posting.google.com>...
> Yes, these are two different machines (but identical hardware & OS)
> about 100 miles apart... dumps are from a cold backup that is
> performed automatically each night.
>
> Basically I'm trying to duplicate the functionality that we have with
> our Sybase servers (where I can just "dump database foo to
> '/path/to/backup/file'" and on the remote server "load database foo
> from '/path/to/backup/file'").
>
> Seems like something people would want to do fairly often for disaster
> recover, development, and test servers...

If it is a cold backup, just copy over the files (dbf, control,redo, init) and startoff the database ... why do u need to change the sid ??

HTH
--Parag Received on Thu Aug 15 2002 - 16:43:44 CDT