I am doing an exercise: How to detach and mount a SQL Server FILESTREAM-enabled database
In the step Create 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
Everything 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 executed, I get the following error :
Msg 5120, Level 16, State 106, Line 1 The physical file "D: \ FileStreamDB \ FileStreamData" could not be opened. Operating system error -2147024891: "0x80070005 (could not get text for this error. Reason: 1815)."
SQL Server 2008 Enterprise ( ) Windows XP Professional. Microsoft
?