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 |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2006-06-14 : 10:00:36
|
I have been given a SQL server to look after that sits on a cluster. I noticed that there is one particular database on this server that appears to be trying to startup for random intervals during any given day. So for example it may try at 4:30, keep trying every 10 seconds or so for a few minutes and then give up for a few minutes and start it all over again.On looking back thorugh the logs this database appears to have originally been restored from a backup about a month ago i.e. some time after the SQL server was up and running. At that point this message came up a couple of times quote:
Bypassing recovery for database 'MyDB' because it is marked IN LOAD.
What is wierd is that there are actually two databases that are part of the same thing. Both were setup at the same time (so likely by the same person), both got the error message above, but only one of them tries to start itself.From what little information I have it appears that this database came from another server originally and that's about all I know.Does anyone have any clues on what may be going on or how I can start to troubleshoot this pleasethanks in advancesteve-----------Oh, so they have internet on computers now! |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2006-06-14 : 14:51:47
|
| Maybe it's trying to start the database, but since moving to the cluster the drive letters have changed, and the paths to the MDF's and LDF's are now wrong?Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>Opinions expressed in this post are not necessarily those of TeleVox Software, inc. All information is provided "AS IS" with no warranties and confers no rights. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-14 : 14:55:53
|
| What does this database show as it's status in Enterprise Manager? Loading, Suspect, ... I suspect it's in a loading state and that RECOVERY was not selected on the restore. But it could be a log shipped database too I guess. Are any production applications pointing to it?Tara Kizeraka tduggan |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-06-15 : 03:25:33
|
| It doesn't show anything unusual in Enterprise mangler, it's unlikely to be log shipped as the guys who did this are unlikely to have heard of log shipping never mind used it. I don't think there are any production apps looking at it _ no one will tell me anything about it. In fact I have been specifically told not to look at the data as it is so sensitive that only one person can access it. He is now asking if he can deny everyone apart from hmself access to the data. Off the top of my head that isn't possible is it? i.e. if I am in the sysadmin group, can he deny me SELECT access say?It looks as though Michael may be correct. The transaction logs for the other databases appear to all be on a drive mapped as L but those for this as mapped to l and I'm not sure if that is a lower case L or an upper case i, as the drive mapping for the data files is in lower case I suspect the former. I should be able to sort this pretty quickly now.Many thanks to both for your advicesteve-----------Oh, so they have internet on computers now! |
|
|
|
|
|
|
|
|
Database startup on a cluster