detach database

External Article

How to Detach and Attach a SQL Server FILESTREAM Enabled 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

Blogs

Query multiple Azure SQL Databases

By

I was sick of changing context in Azure Data Studio while cleaning up things...

KDA: Echoes of Deception - Case 3

By

The crime spree in Digitown is not ending. This time 20 cars have been...

The Book of Redgate: Do Your Best Work

By

One of our mission statements in the Book of Redgate says: attempt to do...

Read the latest Blogs

Forums

Helpful Management Studio Settings and Features

By Tony Savoie

Comments posted to this topic are about the item Helpful Management Studio Settings and...

The Minimal Linked Server

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Minimal Linked Server

The AI View From Above

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The AI View From Above

Visit the forum

Question of the Day

The Minimal Linked Server

What is the minimal number of parameters to add a linked server with sp_addlinkedserver?

See possible answers