[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Can't restore the master database

Posted on 2004-08-24
1
Medium Priority
?
700 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

656 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