detach database

Script

For successful run, Your SQL Server service account should have permission to old location & new location

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

3 (3)

You rated this post out of 5. Change rating

2015-05-27 (first published: 2015-05-10)

991 reads

Discuss

How to Detach and Attach a SQL Server FILESTREAM Enabled Database

by Additional Articles

MSSQLTips.com

detach database

Article

Most SQL Server DBAs have questions about how to detach and attach a FILESTREAM enabled databases. In this tip, we will take a look at the steps Database Administrators need to follow in order to detach and attach a FILESTREAM database once Data, Log and FILESTREAM container files have been moved from the default location to a new location. This tip includes a general explanation of the FILESTREAM technology introduced with SQL Server 2008. This is followed by examples and scripts to detach and attach FILESTREAM enabled database in your environment.

2009-11-17

2,599 reads