Results 1 to 3 of 3

Thread: Moving Model/Tempdb/MSDB

  1. 03-13-2001, 11:30 AM #1
    George Wilson Guest

    Moving Model/Tempdb/MSDB

    I have a situation where I would like to move the physical location of the Model, tempdb and MSDB database files. Does anyone know of a way to do this?
    Reply With Quote Reply With Quote
  2. 03-13-2001, 11:50 AM #2
    Sundar Guest

    Moving Model/Tempdb/MSDB (reply)

    You will have to dump and reload the databases using the WITH MOVE option to point to the new device files.


    ------------
    George Wilson at 3/13/01 11:30:46 AM

    I have a situation where I would like to move the physical location of the Model, tempdb and MSDB database files. Does anyone know of a way to do this?
    Reply With Quote Reply With Quote
  3. 03-13-2001, 03:11 PM #3
    Julie Guest

    Moving Model/Tempdb/MSDB (reply)


    You can move the tempdb by using an alter database statement with the filename option, then stop & restart SQL and it will move the database to the new location.

    ------------
    Sundar at 3/13/01 11:50:38 AM

    You will have to dump and reload the databases using the WITH MOVE option to point to the new device files.


    ------------
    George Wilson at 3/13/01 11:30:46 AM

    I have a situation where I would like to move the physical location of the Model, tempdb and MSDB database files. Does anyone know of a way to do this?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules