SQL SERVER – 2005 – T-SQL Script to Attach and Detach Database | Journey to SQL Authority with Pinal Dave

Following script can be used to detach or attach database. If database is to be from one database to another database following script can be used detach from old server and attach to new server. Process to move database : ----Step 1 : Detach Database using following script USE [master] GO EXEC master.dbo.sp_detach_db @dbname =… Continue Reading...

Source: SQL SERVER – 2005 – T-SQL Script to Attach and Detach Database | Journey to SQL Authority with Pinal Dave