November 11, 2008 at 2:43 pm
Dear All:
Our system environment is MS SQL Server
Recently we encountered a problem with the database; we found a database lock message when accessing the database.
A pop up displays on the desktopas soon as you log in to the server, below message:
"Database is locked for administration, Do u want to unlock it"
"Note: Unlocking that is being administrated can lead to loss of data in the database."
why does this message appears?
what needs to be done any note or logs to be verified?
How to solve this issue?
Kindly give some advice,
Regards,
Mag.
.
November 11, 2008 at 2:52 pm
Contact the database administrators and ask them whether there is any maintenance going on the database or is there any maintenance job(running in background) that lock the database before it start the maintenance operations.
MJ
November 11, 2008 at 3:31 pm
HI Manu,
Thanks for the reply.
How can we check the maintenance Jobs, If they are being executed? Do specify the steps...
Regards,
Mag.
November 11, 2008 at 4:22 pm
Check under jobs in enterprise manager to see if there is any job which is under execution.
MJ
November 11, 2008 at 5:57 pm
What version of SQL are you using? As Manu suggested check for jobs in the management folder in SQL 2000 and under SQL Servre Agent for SQL 2005.
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply