<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQLServerCentral.com
»
Anything that is NOT about SQL!
»
Lost desktop pc
11 posts, Page 1 of 2
1
2
»»
Lost desktop pc
Rate Topic
Display Mode
Topic Options
Author
Message
Lynn Pettis
Lynn Pettis
Posted Thursday, January 31, 2013 10:20 PM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 4:35 PM
Points: 21,589,
Visits: 27,389
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
Jeff Moden
Jeff Moden
Posted Thursday, January 31, 2013 11:32 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 12:30 PM
Points: 32,893,
Visits: 26,770
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 "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1414450
GilaMonster
GilaMonster
Posted Friday, February 01, 2013 1:39 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:15 PM
Points: 37,651,
Visits: 29,903
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
Greg Edwards-268690
Greg Edwards-268690
Posted Friday, February 01, 2013 6:25 AM
Right there with Babe
Group: General Forum Members
Last Login: 2 days ago @ 12:34 PM
Points: 781,
Visits: 5,176
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
Steve Thompson-454462
Steve Thompson-454462
Posted Friday, February 01, 2013 7:43 AM
SSC Veteran
Group: General Forum Members
Last Login: 2 days ago @ 11:23 AM
Points: 270,
Visits: 1,457
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
Lynn Pettis
Lynn Pettis
Posted Friday, February 01, 2013 8:21 AM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 4:35 PM
Points: 21,589,
Visits: 27,389
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
drottfromspace
drottfromspace
Posted Friday, February 01, 2013 9:26 AM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, April 09, 2013 11:32 AM
Points: 9,
Visits: 45
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
jcrawf02
jcrawf02
Posted Friday, February 01, 2013 9:32 AM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 12:36 PM
Points: 2,549,
Visits: 18,880
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
Lynn Pettis
Lynn Pettis
Posted Friday, February 01, 2013 9:52 AM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 4:35 PM
Points: 21,589,
Visits: 27,389
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
Jo Pattyn
Jo Pattyn
Posted Friday, February 01, 2013 4:55 PM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 2:27 PM
Points: 1,329,
Visits: 4,293
a power supply swap is usually a good place to start
Post #1414872
« Prev Topic
|
Next Topic »
11 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
