sql server data on a file server

Question

Post reply

sql server data on a file server

Juanita

SSCertifiable

Points: 5300
More actions
March 13, 2003 at 1:06 pm

#80471

HI,
I was wondering if someone can tell me how I would access sql data that resides on a file server that does not have sql server installed. Currently all of our sql data resides on the same box as the sql database itsself.
Thank you!
Juanita

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Rodrigo Acosta SSC-Insane Points: 21261 More actions · Answer 1

You mean you have you sql server in an server and all the data and log files in another server?

It doesn't matter where you have your data files, you must access to where the SQL server is installed.

If this is right, did you test performance having the data files on a file server, having other users accesing other files?

Juanita SSCertifiable Points: 5300 More actions · Answer 2

Currently we have sql server installed and on that same server is my sql data and log files. We are looking at a metafile system that would want to store ITS data on a file server and sql server would need to access that data. sql server right now accesses all the sql data right from its' own box. I hope that made sense. We do not have this file server set up yet. I just wanted to know how do you tell sql server to look on another box for the data?

thank you..

Juanita

tcartwright SSCertifiable Points: 5573 More actions · Answer 3

Are talking a NAS or SAN solution? Or a RAID fibre channel?

Tim C.

//Will write code for food

Tim C //Will code for food

Juanita SSCertifiable Points: 5300 More actions · Answer 4

Tim, Our network administrator said the file server would be a completely seperate server. In reference to a SAN and NAS and the Fiber channel, the SQL server would be direclty attached... Does this answer your question?

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 5

Juanita, if you are talking about placing SQL Server data files on a network file share and then using those as data files for a database on your server, that is not possible. SQL Server databases can only have data files stored locally or on a SAN/NAS etc.

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 6

This reminds me of something I read on James Gosling's site:

http://java.sun.com/people/jag/Fallacies.html

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

K. Brian Kelley
@kbriankelley

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 7

Read Following KB for support network database files.

http://support.microsoft.com/default.aspx?scid=kb;en-us;304261

Juanita SSCertifiable Points: 5300 More actions · Answer 8

Thank you to all that replied. Come to find out from a meeting today, the data that is to be stored on the file server is not sql data. Yesterday I was told it was going to be sql data. But I did learn alot from this thread. thank you very much again!