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

Articles with tag attach Rss

Search for any content tagged attach

   Items 1 to 5 of 5   
 

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,920 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,869 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,360 reads

Attaching a database in Microsoft SQL Server 2008

Various methods of using the "For Attach" clause exist to overcome the limitations that face us when using sp_attach_db and sp_attach_single_file_db. The first installment illustrates the use of the "Create Database" statement for the "For Attach" and "for ATTACH_REBUILD_LOG" arguments, for a single .MDF file and single .LDF file.  Read more...
By Additional Articles 2009/08/24 | Source: Database Journal | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 2,488 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,869 reads
   Items 1 to 5 of 5