Post reply

Restore Master Database to Test Server

  • August 29, 2007 at 4:58 pm

    #70109

     Hi All:

    Please advise me about restore a master database from production to test server.

    The reason to do this because I need to test and evaluate some login in master database.

    I tried to restore master database to test server, but I got some errors regarding about user databases are not exists in test server. I don't want to restore user databases, I only need master database for evaluate user login.

    Again thanks for your advice.

     

    vua

  • August 29, 2007 at 9:52 pm

    #730307

    You do not have to restore user databases.

  • August 29, 2007 at 11:28 pm

    #730318

    OK this is what I did.

    1) Set database as single login mode

    2) Restore master database.

    3) Once the restore finished, the database service is not started.

    What did I do wrong? Do you have any procedures?

    Thanks for your help.

     

  • August 30, 2007 at 12:21 am

    #730326

    is the service ur talking about is "MSSQLSERVER" , i dont no what u have done worng but some times it just happen , any way if this is the service try checking the log on account that it use if it has the right permission to start the servic up.

    ..>>..

    MobashA

  • August 30, 2007 at 9:33 pm

    #730647

    Hi, Just restart services from control panel/services

  • August 30, 2007 at 10:37 pm

    #730651

    Thank you all.... I got it working now.

     

  • August 31, 2007 at 11:24 am

    #730842

    A note for the future:

     

    Whenever you restore the master database the SQL Server service stops itself automatically.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

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

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