|
doubleotwo
Yak Posting Veteran
69 Posts |
 Posted - 2010-11-24 : 08:40:19
|
| in configuration manager i got the status "change pending..."This happened after trying to restore a database, which i already did a couple of times....Now i have no clue to fix it. I googled it and found 2 usefull links which didnt do anything.. i havent yet tried to reboot the server though cuzz i have to wait till the end of the day because its operational...i can do practicly everything i want else because sql server is only used for 1 database wich i only use and have a full backup off..Thx in advance folks :)*editNow i got a popup below that sql management studio is waiting for an internal process.... wtf ??? is he still restoring ?i tried to delete the database but this hanged too...edit 2*tried to start it via services.mscreponse was:could not start sqlexpress service on local computererror 1053: ..start task has not answerred correctly ( free translated from dutch )edit 3*found the error logdont understand it.. it states login failed..., i added the database with this account and then did a restore from a bak file... which was no problem at all2010-11-24 11:53:24.88 spid61 A time-out occurred while waiting for buffer latch -- type 2, bp 0396A440, page 1:71, stat 0xc0000b, database id: 1, allocation unit Id: 281474978152448/1441792, task 0x0552C1C0 : 0, waittime 300, flags 0x3a, owning task 0x00BDFC78. Not continuing to wait.2010-11-24 12:01:39.09 spid65 A time-out occurred while waiting for buffer latch -- type 2, bp 0396A440, page 1:71, stat 0xc0000b, database id: 1, allocation unit Id: 281474978152448/1441792, task 0x0552C718 : 0, waittime 300, flags 0x3a, owning task 0x00BDFC78. Not continuing to wait.2010-11-24 13:14:13.36 spid59 A time-out occurred while waiting for buffer latch -- type 2, bp 0396A440, page 1:71, stat 0xc0000b, database id: 1, allocation unit Id: 281474978152448/1441792, task 0x00BDF390 : 0, waittime 300, flags 0x3a, owning task 0x00BDFC78. Not continuing to wait.2010-11-24 13:32:28.36 spid58 A time-out occurred while waiting for buffer latch -- type 2, bp 0396A440, page 1:71, stat 0xc0000b, database id: 1, allocation unit Id: 281474978152448/1441792, task 0x00BDF390 : 0, waittime 300, flags 0x3a, owning task 0x00BDFC78. Not continuing to wait.2010-11-24 13:35:46.53 spid56 Setting database option SINGLE_USER to ON for database lhommetools.2010-11-24 13:40:11.05 spid58 A time-out occurred while waiting for buffer latch -- type 2, bp 0396A440, page 1:71, stat 0xc0000b, database id: 1, allocation unit Id: 281474978152448/1441792, task 0x00BDF390 : 0, waittime 300, flags 0x3a, owning task 0x00BDFC78. Not continuing to wait.2010-11-24 13:41:52.78 Logon Error: 18456, Severity: 14, State: 38.2010-11-24 13:41:52.78 Logon Login failed for user 'LHOMME\Administrator'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]2010-11-24 13:42:33.71 Logon Error: 18456, Severity: 14, State: 38.2010-11-24 13:42:33.71 Logon Login failed for user 'LHOMME\Administrator'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]2010-11-24 13:51:31.84 spid58 A time-out occurred while waiting for buffer latch -- type 2, bp 0396A440, page 1:71, stat 0xc0000b, database id: 1, allocation unit Id: 281474978152448/1441792, task 0x00BDF390 : 0, waittime 300, flags 0x3a, owning task 0x00BDFC78. Not continuing to wait.2010-11-24 13:51:33.30 spid59 A time-out occurred while waiting for buffer latch -- type 2, bp 0396A440, page 1:71, stat 0xc0000b, database id: 1, allocation unit Id: 281474978152448/1441792, task 0x00BEB1C8 : 0, waittime 300, flags 0x3a, owning task 0x00BDFC78. Not continuing to wait.2010-11-24 13:56:33.78 spid59 A time-out occurred while waiting for buffer latch -- type 2, bp 0396A440, page 1:71, stat 0xc0000b, database id: 1, allocation unit Id: 281474978152448/1441792, task 0x00BEB1C8 : 0, waittime 300, flags 0x3a, owning task 0x00BDFC78. Not continuing to wait.2010-11-24 14:00:09.28 Logon Error: 18456, Severity: 14, State: 38.2010-11-24 14:00:09.28 Logon Login failed for user 'LHOMME\Administrator'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]2010-11-24 14:01:33.87 spid59 A time-out occurred while waiting for buffer latch -- type 2, bp 0396A440, page 1:71, stat 0xc0000b, database id: 1, allocation unit Id: 281474978152448/1441792, task 0x00BEB1C8 : 0, waittime 300, flags 0x3a, owning task 0x00BDFC78. Not continuing to wait.2010-11-24 14:06:45.40 spid59 A time-out occurred while waiting for buffer latch -- type 2, bp 0396A440, page 1:71, stat 0xc0000b, database id: 1, allocation unit Id: 281474978152448/1441792, task 0x00BEB1C8 : 0, waittime 300, flags 0x3a, owning task 0x00BDFC78. Not continuing to wait.2010-11-24 14:11:45.61 spid59 A time-out occurred while waiting for buffer latch -- type 2, bp 0396A440, page 1:71, stat 0xc0000b, database id: 1, allocation unit Id: 281474978152448/1441792, task 0x00BEB1C8 : 0, waittime 300, flags 0x3a, owning task 0x00BDFC78. Not continuing to wait.2010-11-24 14:16:45.63 spid59 A time-out occurred while waiting for buffer latch -- type 2, bp 0396A440, page 1:71, stat 0xc0000b, database id: 1, allocation unit Id: 281474978152448/1441792, task 0x00BEB1C8 : 0, waittime 300, flags 0x3a, owning task 0x00BDFC78. Not continuing to wait.2010-11-24 14:48:31.62 spid59 A time-out occurred while waiting for buffer latch -- type 2, bp 0396A440, page 1:71, stat 0xc0000b, database id: 1, allocation unit Id: 281474978152448/1441792, task 0x00BDFAB0 : 0, waittime 300, flags 0x3a, owning task 0x00BDFC78. Not continuing to wait.edit4*i tried to adjust all the "logon as" thingies to the administrator account instead of localsystem.... at the thing of sql agent and when i try this i get an errorWMI provider errorthis request is not supported [0x80070032]edit5*i had like 6 processes of sqlserv.exe, killed them allhad 2 sql agents, 1 with CAPS and one lowercasekilled those too... and the some sqlmangr.exe"snow i got the state pending gone, and can start everything fromsql manager except the sql agent wich has logon as "localsystem" and has state "stopped"... the error i get when trying to start is:the request failed or the service did not respond in a timely fashion. consult the event log or other applicable error logs for details:( |
|
status : change pending