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. 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.