Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can a database server store its files on another network server?

Status
Not open for further replies.

steveroot

IS-IT--Management
Dec 29, 2000
20
GB
Strange question i know but..

Our small office is growing, I need to either a) buy some network attached storage or b) buy a proper file server. I would rather do a) as it is cheaper and simpler, and still allows me to organise backups of all our data.

However, I expect next year we will need to get a database server (currently we all use MS Access through a shared file on a Win98 machine, so I realise it will begin to slow down as the database grows as the whole table is read over the network for each request by each machine). If we have a database server programme running on a machine (SQL Server/MySQL?), will it connect to the files stored on the Network AND NOT need to access and read all the tables every time its asked a question? I realise that a database server will reduce the network traffic as it only sends the results of a query, and not the whole table. But if the database has to read the whole table in for each and every request over the network, then there is no point me buying network storage now and expecting it to handle our growth later on.

I hope that makes sense, and if anyone can let me know which way it works I'd be much obliged.

Thanks,
Steve Root --
Steve Root
 
Store the data on the same machine that runs the database server. If you want SQL-server, you also need NT- server.
Put a win98 machine with Interbase as database server S. van Els
SAvanEls@cq-link.sr
 
thanks svanels,

you've confirmed what i thought, and i've since discovered that a NAS with mirrored disks costs just as much a server!

Now, where did I leave the piggy bank.... --
Steve Root
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top