• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 710
  • Last Modified:

Can't restore the master database

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
hernaezia
Asked:
hernaezia
1 Solution
 
SNilssonCommented:

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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now