Is ASE server working without tempdb?

I want to mirror the tempdb on Unix box.

I think I have to drop it the re-create it with disk mirror

Please advise ASAP

"Shawn" <farzan_toronto101 (AT) yahoo (DOT) com> wrote

First, you cannot drop tempdb.
Apart from that, disk mirroring applies to database devices, and therefore
to databases that are (partly) located on a mirrored device; mirroring does
not apply to databases directly.
In any case, using Sybase's software-based disk mirroring will slow down the
device I/O. For tempdb, this is perhaps not what you want.

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase Replication Server Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"

mailto:rob (AT) YOUR (DOT) SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

Hello Shawn,

Are you wanting to move tempdb or just mirror it? Use hardware
mirroring if available. SYBASE disk mirroring does only apply to
devices but can be used effectively to move devices around. Hopefully
you segregate your databases on individual devices and do not mix
them, especially tempdb. This makes for easier management.

You can "drop" tempdb devices EXCEPT for the fragment contained on the
master device. See the write-up in the manual under: "How to Reduce
the Size of tempdb" in the "Troubleshooting and Error Guide".


Cheers,

Sara ...

"Rob Verschoor" <rob (AT) DO (DOT) NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote