SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Rebuild SQL Server Master Databases in Less than 5 Minutes


Rebuild SQL Server Master Databases in Less than 5 Minutes

Author
Message
Rudy Panigas
Rudy Panigas
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1728 Visits: 1315
Comments posted to this topic are about the item Rebuild SQL Server Master Databases in Less than 5 Minutes



Satnam Singh
Satnam Singh
Say Hey Kid
Say Hey Kid (678 reputation)Say Hey Kid (678 reputation)Say Hey Kid (678 reputation)Say Hey Kid (678 reputation)Say Hey Kid (678 reputation)Say Hey Kid (678 reputation)Say Hey Kid (678 reputation)Say Hey Kid (678 reputation)

Group: General Forum Members
Points: 678 Visits: 1084
Awesome. Wish there could have been more than 5 *

Cheers,
Satnam
M&M
M&M
SSCarpal Tunnel
SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)

Group: General Forum Members
Points: 4717 Visits: 3912
Rudy,
The title of this article is really catchy.

Regarding this section: It's All Proactive
You are referring to a SQL Server instance which is running fine right?
I am assuming you are not copying from the instance which has db corruption.

M&M
M A Srinivas
M A Srinivas
SSC Veteran
SSC Veteran (250 reputation)SSC Veteran (250 reputation)SSC Veteran (250 reputation)SSC Veteran (250 reputation)SSC Veteran (250 reputation)SSC Veteran (250 reputation)SSC Veteran (250 reputation)SSC Veteran (250 reputation)

Group: General Forum Members
Points: 250 Visits: 677
Practically this is not possible. In production you can not stop and start the service everyday and changes occur to master datbase every day .
mister.magoo
mister.magoo
SSCertifiable
SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)

Group: General Forum Members
Points: 7101 Visits: 7887
Thanks for the article.

I personally was disappointed to find that it was not about rebuilding the master database as the title said it would be though...

MM


select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);




  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • gwatson 93229
    gwatson 93229
    Grasshopper
    Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

    Group: General Forum Members
    Points: 22 Visits: 95
    I was also disappointed. "Rebuilding" to me does not mean "restore from a file I copied earlier". In fact, thinking about it more, it would seem in this case that you had two backups, one on disk locally and one on tape. This is a great idea for disaster recover situations but had the restore from tape worked this whole secondary method would not be needed. In either case, tape or disk, we have not rebuilt the master database, we have restored it from backup.

    I am happy to be corrected but I find the title of this article very misleading.
    george sibbald
    george sibbald
    SSCoach
    SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

    Group: General Forum Members
    Points: 17016 Visits: 13695
    M A Srinivas (2/3/2011)
    Practically this is not possible. In production you can not stop and start the service everyday and changes occur to master database every day .


    you would not do this every day. you only need to do it when you apply a patch to SQL, and then there would be an outage anyway. I would also copy the msdb,model and importantly the resource database. The master database is bought up to date by restoring the latest backup as described in the process. BTW SQL needs to be started in single user mode to restore the master database.

    This is a sensible addition to your DR strategy.

    ---------------------------------------------------------------------
    dant12
    dant12
    SSC-Addicted
    SSC-Addicted (472 reputation)SSC-Addicted (472 reputation)SSC-Addicted (472 reputation)SSC-Addicted (472 reputation)SSC-Addicted (472 reputation)SSC-Addicted (472 reputation)SSC-Addicted (472 reputation)SSC-Addicted (472 reputation)

    Group: General Forum Members
    Points: 472 Visits: 711
    i dunno, but this kinda sounds like a bad idea.
    i have previously rebuilded the master database to change server collation and it went through painlessly in no time.
    anything that would keep you from actually rebuilding the master database in case of corruption?

    --
    Thiago Dantas
    @DantHimself
    Markus
    Markus
    SSCertifiable
    SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)

    Group: General Forum Members
    Points: 5038 Visits: 3824
    I try and do this after a patch or when I know I have an outage window. It is always good to have an easy way to get SQL Server back to a somewhat stable state.

    To all of those that are disappointed in this article.... All this article is pointing out is if master gets corrupted for any reason this is an easy way to get you back to a stable running SQL Server. That is all. It is not meant to be a daily occurance as no one can stop/start SQL Server on a daily basis in a production environment.



    MysteryJimbo
    MysteryJimbo
    Hall of Fame
    Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

    Group: General Forum Members
    Points: 3529 Visits: 15346
    This will only apply in a small number of situations. The point of SQL Server providing high availabilty means this is not usually possible without a maintenance slot.

    A useful tip rather than a "how to" in my opinion.
    Go


    Permissions

    You can't post new topics.
    You can't post topic replies.
    You can't post new polls.
    You can't post replies to polls.
    You can't edit your own topics.
    You can't delete your own topics.
    You can't edit other topics.
    You can't delete other topics.
    You can't edit your own posts.
    You can't edit other posts.
    You can't delete your own posts.
    You can't delete other posts.
    You can't post events.
    You can't edit your own events.
    You can't edit other events.
    You can't delete your own events.
    You can't delete other events.
    You can't send private messages.
    You can't send emails.
    You can read topics.
    You can't vote in polls.
    You can't upload attachments.
    You can download attachments.
    You can't post HTML code.
    You can't edit HTML code.
    You can't post IFCode.
    You can't post JavaScript.
    You can post emoticons.
    You can't post or upload images.

    Select a forum

































































































































































    SQLServerCentral


    Search