Sql Server 使用网络数据库文件

参考：Description of support for network database files in SQL Server
Microsoft SQL Server: How to attach database from network drive?
Attach a remotely stored database

• 建议使用本地数据库文件：because this configuration optimizes SQL Server performance and reliability.
• 默认是不支持：NAS的(Network Attached Storage)
• 仅 SQL Server 2008 R2 及以后版本可用

CREATE DATABASE [DestinedForGreatness]
ON  PRIMARY
( NAME = N'DestinedForGreatness', FILENAME = N'\\LittleBlackBox\SQL2012data\MSSQL\Data\DestinedForGreatness.mdf' )
LOG ON
( NAME = N'DestinedForGreatness_log', FILENAME = N'\\LittleBlackBox\SQL2012data\MSSQL\Data\DestinedForGreatness_log.ldf')
GO

• 2008和之前的版本需要启动 -T1807 跟踪标记

–Turn On Allow Attach from Network Drive (UNC)
DBCC TraceOn(1807)
–Attach the database
EXEC sp_attach_db @dbname = N’DatabaseName’, 
   @filename1 = N’\\ServerName\SQL Data\DatabaseName_Data.MDF’, 
   @filename2 = N’\\ServerName\SQL Log\DatabaseName_Log.LDF’
–Turn Off Allow Attach from Network Drive (UNC)
DBCC TraceOff(1807)