Post reply

SQL 6.5 and TempDB

  • November 13, 2003 at 1:07 pm

    #59032

    This is for those into nostalgia.

    I have a SQL6.5 installation and TempDB is on the MASTER device.

    It is also on 3 other devices.

    Is there a way of consolidating it into a single device, preferrably not MASTER?

    Thanks

    LinkedIn Profile

  • November 13, 2003 at 1:23 pm

    #481954

    would like to watch the replies. though my thinking says not so easy other then if there is a way to cheat the system.

  • November 13, 2003 at 1:41 pm

    #481958

    David,

    I found this link that might be of interest to you:

    http://webdevelopment.developersnetwork.com/Articles.asp?Article=227

    The suggested route is to make another device the default device and then switch the tempdb to RAM and back to disk. Doing so will recreate the tempdb on the default device, which is no longer the master device. It does imply two restarts of the mssqlserver service.

    JM

  • November 13, 2003 at 3:55 pm

    #481986

    Yes as usual with SQL 6.5, you have to jump through three or four hoops to do one task. Just be sure that you do each step as documented and it'll work fine.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply