November 3, 2006 at 8:04 am
I got a problem. the raid card where the veritas application resides on was pulled out and then put in(while the power was off.) Once turned back on the application was dead. I restored the application and all databases including the BACKUPEXEC. I have a problem with the sql server that resides on that disk, I can't get it back up, nearly every database is in LOAD mode. The sql agent will not start. i can't create an OBDC connection for it, so the Enteprise manager will not recognize it to try and restore those databases. I've tried to start it in single mode but to no avail. (command line) If I could attach to the server then I would drop a couple of the users databases. I tried installing latest patch but it just timesout(windows server 2003/sp1- service patch sp3. I think half of the problem is that the msde veritas is using is on the same disk as the sql 2000 server so whatever patch i download its confused because it doens't know to which app to apply to.
SQL Server configured for thread mode processing.
2006-11-03 09:35:58.85 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2006-11-03 09:35:58.88 server Attempting to initialize Distributed Transaction Coordinator.
2006-11-03 09:35:59.97 spid2 Starting up database 'master'.
2006-11-03 09:36:00.13 server Using 'SSNETLIB.DLL' version '8.0.766'.
2006-11-03 09:36:00.13 spid5 Starting up database 'model'.
2006-11-03 09:36:00.16 spid2 Server name is 'DC-SRC5R4AT07WF'.
2006-11-03 09:36:00.16 spid8 Starting up database 'msdb'.
2006-11-03 09:36:00.16 spid9 Starting up database 'mike'.
2006-11-03 09:36:00.17 spid10 Starting up database 'norm'.
2006-11-03 09:36:00.17 spid5 Bypassing recovery for database 'model' because it is marked IN LOAD.
2006-11-03 09:36:00.17 spid8 Bypassing recovery for database 'msdb' because it is marked IN LOAD.
2006-11-03 09:36:00.19 spid9 Bypassing recovery for database 'mike' because it is marked IN LOAD.
2006-11-03 09:36:00.22 spid5 Database 'model' cannot be opened. It is in the middle of a restore.
I just inherited these servers and applications (new job). So any help would be appreciated. Thanks in ADVANCE!!!
November 3, 2006 at 8:16 am
i would start by seeing if any drive letters changed and making sure all the files are where they are supposed to be
November 3, 2006 at 8:29 am
They are all there.
I tired this command
BEGIN TRANSACTION
UPDATE sysdatabases SET status = <value> WHERE name = 'model'
commit transaction. stop single user mode
went into server manager to start it but the model database still needs to be recovered.
November 3, 2006 at 9:08 am
aint this a bit****
I guess if I would've rebooted the server after that command then everything would have came back quickly!!! but Im up and running now...I banged my head for 2 days...I need to find an ORACLE shop...LOL
December 7, 2006 at 12:12 pm
I run both here... Trust me, stay with SQL Server...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply