CODEWITHSUNDEEP
sqlsql-serverrecovery
suneeth
suneeth

Reputation: 165

unable to run alter database commands

One of my database has gone into the "recovery pending" mode. now I am unable to run any alter statements on this database as it always gives me the following error:

ALTER DATABASE failed because a lock could not be placed on database

I have checked and confirmed that there are no active connections on this database. There are also no locked processes on this database.

Any idea how to solve this error?

Upvotes: 3

Views: 1457

Answers (1)

VMAtm
VMAtm

Reputation: 28355

recovery pending state for a database means that your server can't find needed amount of memory to maintain all the databases it have, and, to be able to work with some of the databases, it move to the recovery other ones (usually not so used).

You have two ways to resolve this issue: add physical resources to your server (RAM or something) or remove some unused databases from your server.

Upvotes: 1

Related Questions