+ Reply to Thread
Results 1 to 7 of 7

Attaching MSDB database

  1. Attaching MSDB database

    Anyway to attach the MSDB database? I have the .mdf and .ldf files from
    before a re-install. It won't allow me to detach MSDB as it says "System
    databases cannot be detached". I would like to replace the current MSDB. I
    don't have a database backup file.

    Thanks.

    Ron

  2. Re: Attaching MSDB database

    Ron,

    Provided you really know that this is what you want, you can do the
    following:

    1 - Backup your existing msdb database.
    2 - Shut down your SQL Server.
    3 - Move the existing msdb .mdf and .ldf files to somewhere else.
    4 - Copy your previous msdb .mdf and .ldf to the same place where the
    existing files were.
    5 - Restart SQL Server

    Then you might create a database named msdbinstall and restore your msdb
    backup from step 1 into msdbinstall. Just in case you need to check out a
    few things.

    RLF


    "Ron" wrote in message
    news:9250F5FE-101A-4605-A849-C94B4C1942C7@microsoft.com...
    > Anyway to attach the MSDB database? I have the .mdf and .ldf files from
    > before a re-install. It won't allow me to detach MSDB as it says "System
    > databases cannot be detached". I would like to replace the current MSDB.
    > I
    > don't have a database backup file.
    >
    > Thanks.
    >
    > Ron




  3. Re: Attaching MSDB database

    I think this will work only if the file paths match for all the files. SQL
    Servere doesn't like it if the files aren't where sysfiles thiks they are.

    --
    Thank you,

    Daniel Jameson
    SQL Server DBA
    Children's Oncology Group
    www.childrensoncologygroup.org


    "Russell Fields" wrote in message
    news:%23X3hsTY9HHA.484@TK2MSFTNGP06.phx.gbl...
    > Ron,
    >
    > Provided you really know that this is what you want, you can do the
    > following:
    >
    > 1 - Backup your existing msdb database.
    > 2 - Shut down your SQL Server.
    > 3 - Move the existing msdb .mdf and .ldf files to somewhere else.
    > 4 - Copy your previous msdb .mdf and .ldf to the same place where the
    > existing files were.
    > 5 - Restart SQL Server
    >
    > Then you might create a database named msdbinstall and restore your msdb
    > backup from step 1 into msdbinstall. Just in case you need to check out a
    > few things.
    >
    > RLF
    >
    >
    > "Ron" wrote in message
    > news:9250F5FE-101A-4605-A849-C94B4C1942C7@microsoft.com...
    >> Anyway to attach the MSDB database? I have the .mdf and .ldf files from
    >> before a re-install. It won't allow me to detach MSDB as it says "System
    >> databases cannot be detached". I would like to replace the current MSDB.
    >> I
    >> don't have a database backup file.
    >>
    >> Thanks.
    >>
    >> Ron

    >
    >




  4. RE: Attaching MSDB database

    you can refer the below link,

    http://deepakinsql.blogspot.com/2007...-sql-2005.html
    --
    Thanxx
    Deepak


    "Ron" wrote:

    > Anyway to attach the MSDB database? I have the .mdf and .ldf files from
    > before a re-install. It won't allow me to detach MSDB as it says "System
    > databases cannot be detached". I would like to replace the current MSDB. I
    > don't have a database backup file.
    >
    > Thanks.
    >
    > Ron


  5. Re: Attaching MSDB database

    Daniel,

    You are right, which is why the replacement msdb files must go back to the
    exact same place as occupied by the files at installation time. That is
    what my step 4 was trying to say.

    RLF


    "Daniel Jameson" wrote in message
    news:uelkspZ9HHA.5948@TK2MSFTNGP04.phx.gbl...
    >I think this will work only if the file paths match for all the files. SQL
    >Servere doesn't like it if the files aren't where sysfiles thiks they are.
    >
    > --
    > Thank you,
    >
    > Daniel Jameson
    > SQL Server DBA
    > Children's Oncology Group
    > www.childrensoncologygroup.org
    >
    >
    > "Russell Fields" wrote in message
    > news:%23X3hsTY9HHA.484@TK2MSFTNGP06.phx.gbl...
    >> Ron,
    >>
    >> Provided you really know that this is what you want, you can do the
    >> following:
    >>
    >> 1 - Backup your existing msdb database.
    >> 2 - Shut down your SQL Server.
    >> 3 - Move the existing msdb .mdf and .ldf files to somewhere else.
    >> 4 - Copy your previous msdb .mdf and .ldf to the same place where the
    >> existing files were.
    >> 5 - Restart SQL Server
    >>
    >> Then you might create a database named msdbinstall and restore your msdb
    >> backup from step 1 into msdbinstall. Just in case you need to check out
    >> a few things.
    >>
    >> RLF
    >>
    >>
    >> "Ron" wrote in message
    >> news:9250F5FE-101A-4605-A849-C94B4C1942C7@microsoft.com...
    >>> Anyway to attach the MSDB database? I have the .mdf and .ldf files from
    >>> before a re-install. It won't allow me to detach MSDB as it says
    >>> "System
    >>> databases cannot be detached". I would like to replace the current
    >>> MSDB. I
    >>> don't have a database backup file.
    >>>
    >>> Thanks.
    >>>
    >>> Ron

    >>
    >>

    >
    >




  6. Re: Attaching MSDB database

    did this few months ago, works!!!
    Russell Fields wrote:
    > Daniel,
    >
    > You are right, which is why the replacement msdb files must go back to the
    > exact same place as occupied by the files at installation time. That is
    > what my step 4 was trying to say.
    >
    > RLF
    >
    >
    > "Daniel Jameson" wrote in message
    > news:uelkspZ9HHA.5948@TK2MSFTNGP04.phx.gbl...
    >> I think this will work only if the file paths match for all the files. SQL
    >> Servere doesn't like it if the files aren't where sysfiles thiks they are.
    >>
    >> --
    >> Thank you,
    >>
    >> Daniel Jameson
    >> SQL Server DBA
    >> Children's Oncology Group
    >> www.childrensoncologygroup.org
    >>
    >>
    >> "Russell Fields" wrote in message
    >> news:%23X3hsTY9HHA.484@TK2MSFTNGP06.phx.gbl...
    >>> Ron,
    >>>
    >>> Provided you really know that this is what you want, you can do the
    >>> following:
    >>>
    >>> 1 - Backup your existing msdb database.
    >>> 2 - Shut down your SQL Server.
    >>> 3 - Move the existing msdb .mdf and .ldf files to somewhere else.
    >>> 4 - Copy your previous msdb .mdf and .ldf to the same place where the
    >>> existing files were.
    >>> 5 - Restart SQL Server
    >>>
    >>> Then you might create a database named msdbinstall and restore your msdb
    >>> backup from step 1 into msdbinstall. Just in case you need to check out
    >>> a few things.
    >>>
    >>> RLF
    >>>
    >>>
    >>> "Ron" wrote in message
    >>> news:9250F5FE-101A-4605-A849-C94B4C1942C7@microsoft.com...
    >>>> Anyway to attach the MSDB database? I have the .mdf and .ldf files from
    >>>> before a re-install. It won't allow me to detach MSDB as it says
    >>>> "System
    >>>> databases cannot be detached". I would like to replace the current
    >>>> MSDB. I
    >>>> don't have a database backup file.
    >>>>
    >>>> Thanks.
    >>>>
    >>>> Ron
    >>>

    >>

    >
    >


  7. Re: Attaching MSDB database

    Thank you very much - that worked just fine.

    "Russell Fields" wrote:

    > Ron,
    >
    > Provided you really know that this is what you want, you can do the
    > following:
    >
    > 1 - Backup your existing msdb database.
    > 2 - Shut down your SQL Server.
    > 3 - Move the existing msdb .mdf and .ldf files to somewhere else.
    > 4 - Copy your previous msdb .mdf and .ldf to the same place where the
    > existing files were.
    > 5 - Restart SQL Server
    >
    > Then you might create a database named msdbinstall and restore your msdb
    > backup from step 1 into msdbinstall. Just in case you need to check out a
    > few things.
    >
    > RLF
    >
    >
    > "Ron" wrote in message
    > news:9250F5FE-101A-4605-A849-C94B4C1942C7@microsoft.com...
    > > Anyway to attach the MSDB database? I have the .mdf and .ldf files from
    > > before a re-install. It won't allow me to detach MSDB as it says "System
    > > databases cannot be detached". I would like to replace the current MSDB.
    > > I
    > > don't have a database backup file.
    > >
    > > Thanks.
    > >
    > > Ron

    >
    >
    >


+ Reply to Thread