July 27, 2009 at 7:38 am
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!
July 27, 2009 at 7:59 am
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.
July 27, 2009 at 8:15 am
are you talking the built in external stored procedures, or ones you've added?
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 27, 2009 at 8:15 am
Hi Pradeep,
Can you tell me on how to do that in 2000.
[font="Verdana"]Thanks
Chandra Mohan[/font]
July 27, 2009 at 8:35 am
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