Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Lost desktop pc Expand / Collapse
Author
Message
Posted Thursday, January 31, 2013 10:20 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 2:48 PM
Points: 23,397, Visits: 32,244
And no, it didn't go missing. It just died with a loud pop. Could be the power supply, the system is 8 years old.

Question for those more hardware savvy, if I replace both the motherboard and the power supply, would it boot up with the current hard drives?



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1414440
Posted Thursday, January 31, 2013 11:32 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:39 PM
Points: 37,101, Visits: 31,653
Lynn Pettis (1/31/2013)
And no, it didn't go missing. It just died with a loud pop. Could be the power supply, the system is 8 years old.

Question for those more hardware savvy, if I replace both the motherboard and the power supply, would it boot up with the current hard drives?


Maybe. It depends a lot on what you have for a video system and network system if they're built in. The system may hurl and come up in the VGA mode and then you'll have to install drivers for the new mother board or it may auto-magically recognize the change and ask you to insert a driver disk or maybe it'll just work.

You'll likely have to re-register Windows on the box because of the MB change, though.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1414450
Posted Friday, February 1, 2013 1:39 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 10:19 AM
Points: 43,026, Visits: 36,192
Lynn Pettis (1/31/2013)
And no, it didn't go missing. It just died with a loud pop. Could be the power supply, the system is 8 years old.

Question for those more hardware savvy, if I replace both the motherboard and the power supply, would it boot up with the current hard drives?


As long as there's no RAID (onboard RAID) and the new motherboard has the same drive connections, it should. I've done it, took a few reboots and a couple driver installations.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1414488
Posted Friday, February 1, 2013 6:25 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:12 PM
Points: 1,248, Visits: 6,693
At 8 years old, you might have some challenges.
Some of the architecture has changed - CPU, memory, disc connections, even the power supply feeds and voltages.
I'd also consider if just getting the data to a newer machine and installing programs again might be a better investment in time and money.

POP is usually not good - I'd probably try to determine if it's just the power supply, and if so, replace just that.
MB would be a likely show stopper for me.
Post #1414638
Posted Friday, February 1, 2013 7:43 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 10:42 AM
Points: 290, Visits: 1,682
From my experience<*pops*> are often the power supply giving up the ghost; there's not a lot on the motherboard that could make that kind of noise. Problem is, when power supplies go, they sometimes take things that are plugged into them with them.

I agree with Greg that, if you can find a replacement power supply, you should try that first, as it will be the least expensive part, and may do the trick. If the motherboard was damaged you'd probably see evidence of it - burn marks around connection points, etc.

If the HDs are fit, you could also try moving them to a working PC with the same ports (e.g. SCSI, IDE, etc) or an external kit. You probably couldn't boot from them, and you may have to play with jumpers to make them recognized, but you may be able to read from them; at least, if you're familiar with how a healthy hard drive sounds, just connecting them to a power source might tell you whether they were blown up or not. As Gail mentioned, if they were RAID drives, this becomes much, much more complex (and your best hope lies with the issue being just the power supply).

I'm sure you'd have noticed if this was the case, but if you were using a CRT monitor (you did say it was old), they have tubes that can make <*pops*> when they go; in which case you'd have no video, but would still have power to the PC (again, doubt you would have missed this, just trying to be thorough).

I haven't been exposed to it much lately, I used to do a bit of h/w support, so if I can help, just let me know, Lynn.
Post #1414683
Posted Friday, February 1, 2013 8:21 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 2:48 PM
Points: 23,397, Visits: 32,244
Going to start with just a power supply swap. I have several PC's sitting around, just need to be sure that the one I use has the needed power connectors for the one I need to replace. So far it looks like they ar all the same size power supplies based on Wattage and other comparable values.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1414701
Posted Friday, February 1, 2013 9:26 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 7:49 AM
Points: 13, Visits: 65
I would be worried that other hardware could have been damaged (RAM, CPU, and any cards that were attached). An eight year old PC, depending on the specs of the old machine and the budget, this might be a good time for an upgrade.
Post #1414734
Posted Friday, February 1, 2013 9:32 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:04 AM
Points: 2,678, Visits: 19,271
Maybe it just went "To The Cloud"...

---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
Post #1414735
Posted Friday, February 1, 2013 9:52 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 2:48 PM
Points: 23,397, Visits: 32,244
I'd love to replace it but if I can salvage it now, that would be better. I can look at a replacement when personal funding is better, which will happen shortly.

In 6 months or so I will be in a position to purchase a much more robust system that will allow for building VMs for much deeper dives for professional development. I just need this system to work until June when it will go into storage.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1414746
Posted Friday, February 1, 2013 4:55 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 9:17 AM
Points: 1,398, Visits: 6,422
a power supply swap is usually a good place to start
Post #1414872
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse