Solved

Buffallo NAS Storage Issue

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

Give your grad a cloud of their own!

With up to 8TB of storage, give your favorite graduate their own personal cloud to centralize all their photos, videos and music in one safe place. They can save, sync and share all their stuff, and automatic photo backup helps free up space on their smartphone and tablet.

Join & Write a Comment

Suggested Solutions

Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
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 Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

760 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now