MSSQL attach mdf

2019/03/23

https://docs.microsoft.com/en-us/sql/relational-databases/databases/attach-a-database?view=sql-server-2017#to-attach-a-database-1

CREATE DATABASE Timeless
  ON (FILENAME = '/home/wuu/CSharp/Timeless.mdf'),
  (FILENAME = '/home/wuu/CSharp/Timeless_log.ldf')
  FOR ATTACH;

https://docs.microsoft.com/en-us/sql/relational-databases/databases/detach-a-database?view=sql-server-2017#to-detach-a-database-1

EXEC sp_detach_db 'AdventureWorks2012', 'true';