EXEC sp_detach_db @dbname = ‘Northwind’
EXEC sp_attach_single_file_db @dbname = ‘Northwind’,
   @physname = ‘D:\Program Files\SQLDATA\MSSQL\Data\northwnd.mdf’

 

sp_attach_single_file_db.gif

Comments are closed.

Post Navigation