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.

SQL Server 2008 Database Mirroring in Action

by GlennBerry

SQLServerCentral.com

Blogs

I have been pretty busy with a server consolidation and move project at work. We had four Dell PowerEdge 6800...

The Conference Benefit

by Steve Jones

SQLServerCentral.com

Editorial - WMV

Why attend a conference? After the PASS Summit and SQL Connections, Steve Jones shares a few thoughts about the benefits of attending a conference for employees.

The Conference Benefit

by Steve Jones

SQLServerCentral.com

Editorial - iPod

Why attend a conference? After the PASS Summit and SQL Connections, Steve Jones shares a few thoughts about the benefits of attending a conference for employees.

The Conference Benefit

by Steve Jones

SQLServerCentral.com

Editorial - MP3

Why attend a conference? After the PASS Summit and SQL Connections, Steve Jones shares a few thoughts about the benefits of attending a conference for employees.

Surely It Should Just Work?

by Phil Factor

SQLServerCentral.com

Editorial

Does a programmer need to know how his code gets executed? Arguably, developers should focus on database structures rather than a particular implementation, and Phil tries to convince us that good programming is not just knowing everything about your programming environment.

Testing at Scale

by Steve Jones

SQLServerCentral.com

Editorial

It seems that many companies don't have the luxury of working with a variety of hardware configurations to test their architecture before deploying their applications. Some of the issues involve time and some involve tools. Steve Jones has an idea that could help with the latter today.

Full Text Catalog Configuration in SQL Server 2005 Express Edition

by Additional Articles

Database Journal

SQL Server Express

Having concluded our discussion of Reporting Services in SQL Server 2005 Express Edition, we now begin an examination of Full Text Indexing and Search.