Best method to migrate data and all objects related to particular database is by using backup and restore method.Backup database on current server and copy it to new server and restore it there.You would have to migrate logins and jobs pertaining to database manually. If you want to have exactly same copy a you said you can also use [attach and detach method][1] to move database from one server to other. You can take help of [This link][2] to migrate logins between instance of SQL Server. If you have any jobs which were specific to database you are migrating you would have to script out jobs and run the script on new server to manually create jobs SQL server 2005 is out of mainstream support its highly advisable to upgrade to latest SQL server version and make sure all SQL Server instances are patched to SP4 [1]: http://msdn.microsoft.com/en-gb/library/ms187858%28v=sql.90%29.aspx [2]: https://support.microsoft.com/kb/918992/en-gb