If you would like to move an existing database to another server, you can do so following this method.

1. Remote Desktop onto the server where the DB is located.

2.  Open up SQL Server Manager.

3. Right Click the database you wish to backup, select 'task', 'backup'.

       Backup Save Locations: ez01, F:\SQLDATA

                                      amazon, M:\SQLDATA

4. Remote to the server you wish to restore on

5. Open SQL Server Management Studio

6. Right Click the DB you wish to restore.

7. Source for restore is 'From Device', backup media file

8. Add the file you just saved as a backup in the SQLDATA directory.  Note: if file existed when backup was created, multiple restore points will be appended to file.

9. 'To Database' - Give filename (EZ_filename

10. When restore is complete, nave to folder in object explorer.EZ_NewBupRestore\Security\users... Delete user 'EZ'

11. Now navigate to databases\security\logins...Double click user 'EZ'

12. Within 'Login Properties Window', select user mapping.

13. Find your newly restored DB and check true.  Also, check DB_owner in the lower window.

Done...