Solved

Buffallo NAS Storage Issue

Posted on 2014-01-20
1
203 Views
Last Modified: 2014-02-08
Hi, Experts

I have NAS Storage device of 12 TB, its network storage  i need to create sql server 2008 Database on the NAS Storage device  , but problem is its allow map the drive but not consider as local drive like c:\ drive and the sql server database only allow to create database on local drive .

Is there is any way to solve this issue. ?
0
Comment
Question by:Asrar Azmi
1 Comment
 
LVL 17

Accepted Solution

by:
Chris Millard earned 500 total points
ID: 39794134
By default, SQL will not allow you to store a database on a NAS unit. However, if the NAS meets certain write guarantees, then it may be possible.

See this MS article:-

http://support.microsoft.com/kb/304261
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

AWS Glacier is Amazons cheapest storage option and is their answer to a ‘Cold’ storage service.  Customers primarily use this service for archival purposes and storage of infrastructure backups.  Its unlimited storage potential and low storage cost …
I previously wrote an article addressing the use of UBCD4WIN and SARDU. All are great, but I have always been an advocate of SARDU. Recently it was suggested that I go back and take a look at Easy2Boot in comparison.
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

809 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