Master Database Restoration

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bharadwaj
    New Member
    • Jun 2007
    • 22

    #1

    Master Database Restoration

    hi,
    i am trying to do master restoration using the following steps.

    1.net stop MSSQLServer
    2.sqlservr -m
    3.use MASTER
    go
    RESTORE DATABASE master FROM disk='master.BA K'
    replace,
    MOVE 'master' to 'E:\Program Files\Microsoft SQL Server\Data\mas ter.mdf',
    MOVE 'mastlog' to 'E:\Program Files\Microsoft SQL Server\\Data\ma stlog.ldf'
    when i execute the step 3 i am getting the below error.
    Server: Msg 18461, Level 16, State 1, Line 0
    [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'xxx'. Reason: Server is in single user mode. Only one administrator can connect at this time.

    Connection Broken

    but i am using administrator login only.
    any help.
    regards
    Bharat
Working...