Find Log In

^{Home Applications}

MsSQL

Moving database to new location

USE MASTER;
GO
-- Put database into single user mode
ALTER DATABASE DB_NAME
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO

-- Detach database
EXEC MASTER.dbo.sp_detach_db @dbname = N'DB_NAME'
GO

-- Re-attach database
CREATE DATABASE [DB_NAME] ON
( FILENAME = N'X:\NEW_PATH\db_name.mdf' ),
( FILENAME = N'X:\NEW_PATH\db_name_log.ldf' )
FOR ATTACH
GO