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
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