SQLServerCentral.com Articles tagged detach

Change Server Collation in SQL Server 2008

Tue, 15 Mar 2011 06:00:00 UT

How can I change the collation of SQL Server 2008? Learn how in this short tutorial.

Moving Database Files Detach/Attach or ALTER DATABASE?

Fri, 24 Sep 2010 06:00:00 UT

Learn why ALTER DATABASE should be preferred over Detach/Attach for moving database files on the same SQL Server from MVP Jonathan Kehayias.

How to Detach and Attach a SQL Server FILESTREAM Enabled Database

Tue, 17 Nov 2009 07:00:00 UT

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.

Managing Free Space

Thu, 10 Sep 2009 06:00:00 UT

A new article from Paul Els looks at managing free space on your database servers by finding detached databases and old backup files.

Moving Databases with the ALTER Command

Wed, 26 Aug 2009 06:00:00 UT

A script that will move the files of a passed set of databases to a new data folder and log folder from James DiMauro.

Moving Database Files Detach/Attach or ALTER DATABASE?

Fri, 24 Sep 2010 06:00:00 UT

Learn why ALTER DATABASE should be preferred over Detach/Attach for moving database files on the same SQL Server from MVP Jonathan Kehayias.

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

Detach and attach Analysis Service Database using Windows PowerShell and SQL Server 2008 AMO

Fri, 17 Apr 2009 06:00:00 UT

This installment of our series on " Microsoft Windows PowerShell and SQL Server 2008 AMO" examines the various types of Analysis service database detach and attach methods.