September 30, 2008 at 3:30 pm
Hi,
I have 10 databases and I created maintenance plan for optimizations and intigrity checks. The Integrity job failed, It running fine past several months. Iam using sql server 2000
The error message in the maintenance history as below
[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not processed. Database needs to be in single user mode.
Database:abc
Activity: chech data and Index Linkage
error no: 7919.
Could please tell me what will be the possible reasons.
September 30, 2008 at 3:32 pm
Someone was attached to your database. You will either need to wait for them to get off, or kick them off.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 30, 2008 at 4:58 pm
Hi,
Its a weekly job runs on saturday midnight 1:00am. So nobody is accessing that database at that time and how can I know who are accessed at that time(any script)?
September 30, 2008 at 5:06 pm
kotlas7 (9/30/2008)
Its a weekly job runs on saturday midnight 1:00am. So nobody is accessing that database at that time and how can I know who are accessed at that time(any script)?
Well obviously someone is, and it could be another Job running out of the same database. If you want to check it then try "EXEC master..sp_Who2" right before it runs, look for the processes that are in your specific database.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply