ALTER DATABASE failed because a lock could not be placed on database 'linkoblast_DB'. Try again later. Msg 5069, Level 16, State 1, Line 4 ALTER DATABASE statement failed.

Sometimes when you try to take your database offline. As soon as you run the process, you may face issue with following error message:

ALTER DATABASE failed because a lock could not be placed on database 'linkoblast_DB'. Try again later.

Msg 5069, Level 16, State 1, Line 4 ALTER DATABASE statement failed.

Below is the simple solution to this error message:


Run sql command

EXEC sp_who2

It will list all running processes.

Find your database name under dbname column.

Copy the SPID for that record and run this command

KILL <SPID>

Try accessing the database now.

You should be able to access it successfully.

No comments:

Post a Comment