Post reply

How to rebuild master database?

  • June 8, 2010 at 6:13 am

    #140770

    Hi All,

    If the master database corrupt, and we don't have the backup of the master database, then how can we rebuild the master database.

    🙂

  • June 8, 2010 at 7:30 am

    #1177461

    Google is an awesome tool:

    http://msdn.microsoft.com/en-us/library/ms143269(SQL.90).aspx

    ----------------------------------------------------------------------------
    Sacramento SQL Server users group - http://sac.sqlpass.org
    Follow me on Twitter - @SQLDCH
    ----------------------------------------------------------------------------

    Yeah, well...The Dude abides.

  • June 11, 2010 at 6:40 am

    #1179124

    we can use Setup.exe from (setup folder/files) to rebuild,

    but my doubt is

    what happening to existing users(logins) how can we get those old logins?

    i think master will contain all logins information, if run the rebuild all users will be flushed out right? then how can the application will work.

    will database accessible with the user?

    thanks

    🙂

  • June 17, 2010 at 1:50 am

    #1181395

    You will need to create them again.

  • June 17, 2010 at 2:43 am

    #1181411

    Why don't you have a backup? Our Network people take disk images - you may be able to get something off there if you have a similar environment. Read up on tis first. Or the developers may know users and passwords.

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

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