A small script to quickly restore a Sharepoint 2007 content database from backup:

USE master
GO

ALTER DATABASE SITE_WSS_Content
SET SINGLE_USER WITH
ROLLBACK AFTER 5
GO

RESTORE DATABASE SITE_WSS_Content
FROM DISK = 'path_to_backup\SITE_WSS_Content_backup_201201122000.bak'
WITH REPLACE
GO

ALTER DATABASE SITE_WSS_Content
SET MULTI_USER
GO