How do I move a SQL Server database?

With an Access database it is so simple I just move the mdb file. What do I do in SQL Server?

sp_attach_db 'pubs','C:\MSSQL7\Data\pubs.mdf'

sp_detach_db 'pubs'

EXEC sp_detach_db @dbname = 'pubs'

EXEC sp_attach_single_file_db @dbname = 'pubs',

    @physname = 'C:\MSSQL7\Data\pubs.mdf'

EXEC sp_attach_db @dbname = N'pubs',

    @filename1 = N'C:\MSSQL7\Data\pubs.mdf',

    @filename2 = N'C:\MSSQL7\Data\pubs_log.ldf'