Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    India
    Posts
    17

    Unanswered: moving Tempdb from master device

    Hello

    I want to move my tempdb database from master deivce. If u can please let me know how to do step-by-step.Also how can i move make a new segment of particular database as the default so that whenever any new table is created it is created on that segment not to the default because here i do'nt want to give a segment name in create table syntax.

    Thanks

  2. #2
    Join Date
    Nov 2002
    Posts
    207
    Never remove the 2MB fragment of tempdb from the master device. Just disable it. This will make recovery easy.
    1. Update sysusages set segmap = 0 where dbid=2 and lstart = 0
    2. Use sp_dropsegment to remove all active segment on this part of tempdb (system, default and syslog)

    Cheers!
    Manjeet

Posting Permissions

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