RE: Which is the best option used to move database fro...
Its very simple.
Take the latest backup of the database in any shared directory on the same server.
Copy the backup to the new server where you want to restore the database. Restore it using Enterprise Manager or SQL Query Analyser.
If you are restoring transaction Log backup be sure that you are attaching all the logfiles in the same sequence they were backed up followed by completed database backup. Also keep the database non-operational while restoring transaction log backup.
RE: Which is the best option used to move database fro...
Copy the data files and transaction log files from your old SQL Server's hard drive (for example D:MSSQLData) to the new SQL Server's hard drive (to the same location, in this example, D:MSSQLData). Since we are copying all database files, including the system databases (like master, model, msdb, distribution), your server level settings, jobs, DTS packages, alerts, operators, logins etc. will be copied across.
RE: Which is the best option used to move database fro...
Import-Export is the best feature to move a database coz' it doesn't need the same file system.whereas in Backup-Restore we need the same file system.Import-Export is more reliable
