In SQL Server 2005, I tried to take a database offline by selecting "take offline." My computer had a problem during this now I get the following error...
ALTER DATABASE failed because a lock could not be placed on database 'CJISData'. Try again later.
ALTER DATABASE statement failed. (Microsoft SQL Server, Error: 5061)
I can't bring the database online or take it offline. I am not sure where to go from here. Any help will be appreciated. Thanks.
Bernie
Make sure you drop all connections on the database first or use the WITH ROLLBACK IMMEDIATE.HTH; Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment