July 2, 2002 at 7:10 am
I am getting the following error on this and another DB during the integrity checks (with repair errors):
Starting maintenance plan 'Proposal Maintenance Plan' on 6/30/02 1:30:01 AM
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC SQL Server Driver][SQL Server]Database state cannot be changed while other users are using the database 'Proposal'
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
[1] Database Proposal: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not processed. Database needs to be in single user mode.
Sql2000 Sr2 Is there a way around this issue?
Thanks
July 2, 2002 at 8:01 am
Uncheck the repair errors box in the maint plan. If you find errors then you can go back and set single user mode and manually run the dbcc checkdb with the repair option.
Andy
July 2, 2002 at 9:35 am
This causes the maintenance plans to fail and is a known issue. Follow Andy's advice.
Steve Jones
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply