SQL Server 2008 Filestream：使用文件流创建数据库时出错

发布于 2024-10-20 07:02:53 字数 1363 浏览 4 评论 0原文

我正在进行练习：如何分离和附加启用 SQL Server FILESTREAM 的数据库

在创建启用 FILESTREAM 的数据库步骤中，我执行以下代码

Use Master
GO
IF EXISTS (SELECT name FROM sys.databases WHERE name = N'FileStreamDB')
DROP DATABASE FileStreamDB
GO
USE master
GO
CREATE DATABASE [FileStreamDB] ON PRIMARY 
( NAME = N'FileStreamDB', FILENAME = N'D:\FileStreamDB\FileStreamDB.mdf', 
SIZE = 10MB , MAXSIZE = UNLIMITED, FILEGROWTH = 10% )
LOG ON 
( NAME = N'FileStreamDB_log', FILENAME = N'D:\FileStreamDB\FileStreamDB_log.ldf' , 
SIZE = 10MB , MAXSIZE = UNLIMITED , FILEGROWTH = 10%)
GO
ALTER DATABASE [FileStreamDB] 
ADD FILEGROUP [FileStreamGroup] CONTAINS FILESTREAM 
GO

一切正常，直到我运行最后一步：

ALTER DATABASE [FileStreamDB] 
ADD FILE (NAME = N'FileStreamDB_FSData', FILENAME = N'D:\FileStreamDB\FileStreamData')
TO FILEGROUP FileStreamGroup
GO

执行此代码时，我收到以下错误：

消息 5120，第 16 级，状态 106，第 1 行无法打开物理文件“D:\FileStreamDB\FileStreamData”。操作系统错误-2147024891： “0x80070005（检索文本失败对于这个错误。原因：1815）”。

我在 Windows XP Professional 上运行 SQL Server 2008 Enterprise（评估许可证）。文件流按照微软说明

导致该错误的原因是什么？

原文

I am going through an exercise: How to Detach and Attach a SQL Server FILESTREAM Enabled Database

In the step Creating a FILESTREAM Enabled Database I execute the following code

Use Master
GO
IF EXISTS (SELECT name FROM sys.databases WHERE name = N'FileStreamDB')
DROP DATABASE FileStreamDB
GO
USE master
GO
CREATE DATABASE [FileStreamDB] ON PRIMARY 
( NAME = N'FileStreamDB', FILENAME = N'D:\FileStreamDB\FileStreamDB.mdf', 
SIZE = 10MB , MAXSIZE = UNLIMITED, FILEGROWTH = 10% )
LOG ON 
( NAME = N'FileStreamDB_log', FILENAME = N'D:\FileStreamDB\FileStreamDB_log.ldf' , 
SIZE = 10MB , MAXSIZE = UNLIMITED , FILEGROWTH = 10%)
GO
ALTER DATABASE [FileStreamDB] 
ADD FILEGROUP [FileStreamGroup] CONTAINS FILESTREAM 
GO

It all works fine until I run the last step:

ALTER DATABASE [FileStreamDB] 
ADD FILE (NAME = N'FileStreamDB_FSData', FILENAME = N'D:\FileStreamDB\FileStreamData')
TO FILEGROUP FileStreamGroup
GO

When this code is execute I am getting the following error:

Msg 5120, Level 16, State 106, Line 1
Unable to open the physical file "D:\FileStreamDB\FileStreamData".
Operating system error -2147024891:
"0x80070005(failed to retrieve text
for this error. Reason: 1815)".

I run SQL Server 2008 Enterprise (Evaluation Licence) on Windows XP Professional. The filestream is configured as per microsoft instructions

What can be the cause of that error?

分享到QQ

分享到微博