SQL Server database backup restore another party method

server| Backup | data | Database direct copy of data files copy the data files (*.mdf) and log files (*.ldf) from the database to the destination server and restore the statements in SQL Server Query Analyzer: EXEC sp_attach_db @dbname = ' Test ', @filename1 = ' d:\mssql7\data\test_data.mdf ', @filename2 = ' d:\mssql7\data\test_log.ldf ' This attaches the test database to SQL Server and can be used as usual. If you do not want to use the original log file, you can use the following command: exec sp_detach_db @dbname = ' test ' exec sp_attach_single_file_db @dbname = ' Test ', @physname = ' d:\ Mssql7\data\test_data.mdf ' The function of this statement is simply to load the data file, which can be automatically added by the SQL Server database, but the data recorded in the original log file is lost.