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

Content with tag detach Rss

   Items 1 to 8 of 8   
 

Get Detach or Attach all user databases script

Script to generate script to detach or attach user databases   Read more...
By Harsha Majety 2013/02/15 | Source: SQLServerCentral.com | Category: attach database
Rating: |  Discuss |   Briefcase | 892 reads

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,873 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,756 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,084 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,474 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,348 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,756 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,564 reads
   Items 1 to 8 of 8   
 
Tags
attach (3)    
administration (2)    
alter database (1)    
alter database modify file (1)    
amo (1)    
analysis services (ssas) (1)    
attach database (1)    
collation (1)    
disk space (1)    
filestream (1)    
show advanced options (1)    
sql server 2008 (1)    
xp_cmdshell (1)