[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Can't restore the master database

Posted on 2004-08-24
1
Medium Priority
?
708 Views
Last Modified: 2008-02-01
Hi..

I try to restore my database but some how I got an error message saying
"Microsoft SQL-DMO(ODBC SQLState: 42000)
RESTORE DATABASE must be used in single user mode when trying to restore the database.RESTORE DATABASE is terminating abnormally."

I'm using OS Win XP Pro..and Ms SQL Server 2000 Developers Edition..
What should i do  to resolve this problem?

Herz
0
Comment
Question by:hernaezia
1 Comment
 
LVL 8

Accepted Solution

by:
SNilsson earned 1000 total points
ID: 11889664

Just like the error say I suppose, set the database in single user mode first.

EXEC sp_dboption 'Master', 'single user', 'TRUE'
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question