Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Lost desktop pc


Lost desktop pc

Author
Message
Lynn Pettis
Lynn Pettis
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24179 Visits: 37948
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?

Cool
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)
Jeff Moden
Jeff Moden
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45038 Visits: 39893
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.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Wink

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47213 Visits: 44369
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, MVP, M.Sc (Comp Sci)
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


Greg Edwards-268690
Greg Edwards-268690
SSC Eights!
SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)

Group: General Forum Members
Points: 817 Visits: 8256
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.
Steve Thompson-454462
Steve Thompson-454462
SSC Veteran
SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)

Group: General Forum Members
Points: 289 Visits: 2054
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.
Lynn Pettis
Lynn Pettis
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24179 Visits: 37948
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.

Cool
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)
scott82020
scott82020
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
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.
jcrawf02
jcrawf02
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1420 Visits: 19324
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."
Lynn Pettis
Lynn Pettis
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24179 Visits: 37948
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.

Cool
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)
Jo Pattyn
Jo Pattyn
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1589 Visits: 9720
a power supply swap is usually a good place to start
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search