Hi Bo

I tested the following about a year ago. It worked fine but you need to
write a script to automate this and our DBA's decided it is easier to
restore the NT dump of the database to the target server and then refresh
it.

If you want to know anything about this procedure please contact me.

 <<PROCEDURE TO REFRESH PHOENIX DATABASE ONTO DATAWH.doc>>




Johan Gouws
Johang AT hollard.co DOT za <mailto:Johang AT hollard.co DOT za>

        -----Original Message-----
        From:   Bo Nielsen [SMTP:Bo_Nielsen AT FDB DOT DK]
        Sent:   Wednesday, October 27, 1999 8:19 AM
        To:     ADSM-L AT VM.MARIST DOT EDU
        Subject:        SV: SQL restore from another node......

        Chris,

        It's not only the TEMPDB, it's all the databases.

        Bo Nielsen

        FDB data                                    Phone: +45 4386 4671
        Roskildevej 65                             Fax:     +45 4386 4990
        DK-2620 Albertslund                    E-mail: bo_nielsen AT fdb DOT dk
        Denmark


        > ----------
        > Fra:  Chris Zaremba[SMTP:zaremba AT US.IBM DOT COM]
        > Svar til:     ADSM: Dist Stor Manager
        > Sendt:        26. oktober 1999 14:45
        > Til:  ADSM-L AT VM.MARIST DOT EDU
        > Emne:         Re: SQL restore from another node......
        >
        > Bo,
        >
        > The problem is that tempdb is never backed up.  SQL 7 does not
allow
        > tempdb to
        > be backed up so you should not try to restore it.
        >
        > Chris Zaremba
        > TDP Client (formerly ADSM Agent) Development
        > internet  zaremba AT us.ibm DOT com
        >