Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag attach Rss

   Items 1 to 8 of 8   
 

Database File Move Etc

A stored procedure to generate database file moves along with Robocopy script and the attach / detach scripts  Read more...
By M Higgins 2016/04/20 | Source: SQLServerCentral.com | Category: attach
Rating: |  Discuss |   Briefcase | 357 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,988 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 | 29,120 reads

Dynamically script Create Database For Attach For All Databases

Modified version of a script that can be found at http://www.sqlservercentral.com/Contributions/InstallEditor   Read more...
By David Benoit 2010/05/20 | Source: SQLServerCentral.com | Category: attach
Rating: |  Discuss |   Briefcase | 3,242 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,404 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,600 reads

Dynamically script Create Database For Attach For All Databases

Modified version of a script that can be found at http://www.sqlservercentral.com/Contributions/InstallEditor   Read more...
By David Benoit 2010/05/20 | Source: SQLServerCentral.com | Category: attach
Rating: |  Discuss |   Briefcase | 3,242 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 | 29,120 reads
   Items 1 to 8 of 8   
 
Tags
detach database (3)    
administration (2)    
sql server 2008 (2)    
alter database (1)    
alter database modify file (1)    
collation (1)    
detach (1)    
move (1)    
robocopy (1)    
show advanced options (1)    
xp_cmdshell (1)