SQL database as a remote drive or NAS

Posted on 2010-03-26
Medium Priority
Last Modified: 2012-05-09
How do I set up SQL 2008 to store database files on a remote drive ar a NAS?
If I go to Server Properties and select Database Settings, under Database default locations I am only given the options for locat drives.  I want to store all of my data on a NAS.
Is this even possible?
Question by:Bojik
  • 2
  • 2
LVL 25

Accepted Solution

DBAduck - Ben Miller earned 1000 total points
ID: 28709041
You cannot do that unless you use Junctions and even then i am not sure how SQL would handle it.

SQL has to be able to see the drive and control it, and usually the NAS drives are not hard wired enough for SQL to put a database on it.

But you could try a junction on a folder of a physical drive to point to the NAS drive and see if SQL Server likes it.  The problem is that if ever, and I mean ever, the NAS goes away for even just a moment, you could have some pretty good corruption in the SQL Server database.

Author Comment

ID: 28712871
So how would you handle a SQL server within a Virtural setup?  I have dual 300GB drives on raid1, currently they are not even half full and the server allows for only two drives.  If I ever out grow the 300GB what are my options (outside of new servers).
LVL 25

Expert Comment

by:DBAduck - Ben Miller
ID: 28713917
iSCSI or SAN connectivity.

Author Comment

ID: 28713948
ok, thanks

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
If you try to migrate from Elastix to Issabel, you will face a lot of issues. These problems are inevitable but fortunately, you can fix them. In the guide below, I will explain how I performed the migration while keeping all data and successfully t…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

599 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question