Master Restore

  • Hello,

    I am restoring the Master database. I have the general idea on how to back it up and restore it. The problem is with the fact that so much is lost. I have done a bit of research and found a script that allows me to rebuild the lost logins; however, database connectivity is lost along with extended stored procedures. Does anyone have any idea or clue how to get all the extended stored procedures/etc back with the Master or are they totally lost upon the restore. I'm asking on more of a conceptual level, as if there is any way to facilitate the process.

    Thank you!

  • In 2000, after rebuilding master database, we need to attach each external dll files as extended stored procedures seperately. Not sure on how to do in 2005.



    Pradeep Singh

  • are you talking the built in external stored procedures, or ones you've added?

  • Hi Pradeep,

    Can you tell me on how to do that in 2000.

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

  • You add/register an external DLL by using sp_addextendedproc.

    This URL tells you how to do it.



    Pradeep Singh

  • Ones that were added. Sorry, I should've clarified a bit.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply