EXEC sp_detach_db @dbname = ‘Northwind’
EXEC sp_attach_single_file_db @dbname = ‘Northwind’,
@physname = ‘D:\Program Files\SQLDATA\MSSQL\Data\northwnd.mdf’
![variable.jp [データベース,パフォーマンス,運用]](https://variable.jp/wp-content/uploads/2013/09/cropped-variable.jp_.jpg)
EXEC sp_detach_db @dbname = ‘Northwind’
EXEC sp_attach_single_file_db @dbname = ‘Northwind’,
@physname = ‘D:\Program Files\SQLDATA\MSSQL\Data\northwnd.mdf’