How to move SQL Server Database MDF/LDF files to new location (change database location)

preview_player
Показать описание

Steps.
Find database name / logical database name and file location.
Modify file location using commands.
Move physical files (mdf + ldf or just mdf if database is in simple mode)
Set database OFFLINE and ONLINE

ALTER DATABASE DBName
MODIFY FILE ( NAME = DBLogicalName_Data,
GO

ALTER DATABASE DBName
MODIFY FILE ( NAME = DBLogicalName_Log,
GO

ALTER DATABASE DBName SET OFFLINE;
GO
ALTER DATABASE DBName SET ONLINE;
Рекомендации по теме
Комментарии
Автор

thank you i searching move drive c to drive d

mydrhow