Have serious SQL issue Need Help

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Have serious SQL issue Need Help

Author

Topic

DCraft
Starting Member

3 Posts

Posted - 2014-07-09 : 19:51:20

Hello,
Last week all of the sudden I started having some SQL Lockups.. So I ran an DBCheck today and here is one of the errors I get.. Can anyone help please this is a MAJORLY important server that I need back online..

Msg 945, Level 14, State 2, Line 1

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-07-09 : 20:18:42

Please post the entire output of DBCC CHECKDB.

Do you have backups?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

DCraft
Starting Member

3 Posts

Posted - 2014-07-10 : 12:16:50

Tara,
I was able to get one of the DBs back online however it seems when I am trying to get the second one back online I am receiving this error..I cannot take it offline anymore.. But it's also not online...

TITLE: Microsoft.SqlServer.Smo
------------------------------

Set offline failed for Database '==='.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0038+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Set+offline+Database&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

ALTER DATABASE failed because a lock could not be placed on database '==='. Try again later.
ALTER DATABASE statement failed. (Microsoft SQL Server, Error: 5061)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2550&EvtSrc=MSSQLServer&EvtID=5061&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-07-10 : 12:28:05

I am not familiar with those errors. If this is a critical database, I would suggest opening a case with Microsoft. You might need to restore from backup. Hopefully your backups are proven to work.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

DCraft
Starting Member

3 Posts

Posted - 2014-07-10 : 13:29:57

Yes I have seen some STRANGE ones over the past couple weeks... ARGGGG...

Shanky
Yak Posting Veteran

84 Posts

Posted - 2014-07-16 : 10:35:55

quote:
Originally posted by DCraft

Tara,
ALTER DATABASE failed because a lock could not be placed on database '==='. Try again later.
ALTER DATABASE statement failed. (Microsoft SQL Server, Error: 5061)

This does not requires opening a case with Microsoft your table is being locked so cannot proceed with alter table statement. Its not a fatal error. You might be facing huge blocking in your environment and reasons can be many. I would ask you to look at below Microsoft resource

http://support.microsoft.com/kb/224453/en-gb

Regards
Shanky
http://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources