SQL Repart would Not Run
Error Message
Server: Msg 7919, Level 16, State 2, Line 1
Repair statement not processed. Database needs to be in single user mode.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Symptoms
I was get no errors on the database. I was trying to run some prventative mantainance.
Fix
You can convert the database to a single user mode by:
1. Opening Enterprise Manager
2. Right Click on the Database and go to property
3. Go to the options tab.
4. Select Restrict access and select single user.
Also see the Microsoft technical document Q264154 for more information.
1 comment:
When I was in serious situation for me helped-recover sql database,because my sql files was corrupted,this tool is free as is known,and utility repair data from corrupted databases in the MS SQL Server format (files with the *.mdf extension),supports data extraction via the local area network,can save recovered data as SQL scripts.
Post a Comment