469,623 Members | 883 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,623 developers. It's quick & easy.

Master Database Restoration

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

1.net stop MSSQLServer
2.sqlservr -m
3.use MASTER
RESTORE DATABASE master FROM disk='master.BAK'
MOVE 'master' to 'E:\Program Files\Microsoft SQL Server\Data\master.mdf',
MOVE 'mastlog' to 'E:\Program Files\Microsoft SQL Server\\Data\mastlog.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.
Jul 17 '07 #1
0 977

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Winston Ng | last post: by
3 posts views Thread by Tommy.Vincent | last post: by
reply views Thread by Now You Know | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.