Drop database and recreated, however cannot restore data. Says Data dump came from Master. If I choose Master, says I must be in single user mode.Hi,
Are you trying to restore the Master database or some user database ? If it
is master u have to
1.. Start Microsoft® SQL ServerT in single-user mode. (use -m in service
manager while starting sql server)
2.. Execute the RESTORE DATABASE statement to restore the master database
backup
3.. Stop and start the SQL Server in Muliuser Mode. (Just Restart MSSQL
Server service)
Thanks
Hari
MCDBA
"bscottparis" <anonymous@.discussions.microsoft.com> wrote in message
news:9D1F49FF-E704-4DE1-BB81-722033F6169E@.microsoft.com...
> Drop database and recreated, however cannot restore data. Says Data dump
came from Master. If I choose Master, says I must be in single user mode.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment