April 11, 2008 at 2:09 pm
There is a database that even though it is set to AUTOCLOSE = False, frequently gets cachestore flushes and eventually the database becomes unavailable. For a while (I have no Idea how long, this just got assigned to me on Wednesday) one of the applications people would detach and reattach the database. This at least made it available for access again. Finally after the last 'lock up' they asked the DBA team to look at it.
Have any of you run across this issue (database becoming unavailable in Sql server 2005.) If so, what was the resolution?
April 14, 2008 at 1:19 am
Are there any strange messages in the SQL error log from about the time that the database goes unavailable?
What errors do you get if you try and access the DB?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 14, 2008 at 6:21 am
And has anyone run a consistency check against it?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 15, 2008 at 5:59 am
You get this message when the database files are closed.
Having AUTOCLOSE on is the commonest way that database files get closed, but there are others...
ALTER DATABASE xxx SET OFFLINE
ALTER DATABASE xxx SET READ_ONLY or SET READ_WRITE
DETACH
It is worth checking that none of your applications aer doing these operations.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 15, 2008 at 6:29 am
Is someone using the "copy database" wizard ?
It proposes a "detach - attach" scenario. :sick:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply