Quickly append SQL Server database files without log files!

Quickly append SQL Server database files without log files:

 

1 Create   Database   [ Database Name ]
2 On (Filename =   ' Database file path and file name (for example, D: \ dB \ mydb. MDF) ' )
3 For Attach_rebuild_log;
4 Go

Or

 

Use master;
Exec sp_detach_db @ dbname = 'dbname ';
Exec sp_attach_single_file_db @ dbname = 'dbname', @ physname = 'H: \ ***. MDF'

 

Large database file attachment is supported!