Kod
EXEC sp_detach_db 'pubs', 'false'
 
 
EXEC sp_attach_db @dbname = 'pubs',
     @filename1 = 'C:\MSSQL\Data\pubs.mdf',
     @filename2 = 'C:\MSSQL\Data\pubs_log.ldf'
 
 
 
EXEC sp_attach_single_file_db @dbname = 'pubs',
     @physname = 'C:\MSSQL\Data\pubs.mdf'