Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005

    Unanswered: Help with moving tempdb

    Hi, I made a mistake when moving tempdb to RAM: this is what I did:

    delete * from sysusages where dbid=2 and lstart >0
    delete * from sysdevices where name="tempd_dev"
    alter temp on tempdb_dev1=sizeI coud wait for some time and then it crashed

    Then exit and couldn't connect back again , saw this error in log 806 severity 21: (
    How can I go back??

    Need help!

    Thanks in advanced

  2. #2
    Join Date
    May 2005
    South Africa
    Provided Answers: 1
    Restart ASE before using tempdb (increasing it’s size again).
    This will recreate tempdb on the smaller chunk (lstart=0) .
    Last edited by pdreyer; 11-29-05 at 02:27.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts