Computer Support Forum

Hardware specs for Database Server

Question: Hardware specs for Database Server

Hi all,

We have system for our work that uses a web/application server and a database server. Around 150 people use this application and the data stored are usually text, ms office documents, pdf files and images. Suppose that about 50 people are using the system at any given time, what do you think will need better hardware specs, the database server or the web/application server?

Could you give any recommendations for the hardware specs? Like cpu, ram? A friend of mine suggested that it would be good to use the nVidia Tesla GPU for parallel processing. Is this a good idea or is this going a bit overboard?

Thanks

More replies
Relevance 100%
Preferred Solution: Hardware specs for Database Server

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Relevance 73.39%

Hello, I was wondering if any of you could recommend some Hardware Specs and/or prebuilt model #'s (ex. Dell, HP) for a new work server. It will be supporting 20 users, 26 PC's, and 6 printers. I will be using the Windows Server 2K3 OS and it will be used in the following roles:

DNS Server
Primary Domain Controller (Active Directory)
Application Server (minimal)
File Server (currently converting all paper customer files to electronic)
WSUS Server
Printers will be networked through it

I would like to put the OS on a RAID 1 array, and Data/Files on a 500 Gb to 1 Tb RAID 5 or 10 (suggestions?) array. Also, I would appreciate suggestions on favorite backup software suites.





 

Answer:Server 2k3 Hardware & Specs Recommendation

You'd be well served (no pun intended) by any entry level server. I was running AD on dual P3 1ghzs for 100 people and it sailed along.

What's the budget?

I'm partial to dell 2950s - they're solid servers.

HP makes a nice server in the 380-385s are nice too.
 

29 more replies
Relevance 59.45%

Hi Guys,

Im trying to write some code that will copy my access database , tables and data to a new sql server database, ive got the code to create the sql database but i need to populate it from my application

Any answers would be grateful

Thanks
Mark
 

Answer:Copy an access database to SQL server database using VB.NET

Google: import access to sql server
 

1 more replies
Relevance 56.58%

Hello, and sorry if the title isnt the best, I wasnt really sure how to word it I'm afraid.

Having used search for the last couple of hours, and seen many threads its clear I'm in the right place. You all have a lovely forum!

I'm looking for a solution to a rather annoying problem in our household. We have upwards of 8-10 computers/laptops in our house, and documents/media are fast becoming a nightmare!

We've decided to go along the route of purchasing/building a server to basically use as a fileserver, to centralise our documents/media and thus enable access to either user account from any one particular computer we have.

Below is what I'm looking to be able to do:

1. Fileserver (mainly comprising of centralised documents on the server itself accessable by each person individually but private from others)
2. Central backup of all crucial computers to prevent data loss (stored on the server, and done by the server on a regular basis)
3. A dedicated server firewall to place in front of the internet, before the network.
4. A web server, so I can run image copies of my own personal forum/websites and test any changes BEFORE doing them to my live site.
5. To download torrents/large files etc directly on the server. Like an automated nightly backup of my web hosting server online for example.
6. Stream full HD from the server to our media centre pc (and onto a HD TV).

I was thinking along the lines of using 3 older, seperate servers. the first bein... Read more

Answer:Advice and help regarding recommended server specs for home server use

Do you have this network in place already?

This is mine below done with Cisco Virtual Network Design Tool.
For web server I use IIS 7.
 

8 more replies
Relevance 55.76%

Hello, I have a database server (mssql) in a RAID 10 configuration. This is a production critical host and I am provisioning a new host that will replace it (the new host is much more powerful).

How could I achieve this with minimum downtime? DNS switch maybe? Any help and insight would be much appreciated.

Answer:Database server..need to build a new server and migrate the data with minimum downtime. Help!

If you are in an Active Directory environment, yes DNS switch is going to be your best bet. You can completely bring up the new host, copy all data, then have like an hour or so for a maintenance window. During that window you will make the database unavailable to end users, make one last sweep to copy any changed data then make the DNS change to point to the new host.

We had to do something similar for a program, the database was about 3.5 GB of data that we migrated over. Then created the new host, got a maintenance window, did a last pass through for the copy, made the dns switch and we were good.

That being said, we don't know your environment so i can't say for sure if this would work for your setup. Our database was being accessed simply by name, so we just changed the DNS record to reflect the new host. Our data was also flat - meaning it wasn't something complex like SQL, it was essentially just a file share with a ton of data.

2 more replies
Relevance 55.35%

Will my server work well with Windows Server 2003?
or should i just install Windows 2000 Server?

Specs:
P4 2.4c
Intel D865PERL mobo
4x 512 Dual Channeling PC2700
40GB IDE
300GB SATA
400GB SATA

Any recommendations would be great!
 

Answer:With my Specs, should i install Win 2003 Server or W2K Server?

nice setup, go for 2003. The min. specs it will run at are 133mhz processor and 128 megs RAM, so you'll be fine. You'll get more out of 2003 than you will 2000 anyways.
 

6 more replies
Relevance 54.53%
Question: Hardware Specs?

Hello all,

Somewhere about the time of the demise of 1998 I stopped being able to keep up with the specs of CPU's. I mean, mentally wise. It just got to be to much!

With that said, my laptop is a 2 year old HP Turion 64 X2 1.80GHZ with 2GB ram running Windows 7.

I am wanting to know if that is more then the minimum specs to run Modern Warfare 2.

The specs for it are as follows:

# Processor: Intel Pentium 4 3.2 GHz or AMD Athlon 64 3200+ processor or better supported
# Memory: 1 GB RAM
# Graphics: 256 MB NVIDIA GeForce 6600GT or better or ATI Radeon 1600XT or better

Now I know if it will it's not going to be great but MW1 ran fine on it.

Thanks
David
 

Answer:Hardware Specs?

9 more replies
Relevance 54.53%

EVGA2 GeForce GTX 650 Ti 1024MB GDDR5 128bit, Dual Dual-Link DVI, Mini HDMI, Graphics Card 01G-P4-3650-KR amd phenom 9500 quad processor 2.2ghz 3070mb of ram direct x 11windows vista ultimate640gb hard drivegeneric pnp monitor (can wire up to my hdtv)HP pavillion media center m8330f PCDont know if you need anything else ?I am trying to play some newer games on like high settings maybe ? really dont know much about computers so help would be appreciated

Answer:New to this - Are these okay hardware specs ?

Is this the system you already have, or something you're considering buying/upgrading?First thoughts are that your CPU is fairly old now and will bottleneck your graphics card.  Your graphics card though isn't bad, it will suffice for most games at medium details.

14 more replies
Relevance 54.53%
Question: Hardware Specs

Hi Guys,

I'm looking at getting a new PC but I'm on a bit of a budget, I've done some research into the components etc and this is what I'm looking at getting...can you see anything glaringly obvious wrong with it anything that could bottleneck etc!

AMD Bulldozer FX Hexa Core 3.3GHz Processor
8GB Patriot DDR3 1333MHz Memory
60GB OCZ Solid State Drive
NVIDIA GeForce GTX 560Ti Graphics

Any idea if I would have trouble running newer games on higher end graphics...
 

Answer:Hardware Specs

Your build looks good, just make sure you have an adequate quality PSU the GPU manufacturer's site will give you the minimum requirements. Low end PSU's will give you less than 80% of their rated power. So if it's a 500w it will deliver less than 400w under most operating conditions.
 

2 more replies
Relevance 54.53%

I have an Everex IMPACT GC3500.

Basically: it sucks.
After all the trouble I've gone through to get it running right (tried with both vista and then xp)... I still get bluescreen. And still have other problems. And everex won't help since I've voided the warranty.

So what I've decided to do is replace every single piece of hardware in the computer. Basically, to build my own PC from scratch.. (some'a you might say it's a waste to even buy the everex if I'm gonna do that.... but this wasn't my plan from the beginning.. it just happened this way.. :/ ).

But yeah, from the website, I got:

SPECIFICATIONS
Display: 17" CRT (1280 x 1024)
Processor: 1.5GHz, VIA C7-D Processor (128KB L2 Cache, 1.5GHz, 400MHz)
Memory: 512MB DDRII 533MHz SDRAM (2 DIMM Slots, 2GB Maximum capacity)
Hard Disk Drive: 80GB SATA (7200rpm)
Optical Drive: DVD-ROM/DVD+/-RW with Double Layer Support
Graphics: VIA Chrome9™ HC IGP (64MB shared memory, 128MB Maxumum shared memory)
Audio: VIA VT1708A Vinyl High-Definition Audio Codec (Analog: 24-Bits Max Resolution, 192kHz Max Sampling; Digital: 24-BIts Max Resolution, 96kHz Max Sampling)
I/O Ports: (1) DB 15-Pin VGA Port, (6) USB, (2) Microphone Port, (1) Headphone Port, (1) Serial Port, (1) Parallel Port
Modem: (1) 56K data/fax modem
LAN: (1) 10/100 Base-T Fast Ethernet
Card Reader: 8-in-1 Card Reader (CF Type I/II, MicroDrive, SD, MMC, SM, MS, MS-Pro)
Accessories: Keyboard, Mouse and Speakers Included
... Read more

Answer:need help getting hardware specs

9 more replies
Relevance 54.53%
Question: Hardware specs

The specs for hard drives drives indicates the 1TB drive and then also "[11]".  What is this referring to?

More replies
Relevance 54.53%
Question: hardware specs

hi,

i need to purchase computers for a software development. no problem with money, as long as its reasonable. i already have my servers, what i need are workstations. please help me with the hardware specifications (and suggested brands) for each components. so far, what i need is at least:

2 Ghz processor
1 GB RAM

thanks.
 

Answer:hardware specs

for a work station i would go

AMD 3200+(cheap) AMD X2 4200+(dual core=better productivity)
400w OCZ or Antec power supply
1gb pc3200 value RAM corsair, crucial, and kingston are best
video card-Nvidia 6200, unless gaming go with 6800GS
sound card: onboard
Case:Anything with room for expansion and good reviews.
mobo:ASUS or DFI socket 939 with PCI-E and 4 slots for RAM, SATA support
200gb minimum hdd seagate, western digital, and samsung are good
NEC, liteon, or SONY dvd/rw drive
monitor:17"viewsonic/samsung/dell are good whith monitors

If you are buying from a big name company i would go with HP the video card isn't necessary if it is only for buisness work that doens't require graphics intense programs.
 

1 more replies
Relevance 54.12%

i have been using application(Visual Basic 6) in my office which uses SQL Server 7.0,now i wants to install windows 7 in my pc,i would like to know whether sql server 7.0 database can be restored in sql server 2008.pls guide me how to do the same

More replies
Relevance 53.71%

Well it seems that the specs for Vista will be god like to run it effictively according to M$ reps. Here is a quote from the article "Hardware vendors are going to love the news that Windows Vista is going to need very beefy hardware to run well. At Microsoft's TechEd conference, Dan Warne finally managed to squeeze blood from a stone – or rather, answers about Longhorn's hardware requirements from Microsoft. Nigel Page is a strategist with Microsoft Australia. He told APC today that Vista would work best on a video card with more than 256MB RAM, 2GB of DDR3 memory and a S-ATA 2 hard drive."

Wow now that is some kinda requirements. Even with my system only 6 months old and above the Beta standards i wont meet the requirements. For the full story go here

Answer:Hardware Specs for Vista

man i might just stick to xp i mean all games support xp and if i upgrade my pc it will b equally fast as a pc with vista. Microsoft are idiots makes me want to change to mac os10

9 more replies
Relevance 53.71%

At work right now my team is trying to PROVE to management that we need to run more high end hardware for most of our duties. I strickly work with Arcview 8.2 and the processing speed for rendering is way to slow for the output and jobs that get thrown our way. I develop high scale database driven maps, that output competitors for a banking firm. I will possibly be developing 3D modeling to go into these maps in the future, so I have to PROVE that the hardware specs that I need are backed up with some proof that the software will run faster and more efficient.

So I need help trying to find this proof from a website, document, etc. I have been looking all over and there is no HARD evidence.

So guys and girls, more help the better! Thanks! :rofl:
 

More replies
Relevance 53.71%

hello all,
can't figure out how this happaned but when i right click my computer to see the hardware specs under the general tab, i'm not seeing the cpu info that i normally see at the bottom

anyone know how i can turn this back on ?

Edit: thinking about it, i remember disabling something in "services" but i cannot for the life of me remember what it was... anyone ?
Edit2: found out what it was, WMI service
 

More replies
Relevance 53.3%

I'm looking at getting a nicely spec'd server to run several VMs on.

Looking at a 2TB disk space with 32GB of RAM on it.

My main question is if SCSI is worth going to on a VM like this. The price difference is almost double the entire cost, just by going to SCSI instead of SATA.

The apps are just propriety stuff. Nothing fancy like Exchange and BES which really needs some fast HDDs.
 

Answer:Server Specs for a Virtualization Server?

2TB of disk space spread across how many disks?
 

34 more replies
Relevance 53.3%

Hi, this is a pretty broad question.Basically I'm just interested to know what people's opinions are on the current best hardware for a server.Required functions of the server:#) At least 7TB hard drive capacity in RAID5#) Ability to hot-swap faulty drives#) Able to serve 1080p video content to ~10 clients simultaneously#) Able to serve at least 2 clients simultaneously on LANNon-server like functions it will also need:#) Able to display 1080p video content (ideally through HDMI, otherwise VGA is fine)#) Able to play 5.1 sound directly#) Ability to record digital TV (optional if not crazy expensive)I don't have an infinite budget, so not necessarily looking for the theoretically best server ever, but I am interested in value, and don't mind paying a bit extra for something that is worth while.

Answer:Current best hardware specs for fileserver

Personally, I'd be looking at two separate machines - one as a file server, the other as a HTPC, to perform the non-server functions.  My reason for suggesting that, is that a case that can accommodate and effectively cool enough drives for the storage you want, plus room for expansion which I assume you'll also be looking for, would by no means be a media chassis, and probably not very quiet.  Additionally, the OS plays a large role.  I would go for Windows 7 for its media centre capabilites - the media centre is truly excellent.  However, to use it as a file server, it might not be the best choice and you may be better served (pun intended) by going for, say, Windows Home Server.  As you mentioned, it's a broad question, so it's a broad answer.The main expense in the system would be the RAID card.  They can run very expensive, so what I would actually recommend is a used Dell PERC 5 controller.  They can go on Ebay for <?100, you'd also need two SFF-8484 cables, which "breaks" the two SAS ports into 2x4 ( SATA ports.  For a little more info on going that route, check out this thread.If you don't want to go used, I'm not sure what RAID card would be best as I'm very unsure on pricing.I would advise strongly against going with any kind of software RAID, be that on the motherboard SATA controller or on a software-based RAID card (hostRAID or similar).  Software RAID in general is ... Read more

1 more replies
Relevance 53.3%

Hello,
im am planning on getting Grand Theft Auto San Andreas for the PC. I am not sure if my PC will suffer from the heat produced by this machine that causes the computer to sloow down and lose my USB ports. I have been able to play other GTA games like GTA 3 and Vice City. Will it be possible to play GTA SA with heating up

Answer:Dell 600M Hardware Specs

it should be able to play it, but there is one thing that will hold u back. ur video card only has 32mb of memory, and sa needs at least 64.

and if its heating up too much, get one of those things that go on the bottom of the laptop and has a few fans in it.

2 more replies
Relevance 53.3%

Hey all,
Just wanted to know what software you use after a fresh install of windows to view the hardware specs. I have this laptop that has a fresh format, yet no drivers installed. I'd rather not open it up to find out what drivers I'd be needing.

The laptop is a Toshiba M45, and I have the driver page, there are just a few driver options for different configurations. So I need a piece of software that can tell what the exact hardware I have.

Thanks
 

Answer:Find hardware specs after format

Wouldn't it be faster if you go to the support page for that laptop and download the drivers from there?
 

6 more replies
Relevance 53.3%

For the mobo and RAM stick, I just make sure they are of the same type (DDR2, etc.); and with the mobo and processor, I just make sure they are of the same socket type. Is this basically I need to check for in compatibility, or are there other issues too? Thanks!
 

Answer:When looking for compatiblity, which hardware specs need to match?

Please...
 

3 more replies
Relevance 53.3%

Im trying to reconfigure X after a system failure w/ *nix. I forgot to backup the xorg.conf file, which was really really stupid now that i come to think of it. x is being a ***** to install again, and now i need the hardware specs for an emachines desktop T1220.

Actually, all i need is the video card manufacturer(its onboard), and the color-depth i should use for my moniter. The manufacturer's site friggin took down product support for this comp :\

if anyone can help thanks a lot
 

Answer:hardware specs for emachines desktop

triavox said:

Im trying to reconfigure X after a system failure w/ *nix. I forgot to backup the xorg.conf file, which was really really stupid now that i come to think of it. x is being a ***** to install again, and now i need the hardware specs for an emachines desktop T1220.
Actually, all i need is the video card manufacturer(its onboard), and the color-depth i should use for my moniter. The manufacturer's site friggin took down product support for this comp :\
if anyone can help thanks a lotClick to expand...

Hi triavox,

At http://www.emachines.com/products/products.html?prod=eMachines_T1220
Video: Intel Direct AGP 3D (810e shared)

If you download (freeware) Everest Free from http://www.lavalys.com you can verify this, and it will even check the SMART status of your hard drive, monitor your temperatures, and fan speeds.

-- Tom
 

3 more replies
Relevance 53.3%

Hi! I'm trying to find the hardware specs for Acer V3-331-P352.I have searched acers website and google but can't find any details about this computer. Does anyone here recognize this computer or know where I cand find any more details about the hardware specs? Thanks in advance!  

Answer:What is the hardware specs for Acer V3-331-P352?

I found the same page you found, nothing else.

1 more replies
Relevance 53.3%

Hi Guys
I need to know what kind of hardware would I need be running for a wisp core router if I am going to be pushing anywhere from 50-200meg fiber connection and how many customers I plan to have is about around 50 customers in the first year and about 2 years I hope to have 200-300 customers and I plan on using Pfsense for my OS.
 

Answer:Hardware Specs for Core Router?

A refurb'ed Firebox could do that, but I would recommend at least an Intel Atom unit if you're going new hardware.

Lanner makes some good boxes from my experience.

Are you planning on running packages (Snort, anti-virus, cacheing, etc), tho? Those would beef up required hardware.
 

44 more replies
Relevance 52.48%

Hi, We are working on an open-source game-engine and we need to find a good balance between engine features and compatibility with available hardware that it is being used widely by Linux users. Please help us by joining this cause :

http://www.misterpoll.com/polls/521555

Best Regards, Siavash.
 

Answer:Linux gaming hardware specs survey

Might be a poor representative sample here at techspot, maybe not who knows.
 

1 more replies
Relevance 52.48%

I have an older laptop and was wondering if it is feasible to run Windows 7 Ultimate on it?
Specs below.
Thank you.
Intel(R) Celeron(R) M processor 1.40GHz
CPU Mips = 2778.47
Memory = 1017520 kB
Display = Intel Corporation 82852/855GM Integrated Graphics Device (rev 02)
Audio = Intel Corporation 82801DB/DBL/DBM (ICH4/ICH4-L/ICH4-M) AC'97 Audio Controller (rev 03)
Ethernet Card = Broadcom Corporation BCM4401-B0 100Base-TX (rev 02)
Built in Wireless

Answer:Windows 7 hardware specs - Requirements, reality, etc. ?????

Why don't you run the Windows7 Upgrade Advisor. That will tell you. In principle it should work. But don't expect a barnstormer.

7 more replies
Relevance 52.48%

I have Toshiba harman/kardon with intel cpu t3400 2.16ghz and 3072MB ram.
There was windows xp on the laptop before now i'm going to format the laptop and put a new clean windows on it.

What windows version i can put on it higher then windows xp ? Will it hold winmdws 8/8.1 ?

Answer:Can i put windows 8 on my laptop ? Hardware specs inside

Run the 8.1 Upgrade Assistant: Upgrade Assistant: FAQ - Windows Help

1 more replies
Relevance 52.48%

Vista strikes again...

My system information is not recognizing most of the specs. For instance, DXDIAG inserts an "n/a" under System Manufacturer, System Model, BIOS, Processor, and Display Device Manufacturer, Chip Type, and DAC Type, whereas the Windows System Information displays Manufacturer and Model, but not the Processor or Memory. I upgraded the RAM from 512 to 1GB and installed a dedicated GPU (GeForce 7300GS, 512 mem) a while back, so they're not the original stats. I don't have any issues generally running anything, however if I ever contact tech support for a specific program, they are never much help because the DXDIAG report does not contain all the information they require.

Thanks for the help!
 

Answer:System Recognition of Hardware Specs Problem

7 more replies
Relevance 52.48%

Our network admin is currently trying to find the hardware configuration/specs of all the servers. Between looking at the General tab of the Properties box on My Computer and msinfo32.exe, I can get all the information that I need on XP and 2K machines.

Is there a way to get this information on a Windows NT machine?
 

Answer:How to Find Hardware Configuration Specs on an NT Machine?

techgirl05 said:

Our network admin is currently trying to find the hardware configuration/specs of all the servers. Between looking at the General tab of the Properties box on My Computer and msinfo32.exe, I can get all the information that I need on XP and 2K machines.

Is there a way to get this information on a Windows NT machine?Click to expand...

try getting it from dxdiag.exe
 

2 more replies
Relevance 52.07%

Does anyone know of a database of listing somewhere to quickly and easily identify the thousand (millions even) Hardware and Software Drivers (Windows System Drivers AND Third Party Software Drivers) out there?
I work in IT support, mostly remote support, but we get a lot of BSOD customers and using Windows Debugger to identify causes of BSOD crashes is super thorough... but I guess I'm just HOPING that maybe someone knows of either a database/list somewhere... or a website with an index of some kind...
If anyone knows a way other than just googling the .sys files from WinDbg and sifting through garbage results for each one... please share.

Thanks in advance for any assistance you can provide.Does anyone know of a database of listing somewhere to quickly and easily identify the thousand (millions even) Hardware and Software Drivers (Windows System Drivers AND Third Party Software Drivers) out there?

I work in IT support, mostly remote support, but we get a lot of BSOD customers and using Windows Debugger to identify causes of BSOD crashes is super thorough... but I guess I'm just HOPING that maybe someone knows of either a database/list somewhere... or a website with an index of some kind...


If anyone knows a way other than just googling the .sys files from WinDbg and sifting through garbage results for each one... please share.
Thanks in advance for any assistance you can provide.

Answer:Software and Hardware .sys Database?

Try this: Driver Reference Table (DRT)

3 more replies
Relevance 52.07%

Professionals only answer this please.

I am wondering which of the 2 following Pentium 4 processors is most effective for Advanced Database work:

3.4GHz Intel Pentium® 4 CPU "Northwood" (800FSB) HT 512k Cache

550 Intel Pentium® 4 LGA 775 CPU (3.40 Ghz 800FSB) HT 1MB Cache

Would there be much of a difference if I bought:

560 Intel Pentium® 4 LGA 775 CPU (3.60 Ghz 800FSB) HT 1MB Cache

There is definitely a difference in price.


Thanks in advance.

More replies
Relevance 52.07%

when i try to install my sandisc imagemate usb version the the message comes up (updating hardware information database not responding )i am running windows m e.please help dogman3

Answer:hardware information database

click here

2 more replies
Relevance 52.07%

My CPU motherboard recently failed on me and refuse to boot. Before the failure, I had use the Windows 7 built in Windows backup to image my hdd that has the OS installed on. After I had replaced the spoil motherboard with a new one, I tried to restore the image back on the hdd. The restoration was successful but on reboot, I always get boot error and is unable to boot to desktop. Why is this so? Can someone elighten me?

Answer:Restore Windows 7 Image backup to different hardware specs

If you got a different motherboard, then the hardware is different and your Windows 7 won't work after restoring it. You will have to reinstall fresh and move your data back if you got a different motherboard.You've been helped by a 15 year old.

4 more replies
Relevance 52.07%

I'm starting a streetwear clothing company and need to invest in a computer for designers that I hire - most of the stuff that will need to be designed are stuff that can be done in Adobe CS3/Illustrator - in particular T-shirt designs

I have absolutely no idea what is considered to be "adequate" for graphic design - I am willing to spend a little bit more to get my designer a better than average computer for design use - just not something state of the art and over the top

In terms of graphics card, RAM and processing power, what should I be aiming for? Anything else important I'm overlooking?

If there are any graphic designers out there, I'd be interested to hear what you guys consider as vital hardware specs for yourselves when you do design work - Again, I'm not going to skimp on things, but at the same time, I can't afford the best

Also, if it's not too much, I'd also like to ask what type of scanners and color printers I should be looking to buy for graphic design use - in particular, what brands have a good rep?

Thanks in advance to the kind sould that advises me!! Multiple opinions definitely welcome!!
 

Answer:Ideal Computer hardware specs for Graphic Design

For what you're planning on doing, the three areas you're going to want to focus on are:

Processor
RAM
Hard Drive

for 2-D graphic design, a video card is the least-crucial component. If you get into 3D rendering and maybe gaming, then you need a high-end video card.

For working with large graphic files and images, you need lots of storage space for your files (big fast hard drive), a lot of RAM to have multiple files open simulaneously (at LEAST 2gb), and a fast dual- or quad-core processor to speed up your file conversions and photoshop work.

I'd suggest stuff like this:
Processor:
http://www.newegg.com/Product/Product.aspx?Item=N82E16819115017

RAM:
http://www.newegg.com/Product/Product.aspx?Item=N82E16820145034

Hard Drive:
http://www.newegg.com/Product/Product.aspx?Item=N82E16822136205

These are just examples, of course, and depending on things like what motherboard you have, will vary depending on your exact system.

As for printers/scanners, I've always had good experiences with Canon products, and Epson work well too.
 

2 more replies
Relevance 52.07%

Hi there.

Don't always believe the Mobo specs -- I decided I needed to upgrade HDD space on one of my servers - in theory it says on the 4 Bays I could have a total of 10 TB HDD space. Anyway I've installed 2 X 4 TB and 2 X 6TB Nas 24 *7 drives -- no problem whatsoever -both running super dooper fast as RAID 0 arrays -- get REALLY fast I/O - up to around 582 MiB/s when copying between the 2 arrays. I've enough backup so RAID 0 for me is fine --does what it says on the tin --super fast I/O which is what I want. I have the OS on an SSD and 4 data drives configured as 2 X RAID 0 arrays.

The power supply could have been the weak point but there is more than enough "juice" so these days take HDD limitations with a pinch of salt.

When initialising the HDD's on Windows I did get a message "GPT error" and "Invalid partition table" but I used GPARTED from Linux to format the drives as XFS and create the RAID 0 arrays (using software mdadm --really works well)--and worked fine.

It could be Windows gets problems with large HDD's -- no problem on my server (old HP Microserver Gen 8 ProLiant -- probably obsolete now -- the later micro Gen 10 ProLiant microserver IMO isn't as good -- especially as on the older GEN 8 you can swap the CPU for a decent XEON -- the newer gen 10's have an AMD processor (quad) which is decent but it's soldered to the board so you are stuck with it).

So check hardware out first without always believing the specs... Read more

More replies
Relevance 52.07%
Question: server specs

I am looking to renew the server on my school network. We run 16 stations in a suite and 24 PCs n classrooms. The current system is a P111 machine. What does anyone reccommend nowadays as a medium capability server box?

Answer:server specs

This may get a better response in the Networking Forum?

1 more replies
Relevance 52.07%
Question: Server Specs

Hey guys, I have a random question about setting up a multipurpose game server. It will be for hosting different types of games to eventually a small MMO mod that I am working on. I know that RAM, hard drives and CPU's are important, but are graphic cards? Would someone mind recommending some specs. Price range from 2-5k.
 

Answer:Server Specs

anyone?
 

1 more replies
Relevance 52.07%
Question: server specs

im planning to build a windows 2008 server cpu to handle these tasks

primary domain controller
active directory
file server

what would be a good spec but not to costy thanks.

Answer:server specs

From a processing performance standpoint, none of those tasks require hardly any power whatsoever. Within Active Directory, there really isn't a concept of a Primary and a Backup domain controller anymore. They are simply just domain controllers.

There is no need for more than about 2GB of RAM for the setup that you mention. The biggest area to concern yourself with is high speed hard drives and sufficient capacity. Obviously the amount of data you will store and how many employees you have have accessing it will be the determining factors.

You might even consider making the domain controller a virtual machine. This way backups and the like are super easy and you can quickly restore or snap back if something isn't planned right at the start.

1 more replies
Relevance 52.07%
Question: Server specs?

How hardware intensive would a small AD, DNS, File server be? (75-100 users at most, logging in, using IE and Office)

Is that something you'd config up with a high end CPU? Lots of memory, etc?
 

Answer:Server specs?

It would really be a mid-ranger, Dont skimp on anything though, i would usually go with dual processors (you could get away with a single socket) and a fair bit of RAM (4gb at the least). If your doing roaming profiles or folder redirections then make sure you got some fast, and large hard disk arrays. Should all be possible for around £1500
 

10 more replies
Relevance 51.66%

I have tried to install two Plug & Play devices to my computer, but when the UHID dialogue window opens I have waited over halfhour for a response to show in the progress bar. I have gone into Task Manager and found that UHID is not responding. I have also tried to get Driver Updates via Device Manager and the same thing happens. I have contacted Microsoft Support and after almost two hours help all I have achieved is an apology that they cannot help me. My computer details are, Pentium III 550Mhz, 128Mb RAM,Windows ME OS, 16Gb HDD. Can anyone help.

Answer:Updating Hardware Information Database

Most hardware comes with it's own drivers and an install program. Try using that instead.

5 more replies
Relevance 51.66%
Answer:Updating Hardware Information Database

Since having to reformat my hard drive (after my son managed to corrupt my PC), I have not been able to install any new Hardware or Software. All that happens is that I get a message and progress bar saying " Please wait while Windows updates the Hardware Information Database ". No progress is ever made and the machine (Evesham 733) just hangs and I have to re-boot. I'm using Windows ME (it won't allow me to upgrade to XP)and wondered if anyone might have any suggestions as to a way of resolving this.Thanks V Much !!

10 more replies
Relevance 51.66%
Answer:updating hardware information database

Whenever I try to play games or play music today I get this message "updating hardware information database" I leave it for a while but nothing happens so I press alt control and delete and the message comes up that it is not responding.Iam a new comer to computers so forgive me if this is really simple.

2 more replies
Relevance 51.66%

Hi All, I've bought the Acer Aspire M3641-X223W about 6 years (?) back. Now i want to use it for my homeserver (maybe upgrade some things). But i need the full in depth specs of the hardware. I know the general specs (4GB RAM, 640HDD, RADEON 3450, Intel Core 2 Duo E5200), but especially the in depth specs of the motherboard i couldn't find. For example the manufacturer (if this is not Acer), type / etc.  Is there one overview where all the specs are mentioned? I could not find it that easy online or on the website of Acer. Thanks!













Solved!

Go to Solution.

Answer:Acer Aspire M3641-X223W - Full Hardware Specs

Not sure if the link below is your computer. http://www.crucial.com/usa/en/compatible-upgrade-for/Acer/aspire-m3641 It probably is an Acer motherboard, but I really don't know if Acer has their own factory or if they contract it out to someone like foxconn,etc... http://www.newegg.com/Product/Product.aspx?Item=N82E16813186140 Note: My links are just guesses/examples and may not even be remotely accurate guesses. Edit: Even if that foxconn motherboard is similiar to your motherboard, Acer probably has it customized....so not all of the ports/headers would be accurate.

5 more replies
Relevance 51.25%

Hi all,

I just made a purchase (maybe I should have checked here first); but it was a Dell PowerEdge 1800. I customized it to my liking, but I'm not sure if it was overkill or underkill. Please you be the judge. First let me tell you what I'm trying to accomplish with this new server. It will be my home-based web server and database server (MySQL). I will install Windows 2003 Server onto it, MySQL 4.1, PHP5, ActivePerl 5.8, IIS 6.0, and that's about it. It will become part of a existing domain, I'm not sure if I am going to dcpromo it or not, but as of now that is a "no", I will leave it as just another server on the network without any administrative duties outside of web and database. Currently I only have a combined total of 500 users a day coming to my websites. I'm host my websites currently on a single PIII box w/ Windows 2003...a Dell Optiplex (desktop ...not server). It has not given me any trouble or headaches as of yet, it's actually been doing very well, but I don't have much traffic so that might be why. In the coming months i plan to advertise aggressively as well as host a few other people websites, so I knew I needed a better system, as well I will be hosting a new website of mine which will be a online blog host for visitors to sign up and have a blog through my network, therefore I needed something reliable. My goal is to have at least 15,000 to 50,000 visitors per day by this time next year. So I would like to know if these specs wou... Read more

More replies
Relevance 51.25%
Question: Mail server specs

I have a windows server 2003 right now that does my antivirus / antispyware. It is a dual xeon 2.4ghz, 3gb ram, 2x 200gb IDE hard drives mirrored. With the Trend Micro Viruswall running, typical usage is 5% CPU and 650mb RAM. I'm thinking is has plenty of horsepower left to hold a Merak Icewarp mail server for about 80 users. Our daily mail volume is roughly 1000 messages.

What do you guys think? Go with it or rethink the idea? Since the Merak has antivirus and antispam built in, I may even disable the trend scanning since it's scrubbed through a Barracuda before it hits my network.

Do any of you have experience with the Merak software?
 

Answer:Mail server specs

80 users will, over time, generate a lot more than a 1000 messages a day in spam alone. But that's beside the point; The hardware looks fine except for two things.

1) Disks. You have essentially 1 disk's worth of bandwidth. I wouldn't rely on this, opting for a raid 5 array of some sort.
2) No backup device. I see no way to store the data offsite or to do nightly backups.
 

6 more replies
Relevance 51.25%

Hi all,I am wanting to get a desktop computer to act as a server for a small group of 7 computers to act as an internet gateway, manage our emails, store shared files and act as a printer server - we mostly use MS office files and therefore have no large image files and our bakcup file is currently only around 700mb. I am trying to get an idea of what specs the computer should have in order to run an efficiant systen. Also would we only need a firewall on the server and router and virus software on the server???? thanks

Answer:server computer specs

a fairly basic machine machine such as a Dell poweredge (advertised in the front of every pc magazine you see) will cover your needs and offer plenty of scope to upgrade. this is just an example not an endoursement there are thousands of alternatives almost any PC would do if it has plenty of memory and storage. as to the other question you will still need anti-virus software on each workstation as the internet is NOT the only source of infection but you will only need a firewall at the internet gateway.

6 more replies
Relevance 51.25%
Question: File server specs

What kind of spec's should I be looking at for a file server using software RAID 5 in linux? I was thinking an old P2 or P3 system with piles of RAM say 2GB? For speed I was thinking somewhere in the 833MHz range. It will just be doing pure file/print serving so nothing fancy.
 

Answer:File server specs

lol I used a dual 200mhz pentium pro with 512Mb of SDRAM PC133, and 12x 9.1gb scsi disks for an ftp server for lan parties with software raid on freebsd 4.8....it ran very well. I would say if its for casual file access, your box will be way overkill
 

16 more replies
Relevance 51.25%

First im going to give the run down of the entire network setup.

Ok so the network i'm on runs through a proxy server for web filtering. Blocking porn, torrenting and such. The internet from the isp comes in via WiMax and from the receiver it goes into the computer hosting the proxy sever. The internet after the proxy sever goes into a switch that connects about 30 devices via LAN connection and one amplifier that supplies WLAN connection to about 50+ devices. The proxy software used is IPfire. its an open source program available for free download.

The computer hosting the proxy is an old dell that was a windows xp computer that was used for cadding about 8-9 years ago. what would be some ideal specs for such a computer. Even a better proxy server software that is better than a 'free-open-sourced' piece of crap. Its seriously malfunctioning. like right now i cant go on a subreddit because its blocking it. in a few minutes i'm sure i'll be able to go on it again. the access denied page that comes up on it is not the one that should come up when it blocks the content it should. every website i've had this issue it says something about "domain cannot be reached" or "proxy cannot determine website ip address"

im to the point where im going to thrash the shit out of that computer if only there wouldn't be so many finger point back at me. what is the biggest issues I'm facing with this network configuration?
... Read more

Answer:Proxy server specs.

You know that your having dns issues right?
Check the dns settings on the proxy computer.
My guess is there are invalid dns servers set up on it.
Change it to google open dns servers for testing.
 

5 more replies
Relevance 51.25%

Anyone know where i can find the system requirements to run a Linux dedicated server for the following games:Quake 3 and 4Doom 3UT 2003 and 2004Im asuming that it will be around the requirements for the game itself less the grafics requirement? Requirements for a simple 1 on 1 would be apreciated and i can work up from there.

More replies
Relevance 51.25%

when i try to add something like a scanner or a game pad on restart i get the updating hardware information database window,which stays at 0%.programme is not responding

Answer:updating hardware information database - not respo

What operating system are you using?

6 more replies
Relevance 50.84%

I need a machine to use as a pilot test machine for a new green-field set-up. I'll use the laptop as one of the main servers when the site starts - a laptop as a server makes sense, for a small <50 people site, as it's cheaper & smaller than most servers & has a battery.
The specs I'm looking for are:

802.11ac - I need the speed & coverage area to share images (a big part of the work)
1000base-T LAN connection
16Gb main memory - I need multiple virtual machines for different software
1TB disc 7200RPM or greater
or.. 1TB disc + 128GB internal SSD
or.. 1TB disc + Thunderbolt for an external SSD

Screen, keyboard etc don't matter, of course. I expect it to cost around £1500.
I've been hunting all over the place, but this combination seems hard to find. I can find 1TB discs, but they're slow, at ~5000RPM, which will cause a peformance bottleneck.
I could have an external router for the 802.11ac, but I'd rather use the machine as the main network server - if we had three laptops with 802.11ac strategically placed, we should be able to provide complete coverage of the space - one floor 50m x 40m.
I could have less than 16Gb of main memory, but then a multiple virtual machine will be slow with all the swopping.
I could have a USB 3.0 connection to external SSD, but that'd be half as fast, which seems pointless when you go to the trouble of having SSD.
Any suggestions would be gratefully received!

Answer:I need to buy a laptop to use as a server - I can't find one with the right specs!

Can't you find a shorter user name. Your current one destroys the formatting on the forum.

4 more replies
Relevance 50.84%

I am looking to build a simple home server, but running Windows Server 2011: SBS Essentials. I'd like to use it as a media server, file server, backups, etc.. Nothing huge.

Would something like this work out and still be speedy?

Pentium D 820 (2.8 GHz dual core Pentium)
4 GB DDR2 RAM
Consumer level M/B
Intel Dual GB NIC (teaming for 2 1Gb links to switch - for fun, not speed)
Plenty of HDD space, no RAID (possible RAID1 on backup drives)

It's a 64 bit only OS, and I'll be running TVersity on it (for encoding videos before sending it to Xbox) as well as standard folder sharing for the HTPC's (2). Not a lot of clients, but I'd like to be able to stream 2-3 files at once with no slowdown.

My guess is that Yes, it will work. But, I don't want to be disappointed and spend some $$ to get it going and have it suck. My only expense will be the HDD's (3 x 2TB for now) and MB. I have the CPU. Other option would be to get a i3 CPU (have a MB for it and RAM) for ~$100.

Also, aside: how does the PentiumD do with Folding?
 

Answer:Home Server with SBS2011 Specs

I have SBS 2011 Essentials on a Atom D525 with 4 GB of RAM server. It runs just fine, no complaints. I'm not sure how well your processor will work for TVersity though. You may need a beefier processor for the encoding.
 

1 more replies
Relevance 50.84%

Hey,any ideas where I can get Linux from as I'm wanting to start a Minecraft server. Also what sort of specs would I need for a Minecraft server with Linux?Thanks

Answer:Where to get Linux? Specs for Minecraft server?

click heretry thisgel

10 more replies
Relevance 50.84%

Hello to everyone i'm a new user here hope someone can help me !

I am searching for server specs for a medium business

These are the 4 Servers i am searching for :

Active directory server

Back up server

Mail Server

Print Server

does anyone knows a website were i can find info on these servers ?

Hope someone helps me !

Alexander :-)

Answer:Need Server Specs for a Medium Busines

the print server doesn't need to have any real power. Depending on what you're looking for, you can just buy a device called a print server (a relatively small box), which you'd typically see listed next to routers and switches in shops, and connect that to the network.
It would be cheaper to do that than buy a PC for the job.

How much data do you need backed up?
You can get hard drives in terabytes now, so if that's enough storage space, you could just get a couple and put them in a RAID 1 (which mirrors the drives so that each one has a copy of the same data, in case one fails)

how much workload do the other servers need to handle?

1 more replies
Relevance 50.84%

Hey, I was looking around and didnt seem to find the minimum hardware specifications for the UltraVNC server. I imagine it wouldn't be anything too demanding.

I was wondering if a 1.3GHz Celeron and 256mb of ram running windows XP would do it?

http://www.uvnc.com/index.html
 

Answer:UltraVNC server minimum specs?

Just as a single host? Or are you looking for the LAN mirror/repeater?
 

3 more replies
Relevance 50.43%

I found out that I can't mount my .mds files. Then, I suspect that it is because my .mdf files are now associated with my SQL Server 2005. Meaning, the icon is the icon of the SQL Server program. But when I tried opening it, it gives me the "Open With" window.

How can I make it a "alone" file? (The icon is just a white page).

Answer:SQL Server Database associated with .mdf

Quote:





Originally Posted by cazua


I found out that I can't mount my .mds files. Then, I suspect that it is because my .mdf files are now associated with my SQL Server 2005. Meaning, the icon is the icon of the SQL Server program. But when I tried opening it, it gives me the "Open With" window.

How can I make it a "alone" file? (The icon is just a white page).




What do you mean by "alone file"?

And right click on a .mds file , Properties, General, and next to "type of file" click on CHANGE.

And then scroll to the desired program you want to associate the file with and then that program will open those files.

2 more replies
Relevance 50.43%
Question: Server Database?

Hey Geeks,

I want to come with either a database or just an easy way to track about 10-12 servers I have. Stuff like their specs, os, resources. Anyone know of a good way to do this? I can't think of an easy way.
 

Answer:Server Database?

do you want to manually enter or scan the pc?
 

18 more replies
Relevance 50.43%

Server 2012 was released to TN today in case you didn't notice.

I have yet to be able to find a full feature list for Server 2012 Foundation.

The one on Wiki doesn't list the features I'm curious about, namely drive pooling and client backup.

I was hoping foundation has these due to the stupid mandatory ActiveDirectory configuration in Essentials.

It does NOT appear Standard has Client Backup. Weird.
 

Answer:Full Specs for Server 2012 Foundation ?

Pooling is in all versions and client backup is only in Essentials I believe.
 

3 more replies
Relevance 50.43%

Estimated Ship Date: 07/23/2008

Item Number Quantity Item Description

222-3376
1 Dual Core Intel® Xeon® 3040, 2MB Cache, 1.86GHz, 1066MHz FSB

311-6676
1 4GB DDR2, 667MHz, 4X1GB Dual Ranked DIMMs

310-5017
1 No Keyboard Option

341-4179
1 80GB 7.2K RPM Serial ATA 3Gbps 3.5-in Cabled Hard Drive, Primary

341-4181
1 Onboard SATA Controller - No RAID

341-2489
1 No Floppy Drive

420-6320
1 No Operating System

310-0024
1 No Mouse

430-0488
1 On-Board Single Gigabit Network Adapter

313-4359
1 48X CD-ROM Drive

310-8358
1 Electronic Documentation and OpenManage DVD Kit

341-3796
1 Onboard SATA, 1 Drive connected to Onboard SATA Controller - No RAID

970-5662
980-2100
985-0358
985-0367
990-1689
1 3Yr Basic Hardware Warranty Repair: 5x10 HW-Only, 5x10 NBD Onsite

900-9997
1 No Installation Assessment

Order Subtotal: $526.26
Shipping and Handling Total: $19.99

Tax Total: $38.24
Total Charges: $584.49

It'll serve as an application server (one small piece of software for a construction company; they're purchasing it and I'll be installing it on this server; the software maker says that the application can run fine on even a PIII or P4) and file server (after I put in two (2) 750GB SATA drives in there from TheEgg, since it's cheaper)

Inputs?
 

Answer:Just ordered this server; please tell me what you guys think (specs; price; etc.)

Decent price although I would have gone with a HW RAID solution, if those drives get nuked you'll be in trouble. Be sure to get good backups daily!
 

44 more replies
Relevance 50.43%

I have a game that runs on a certain hardware requirements. I have an old p3 laying around that i can use for dedicated server but it doesn't match the minimum requirements of the game.
my question is: Can i run dedicated server on a pc with less requirements from what the game has given me?

BTW i dont care that its in the wrong thread , im just looking for a quick answer

thnx

Answer:Running Dedicated server on less than required pc specs

It depends on the game. Some games you can download a separate dedicated server file, and don't need to actually install the game.

3 more replies
Relevance 50.43%

Currently my XP1900+ w/ 1.5GB RAM folding box is fulfilling these roles under Ubuntu Server 6.10

http server
dhcp server
dns cache
samba server
mpd server + jinzora server (connected to stereo)
mysql server
openvpn / ssh server
running boinc 24/7 @ 80% cpu
running torrentflux (although I want to move this to something else to lower the cpu usage)
firewall / routing

I was thinking about picking up a dual 500Mhz P3 w/ 1gb or something similar (running linux) to take the load off the folding machine.

Does anyone have any suggestions for a router box and which roles it should take from the folding box? Currently there are 4 clients (2 xp, 1 os x, 1 linux) not including the folding box on my internal network connected by a 16 port linksys switch.

For the real IT people, what should I look for to manage my home network? Any advice would be nice
 

Answer:Minimum Specs for Router / HTTP Server / etc

I think you should be fine with what you have listed, depending on the level of usage you have.

I guess I should give you an example of what I have running on my server, and it's roles.

It is an old Dell Poweredge 2400 with a pair of P3 450's, and 768MB of RAM with a couple 10k RPM 36GB and 9GB HDD's.

It is running Windows Server 2003 Standard Edition, and it is a Domain Controller, DNS Server, FTP Server (IIS), Web Server (IIS), Mail Server (hMailServer), File Server, Streaming Media Server (Vibe Streamer), Torrent DL'er (uTorrent), VPN Server (OpenVPN; Windows Clients), and of course it runs A/V, and a couple other network monitoring programs.

All in all, I have had no problem at all with the performance of the machine except when I get complex PHP scripts going.
 

1 more replies
Relevance 50.02%

I have started searching around for the correct docs on how to do this but haven't had much luck finding one that addresses what I'm trying to do.

I have an existing Windows 2000 server and am going to replace it with a server running Windows 2003 Server R2.

I would like to know the best way of doing that. Most of the docs I have seem talk about it as though you're keeping the same server hardware in place. That's not what I'm trying to do.

So, you don't have to go through all the steps I need to do. If you could just point me to the correct doc and give some helpful hints I would appreciate it.

Thanks.
 

Answer:Help Needed To Migrate Windows 2000 Server To Server 2003 On New Hardware

Need to know what services you are running on the server to be able to help you further.
 

7 more replies
Relevance 50.02%

Hey guys, I didn't know if this was the best place to post or what. We are turning our break fix office into a managed service/contract and the new software we got to help us with this minimum requirements are "3.0Ghz Quad Core CPU with 3GB or more, 2 physical disks, 60GB in space."

It is based of SQL so I know more memory and Raid 10 would be good.

I was just hoping someone could help me select parts for the build. I do not care if it is consumer motheboard vs server grade. I need to do this as inexpensively as possible in a rack case.

Any help would be great.
 

Answer:Application/Database Server

You are correct the biggest thing with SQL is IOPS and RAM (lots of both) I would put OS on a RAID 1 and Databases on a RAID 10 array with battery back cache on the controller. Make sure you have x64 OS and SQL and put as much ram as you can afford. If this is misison critical I would also buy a second server to replicate to.

Start as you mean to go on with SQL, make sure you plan it correctly from the start with enough head room for growth, there is nothing worse than having a 24/7 database that is stuck on a single underpowered server that you thought would do the job 12 months ago but now wish you had maybe planned ahead. (take this from experience, I have some one elses mess to try and fix and its not nice)
 

1 more replies
Relevance 50.02%

hi All,I am trying to move one database from a sql2000 server to another using the move database wizzard.the wizzard finished with unspecified error, but i can't see the database in new server.is there another way to move databases without having to create the sql scripts and import data back to the tables?many thanks.

More replies
Relevance 50.02%

I'm using SQL server 2012 on my Windows 8 system and I have noticed that whenever I try to connect to a specific database which is displayed as "suspect", the connection fails everytime. All of my work is getting affected because of this. Please help me in resolving this error.

More replies
Relevance 49.2%

I have a client with a web server running Windows 2000 Professional. They also have a server on the network running NT 4. They have been told that there is a device that will route requests to the NT server if the 2000 server is down that costs about $100. I have not heard of such an animal, and if anybody can shed some light on this I'd really appreciate it. The device should somehow, I suppose, automatically detect that the machine at IP address A is not responding, and route the web request to IP address B. Anybody?
Thanks,
Michael
 

More replies
Relevance 49.2%

I have experience with MS Exchange Server 2013 for two years. But today I have seen - Corrupted header information, when I opened program. How did it happen? What to do?

Answer:microsoft exchange server database

Beats me.

Perhaps elaborating on your issue would help. Right now I can't tell if the problem is with the sql server software itself, the OS it's running on, the application you're using...

2 more replies
Relevance 49.2%

Hey everyone, I am purchasing a new DB server for a disk intensive/cpu heavy database. My main questions are with the storage controllers and RAID setup.

This is my current thought:

RAID 0/1 36GB 15K SAS - OS and programs
RAID 0/1 72GB 15K SAS - main data
RAID 10 72GB 15K SAS - trans table (main table, most IO) from DB

What are your thoughts? Should I be looking at a dedicated controller for the RAID 10 and put the other RAIDs on a different one?

Any suggestions or recommendations would be very helpful.

Thanks,
Manu
 

Answer:Database Server RAID Setup

Which DB Server? (MS SQL, MySQL, Oracle, etc) What size DBs? How many transactions per day?
 

3 more replies
Relevance 49.2%

What is the bad reason behind SQL server corruption and how can I resolve it after MDF files corruption.? i want read about more information about this SQL sever corruption and how to fix errors and recover MDF files.

Answer:Bad reason of SQL server database corruption and how can fix...

There are many reasons that will cause SQL Server database corruptions, including: 1. Hardware failure, such as disk failure, power interruption, etc.2. Software problems, such as defections in SQL Server itself, malware, virus, etc.3. Human misoperations. When SQL Server corruptions occurs, then the possible solutions are based on the situation: 1. If the corruption is not severe, then you can use the SQL Server build-in command DBCC CheckDB to correct the errors. See http://technet.microsoft.com/en-us/library/ms176064.aspx 2. If the corruption is severe, then you may try some third party tools such as DataNumen SQL Recovery to scan and recover the data from your corrupted MDF and NDF database files. Good luck!

9 more replies
Relevance 49.2%

I have experience with MS Exchange Server 2013 for two years. But today I have seen - Corrupted header information, when I opened program. How did it happen? What to do?

More replies
Relevance 49.2%

I have installed SQL EXPRESS Management Tools but I cannot get it to do anything.

If I try to create a new database, I just get an error saying "Access to the database file is not allowed".

Also the object browser screen ( on the left ) is completely empty.

I have no existing files to connect to.

How do I get started ?

Answer:SQL SERVER EXPRESS 2008 will not allow New Database

Perhaps some help for you here:

Getting Started wiht SQL Server 2008 Express

A Guy

1 more replies
Relevance 49.2%

A friend has asked me what is the best was to move her MS Access database to a new server at her workplace as the IT guys there have said they dont support that format so cant help for some reason.it needs to be moved because of disk space problems.Also, this database takes data out of a spreadsheet using paths so the paths need to be re done. what is the easiest and quickest way to move the paths aswell?

Answer:Moving MS Access Database To New Server

The IT guys seem to be looking for an excuse not to do the work. I would have thought that they could have moved the main database with ease as it is a file. The bigger problem is with rebuilding the links and whoever built the database may have to do that.There are others on this forum better qualified to give a correct answer than me so it may pay to wait until they have a look at this.

5 more replies
Relevance 49.2%

Hi ppl!

I have a pretty specific problem. I'm a total newbie on databases, so I hope one of you can help!

I'm upgrading an application on a corporate server which use a SQL database. They already have SQL Server 2005 installed on the host for other purposes, but at the time of the original install the app I'm upgrading only supported SQL Express, so they had to install it on the same host and create a new database.

The new upgrade supports the full-blown server, and the wish is to move the database from the Express instance to the server.

As I said, the two SQL installations reside on the same host, and updating the app with the new database details should be easy. So I guess I'm wondering if there is an easy way to merge or import the "old" Express instance or preferrably only the database I need.

Their db-guy is out of town, and I really have to get this upgrade done halp!

They use Management Studio to manage both instances.

thanks in advance guys!
 

Answer:Moving SQL Server 2005 Express database to SQL Server 2005

Hey there, welcome to TSG

Are you trying to port the database or the server configuration? If it's just the database, you should be able to create a dump of it and import it into the new server. I don't know how to do that with SQL Server, but you could probably Google "SQL Server 2005 database dump" and find some relevant material. If it's the server config, is there an .INI or .CONF file you can copy over?

I guess I'm not being much help because I have no experience with SQL Server, but in general a database port should be simple enough as long as both engines support the same data types. There should be very little push-up to get from 2005 Server Express to 2005 Server Enterprise.

Here seems to be a pertinent link to a Google Answers thread:

http://answers.google.com/answers/threadview?id=781934​Is there help documentation for Management Studio? I'm sure there is a built-in utility to handle imports and exports.

HTH

chris.
 

1 more replies
Relevance 48.79%

Hi,
we have 25 computer, I want to make Outlook using Pop3 settings for all computer and all email database should store in Common Windows 2003 Server. so all staff email should store email in windows server 2003. please help me out this.

regards
abdul rahman
 

Answer:How to configure Email Database for windows server

All users have to have a username to log on to their computer in the first place, All computers also have to be linked to your server, and then what ever computer they are on, Microsoft Outlook configured to their name, Best if you ask your IT Guy/Girl to sort it. Go get your IT Person and watch and learn.

Below the basics for configuring Microsoft Outlook I am not putting anything further in here

When opening for first time (Microsoft Outlook) Click on &#8211;
· Mail
· Setup Email
· Add Email Account
· Next
Microsoft Exchange Server
· Next
· Untick first option
· Type in &#8211; (usually Svr (number). (server name.local) or combinations of this your IT person should know what it is
· Enter Name
· Click &#8211; Check Name
· Next
· Then Yes (for Different)
· Finish
· Close

Open Microsoft Outlook
(if not own email)
Select Name
Tools
Email Accounts
Dot &#8211; change
Next
Change to mail box
Finish
Ok then close email
 

1 more replies
Relevance 48.79%

Hey all,

If anyone can help, got a major issue.

I'm re-egineering a reporting system for a company I am employed with, but the current system, which needs to continue running while I implement the new system, has developed a strange problem.

The current system operates through Microsoft Access, but uses SQL Server database tables as its source, not Access' proprietry database format.

We have a collection of forms, some of which have subforms on which reference other tables. Now, the problem which has developed is, when data is changed on the main form, and the user tries to perform actions on the sub forms, they are greeted with a lovely 'write-lock' message, and they are forced to drop the changes they made to the original data.

I have no idea why this has suddenly happened, and am wondering if you guys have a solution?
 

More replies
Relevance 48.79%

This question is more geared towards network admin's. I am currently using the old fashioned excel spreadsheet to keep track of IP and Port asssignment's whenever we setup a server in our data center. Curious what other options that are out there that are either free or low cost to take up such daunting and time consuming task. Basically looking for the following:

-More than one user able to work in updating IP and ports at time
-instantaneous updates to the document/sheet
-locking of fields when information is being updated.

Any info would be greatly appreciated.
 

Answer:Server IP & Port assignement database software?

if you've got excel going, you should be able to setup a small access database to do that.
pretty simple from what you've said you wanted in it. plus you can import your existing information.
 

11 more replies
Relevance 48.79%

I am using SQL Server 2005 database namely ABC on my office using dynamic port TCP/IP. My server containing static IP address 192.168.1.9 and my router containing 192.168.1.1 IP as gateway and the internet static IP address is 59.90.157.83. Now I want to connect my office database over the internet from my home through ODBC. I have enabled already port forwarded 1433 to server on my router.

Please explain how do I connect my ODBC database .

Thanks and regards

Showkee
 

Answer:Solved: Connecting SQL server 2005 Database

This should help:
http://social.answers.microsoft.com/Forums/en-US/addbuz/thread/1ac018ce-b96d-42ae-ae38-01f9d8c02d95
 

1 more replies
Relevance 48.79%

Hi,
I'm running windows 7 pro machine to share a folder of data bases for few programs we run in the office.
the folders protected by local user permissions and the client computer have a mapped drive based on these credentials.

There is anything else i can do with low budget to secure the server against non-authorize access?
Thank You!
 

Answer:hardening database server based on windows 7

Make sure all admin passwords to the database are complex and long.

A lot of the burden for security rests with those applications that access the database. If the applications are buggy, then you won't have a secure database.
 

1 more replies
Relevance 48.79%

Hello,

My database in Ms-Access and I want to take Daily wise Back up of database on server(seprate folder).Code has been written in ASP.

Please HELP me , how can i solve this problem.

ITS VERY VERY urgent for me.

Waiting for your Reply.

Thanks
 

Answer:Daily database backup on server in MS-Access

What sort of database are you using, one stored in an MS Access file (using JET)? Or do you have another type of database, like MSSQL?
 

5 more replies
Relevance 48.79%

Due to sudden power failure issues; one of my SQL server database seems to have problem. I have tried detaching and attaching it again but getting SQL server error message 5172. It looks like my database is corrupt.

Can anyone suggest any tips/methods that help me in extracting data from my corrupt SQL server database?
 

Answer:How to recover SQL server database from corrupt mdf file?

Interesting. Word for word posted in this forum back in May 2015

https://community.spiceworks.com/to...ver-sql-server-database-from-corrupt-mdf-file

and this one 1 month ago.

@V_R @muckshifter
 

6 more replies
Relevance 48.79%

Let me start by saying that I'm a low level tech trying to solve a higher level problem, so what may be obvious to some people is likely unknown to me.

We had an access 97 database on a shared folder on a workstation at one of our remote facilities. Recently we put a Windows Server 2003 machine over there to, you guessed it, be a server. The share and all the files were moved off of the workstation and onto the server.

The only real change that I noticed is that when they open any of the files on that drive, it now comes up with an Open or Cancel dialogue box. This is no problem, just an extra step. The problem comes when someone is inside a particular database. If one person has the file open, Windows will not allow a second person to open the file. If they try, it just sits there, they don't even receive the Open or Cancel dialogue box until the person with the file open closes it.

EDIT: I should point out that the permissions seem, to me anyway, to be the same as they used to be.

Any ideas?

- Pat
 

Answer:Access 97 Database on Windows Server 2003

Pat, check that the users "shortcuts" have not got the "Open Exclusive" set.
 

1 more replies
Relevance 48.79%

Hi All,

I've recently rebuilt a server for our Reports Database, installed SQL Server R2 2008 and updated to SP2. Installed all the preqs. However when restoring our test database, it takes forever to restore, literally hours. Is there something I missed? Any suggestions would be greatly appreciated.

many thanks in advance

Dre
 

Answer:Issue with SQL Server 2008 R2 SP2: Database restore

First, investigate the technique being used: A binary image restore of the files OR just a plain SQL REPLACE. The binary restore is not the default, so I am afraid you're into the slow route.
Make sure you are not doing record at a time and are using the batch mode

If there's 1000's of records, ditch the indices:

DELETE all secondary indicies from every table (keep the definitions obviously)
Then RESTORE - - the base tables will fill much faster.

When done, update the schemas to add back the indices, and you can then write
SQL recreate the index data from the base tables.
​Being the SQL-DBA is fun :sigh:
 

1 more replies
Relevance 48.79%

I installed sharepoint 2010 on a vm of 2008R2 a few months back, but since this vm is hosted on a computer that often is hibernated, I did not want the SQL database running in a vm (note non of this is production).

A week back I setup a 2008 SQL server on a machine with a RAID5 share, was starting to play with forefront endpoint. Anyways, I wanted to move my sharepoint database over. Following technet's instructions, I successfully detached each database, moved the files over to the new SQL server and attached them. At the end, I created an alias on the old SQL server pointing towards the new one.

On the old server I tried SQL studio, connecting to the local (old) server and it successfullly connected to the new server. But when I try to get into sharepoint administrator console, all I get is "cannot connected to configuration database".

Any thoughts on this, maybe I missed something? Its not a big deal, I am doing this to learn, so rather have something break so I know how to fix it.

Thanks!
 

More replies
Relevance 48.79%

Hi guys. I want to restore an Exchange server's backup I made directly to disk using NTbackup.

I didn't do a system state backup, so I don't have the AD users in the fresh Windows 2003 installation.
Excuse my ignorance, but if I restore Exchange's backup, will it work? I mean, will I recover the users with their associated exchange objects without doing a system restore?

What I want to do is to test the integrity of the backup. I do not want to make it part of my production network and don't want to create any conflicts with the running servers, so I installed Win 2003 & Exchange on a virtual machine.

I encountered a problem.
When telling NTbackup the backup's destination, it didn't recognize the Exchange services. It said "The specified computer is not a Microsoft Exchange server or its Microsoft Exchange services are not started exchange 2003".

Thanks in advance for the assistance.
 

Answer:How to restore to a fresh server an Exchange database?

With a system state this would be easy, but without you'll need to attach this server to the network as a BDC.

Install and configure exchange as you would on a new exchange server, make sure the AD has replicated and then do your restore. You should be ok.
 

6 more replies
Relevance 48.38%

I have a customer who has an old Win 2000 server with a proprietary real estate database on it. They've gone to a new web based database, but still need the historical database on the old server. That darn box has gone through a couple of hard drives and it's gasping for breath. It will drop for good one of these days.

I've setup some Hyper-V machines, but never had the need to take an old running server and virtualize it so I can scrap the old hardware.

What is the cheapest way to virtualize this box?

Their main server is 2008 with Peachtree (only a couple of users) and no other database activity, just 400GB or so of shared data. It would be nice to put the virtual machine on that. Or I could also pull an old 2003 server out of a closet to use for that.

Looking to get it done cheap though.....
 

Answer:Cheapest way to virtualize old Windows 2000 database server?

ESXi. It handles older OSes better than Hyper-V. Base version is free.
 

12 more replies
Relevance 48.38%

Hey guys, sorry if that title didn't quite explain the question. I was curious to know if there are any programs available that will allow you to pull the password from each account in active directory in a server 2003 environment and throw them into a database(or even just a .txt file). Thanks ahead of time.
 

Answer:Server 2003 Active Directory: Password Database?

I think they are encrypted
 

14 more replies
Relevance 48.38%

hi

I deployed my webapp in my client pc i dont have the only one to access that pc other user also viewing and using this pc/server.. so i want to lock /encrypt my wwwroot folder and my database if users attempts to copy my database / wwwroot folder then i dont want them to copy my db and folder..

I saw many articles but not a exect one that works.. I tried folder look to but i wont work on IIS if we locked folder..

So any best idea or any other tricks to do this...

Thanks
 

More replies
Relevance 48.38%

Hi
 
As per the title, i was locked out of my PC for a while except safe mode with an 0X50 error page fault in non paged area everytime startup was loading, having, tried diagnostic boot mode still did the same, run CHKDSK and having no luck i got a bit stuck as there were no System restore entries for some reason... eventually i remembered that there was another account on the computer and logged in using that. I ran SFC/scannow and nice and easy i got back into the main account.
 
Now i am back in the main account i cannot Network - i Have a cable from office PC to a shop till which is also on XP:
The Internet is via a wireless dongle through Office PC
Network Bridge carries Internet to Till
Connection to till mainly carries database from SQL Server and associated back office software and translates it onto the Till structure via connection software
As it stands i cannot connect through the Local area connection from Office to till - and the IP Address will not renew (in the IP Protocol  the automatically assign buttons are checked) Ipconfig release / renew times out
 
THE SQL Sever 2005 Management studio express when loading just says Package 'Microsoft SQL management studio package' failed to load Click OK and it says the same thing with a red cross, click OK again and it closes.
 
At the same time as this SQL wont load, the software we use as back office, which used the SQL database cant load as it can... Read more

Answer:0x50 - Overcame now no Networking or accessing SQL Server Database

That error usually relates to a driver or RAM issue.
Have you connected any new hardware recently?
If so, uninstall and reinstall that to see if that solves it.
If not, do a RAM check with memtest. You can download memtest from http://www.memtest.org/#downiso.
I have recently had this error on a computer and it turned out to be a faulty stick of RAM.

8 more replies
Relevance 48.38%

Hi all, nd helping hand here.

I had been asked to take over some others' "leftover" work and I guess this is the first that got me down..

in SQL Server 2005 express, there are some system database, and one of it is msdb.

because it was a important database, i will need "handle with care" advise...any way i can repair the msdb which was marked suspect?


 

More replies
Relevance 47.97%

Their original SQL Server was 2008, with SP unknown, but installed on D: and C: drives. The power spike corrupted their O/S on the C: drive and someone reinstalled both the O/S and the SQL Server, which is now SQL 2008, SP4. They have intact files for all system databases, both .mdb and .ldf. Is there some way they can reconnect with the user databases using the intact copies of the previous system databases?

I have heard that if the SQL Server is stopped, previous Master and Msdb .mdb and .ldf files moved into place and the server restarted, that any previous user database .mdb and .ldf files can be accessed by the SQL server.
Is this the case, or are there details missing?
 

Answer:Solved: Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and

Visit this site, it can be helpful:
http://www.filerepairforum.com/foru...roblem-how-do-i-fix-a-corrupted-database-file
- Insert the SQL Server Installation disc into the server computer's disc drive. Access the drive from your computer by clicking "My Computer" from the desktop and double-clicking the disc drive icon.
- Run setup.exe from the SQL server installation disc. The setup command should be located in the disc's root directory. Run the setup program by double-clicking "setup.exe." This will bring up the SQL server installation center page.
- Click the "Maintenance" button located on the lefthand side of the navigation window. Select "Repair" and then choose the language you wish the program to be presented in after installation. Click "Next" to continue. This will run setup routines, making sure your computer has all the prerequisites installed to correctly run SQL server 2008. Click "OK" or "Install" to continue. This will bring you to the Select Instance page.

- Select the instance you want to repair. This will reconfigure your server using automatic backups to a time the server was working correctly and reinstall any corrupted information. Click "Next." The repair rules will automatically verify the operation. Click "Next" to continue. This will take you to the Ready to Repair page.
- Click "Repair" and SQL server disc will run its repair function. The r... Read more

1 more replies
Relevance 47.97%

I created an application in Access 2007 with a form and database. I have to make it a client server type app now. I need to put just the database and report files on the server for 2 users to use. Each will have the form portion of the app. The app will now have to connect to the Access 2007 database on the server. I need to know the best approach to connecting to the database this way and how to use record locking. Originally I could just use CurrentDB on the form as it was integrated with the database. But to connect to the database on the server I tried using a connection object and creating a recordset that way. But I don't seem to be able to lock the record ussing existing things like the recordset locktype property or setting the Recordlocks property on the form.

Please help me figure out the best method, of the various ones, to connect to the database on the server, as in ADODB, DAO, database object or whatever, and how to use record locking so the 2 users cannot have the same record open at the same time.

Thank you!

Valhalla
 

Answer:Access 2007 connecting to database on server & record locking?

16 more replies