Move a FILESTREAM-Enabled Database
This topic shows how to move a FILESTREAM-enabled database.
The examples in this topic require the Archive database that is created in Create a FILESTREAM-Enabled Database.
To move a FILESTREAM-enabled database
In SQL Server Management Studio, click New Query to open the Query Editor.
Create the folder C:\moved_location, and then move the files and folders that are listed in step 2 into it.
Copy the following Transact-SQL script into the Query Editor, and then click Execute. This script sets the Archive database online.
CREATE DATABASE Archive ON PRIMARY ( NAME = Arch1, FILENAME = 'c:\moved_location\archdat1.mdf'), FILEGROUP FileStreamGroup1 CONTAINS FILESTREAM( NAME = Arch3, FILENAME = 'c:\moved_location\filestream1') LOG ON ( NAME = Archlog1, FILENAME = 'c:\moved_location\archlog1.ldf') FOR ATTACH GO