Moving MSDB to new location in SQL2000--Urgent

Discussion in 'microsoft.public.sqlserver.server' started by Suchi, Jun 27, 2007.

  1. Suchi

    Suchi Guest

    HI all,

    what is best way to move msdb to new loctaion (from F to E drive)on the
    same system in sql server2000?

    Shall I use restore command instead of attaching and detaching...

    Thanks in advance..
    Suchi
     
    Suchi, Jun 27, 2007
    #1

    1. Advertisements

  2. Suchi

    Tibor Karaszi Guest

    I believe that KB 224071 has explicit instructions for this.

    tibor_karaszi
     
    Tibor Karaszi, Jun 27, 2007
    #2

    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads

  1. Moving SQL2000 master/msdb to SQL2005

  2. Moving databases to a new location in SQL Server 2000 Cluster

  3. Moving ALL SQL Server 2000 structures to a new location in Clusteredenvironment

  4. Moving jobs to a new location.

  5. Moving File Groups to a new location

  6. Moving distribution database log file to a new location in 2k5

  7. Moving MASTER and MSDB to a New Server

  8. Moving cluster server to new location

Loading...