Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database is locked for administration Expand / Collapse
Author
Message
Posted Tuesday, November 11, 2008 2:43 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 25, 2009 2:28 PM
Points: 2, Visits: 5
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.
.
Post #600949
Posted Tuesday, November 11, 2008 2:52 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 22, 2014 7:04 AM
Points: 1,688, Visits: 8,766
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
Post #600958
Posted Tuesday, November 11, 2008 3:31 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 25, 2009 2:28 PM
Points: 2, Visits: 5

HI Manu,

Thanks for the reply.

How can we check the maintenance Jobs, If they are being executed? Do specify the steps...

Regards,
Mag.
Post #600977
Posted Tuesday, November 11, 2008 4:22 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 22, 2014 7:04 AM
Points: 1,688, Visits: 8,766
Check under jobs in enterprise manager to see if there is any job which is under execution.

MJ
Post #601000
Posted Tuesday, November 11, 2008 5:57 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, March 14, 2014 3:15 PM
Points: 804, Visits: 935
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."
Post #601034
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse