detach database using ssms

SQL Detach Database, when you detach a database from SQL Server, database is removed from the instance of SQL Server but kept the database intact within its data files and transaction log files.

 2,604 total views