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.
| Author |
Topic |
|
ilimax
Posting Yak Master
164 Posts |
 Posted - 2010-03-29 : 11:35:49
|
| Does anbybody have idea why I have this problem. We are using .net application with Sql Server database. Sudenly, database is not available to connect. When I go to the server and check databse, I am not able to open with Manager too. I can not open to see object of database. I fix problem on this way, click over databse with right button, take databse offline, then bring back online.After that everything works fine.But, this problem start doing almost every day.Does anybdody have idea why? What can cause this state of database? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
Madhav
Starting Member
38 Posts |
Posted - 2010-03-29 : 11:45:05
|
| What is the sql server version and service pack? |
 |
|
|
ilimax
Posting Yak Master
164 Posts |
Posted - 2010-03-29 : 11:48:05
|
| 2005 version 9.00.4035.00 |
|
|
|
Madhav
Starting Member
38 Posts |
Posted - 2010-03-29 : 12:03:56
|
quote:
Originally posted by ilimax
2005 version 9.00.4035.00
Did you find any errors in the sqlserver error logs? |
|
|
|
ilimax
Posting Yak Master
164 Posts |
Posted - 2010-03-29 : 12:15:54
|
| I found error 18456, Severity 14, State 16 ... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Database coruption