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
>