Solved

Buffallo NAS Storage Issue

Posted on 2014-01-20
1
202 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

We wanted to provide an in-depth explanation of the Ping Node offering clarifications on its function and usage. Incorrect Ping Node configuration and functionality can cause problems with HA clusters. The importance of this article is critical for …
Concerto Cloud Services, a provider of fully managed private, public and hybrid cloud solutions, announced today it was named to the 20 Coolest Cloud Infrastructure Vendors Of The 2017 Cloud  (http://www.concertocloud.com/about/in-the-news/2017/02/0…
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…

776 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