Method 1: remote backup, local recovery
BackUp DataBase Database Name
to disk =''''physical address
RESTORE DATABASE database name
FROM DISK =''physical address of the backup file''
WITH MOVE''data file logical name''TO''data files''the new physical address,
MOVE''log file logical name''TO''data files''the new physical address
Method 2: Remote separation, the local additional
Step 1: Use the sp_detach_db stored procedure on the separation of the source server database. Associated with the database. Mdf,. Ndf and. Ldf these three files to the target server
Step 2: Use the sp_attach_db stored procedure to attach to the target database server, and point in the previous step to copy the file to the target server
Method 3: Import and export data
Use Data Transformation Services Import and Export Data Wizard to copy the entire database or selectively to the source database objects and data replication to the target database