Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag detach Rss

Search for any content tagged detach

   Items 1 to 7 of 7   
 

Change Server Collation in SQL Server 2008

How can I change the collation of SQL Server 2008? Learn how in this short tutorial.  Read more...
By Kevin Sermijn 2011/03/15 | Source: SQLServerCentral.com | Category: collation
Rating: |  Discuss |   Briefcase | 5,912 reads

Moving Database Files Detach/Attach or ALTER DATABASE?

Learn why ALTER DATABASE should be preferred over Detach/Attach for moving database files on the same SQL Server from MVP Jonathan Kehayias.  Read more...
By Jonathan Kehayias 2010/09/24 (first published: 2009/05/27) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 28,848 reads

How to Detach and Attach a SQL Server FILESTREAM Enabled Database

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.  Read more...
By Additional Articles 2009/11/17 | Source: MSSQLTips.com | Category: detach
Rating:  Rate this |   Briefcase | 2,115 reads

Managing Free Space

A new article from Paul Els looks at managing free space on your database servers by finding detached databases and old backup files.  Read more...
By Paul Els 2009/09/10 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,496 reads

Moving Databases with the ALTER Command

A script that will move the files of a passed set of databases to a new data folder and log folder from James DiMauro.  Read more...
Rating: |  Discuss |   Briefcase | 8,357 reads

Moving Database Files Detach/Attach or ALTER DATABASE?

Learn why ALTER DATABASE should be preferred over Detach/Attach for moving database files on the same SQL Server from MVP Jonathan Kehayias.  Read more...
By Jonathan Kehayias 2010/09/24 (first published: 2009/05/27) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 28,848 reads

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

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.  Read more...
Rating:  Rate this |   Briefcase | 1,588 reads
   Items 1 to 7 of 7