SqlServer Database BackUp and Restore
1) Copy 2 files. from SouceSystem Databasename.mdf , Database.ldf from installed sql server
folder (path:c:\program files]microsoftSql server\Data\datbasname.mdf)
2) Create a Database in Destination system .
3) Past 2 file in installed sql server location
(path:c:\program files]microsoftSql server\Data\datbasname.mdf)
4) Right click on destination database then click to attach datbase/files
5) Select appropriate databasename. mdf file
Note:Assume sql server installed in C Drive .Path can vary